Make yourself invisible: MySQL Generated Invisible Primary Keys
Matthias Jung
MySQL (PDO)
Now and then, smaller, or larger problems arise during consulting missions involving MySQL, which we would like to report here. In this case, our customer wanted to replace a MySQL single instance with a MySQL InnoDB cluster with three nodes. We have reported about the cluster here several times and do not discuss it in detail here. In this specifi...
Weiterlesen
SQL Server and Kerberos: Please do not forget the Service Principal Names
Andreas Jordan
Data Management
When using Windows authentication for a connection to a Microsoft SQL Server, Kerberos is the first choice. Only if the use of this authentication scheme is not possible, NTLM (NT LAN Manager) is used. This is transparent for the user, and NTLM does not impose any restrictions in most cases. Therefore, in many environments it is not even noticed th...
Weiterlesen
Put that away: The MariaDB Storage Engine S3
Matthias Jung
MySQL (PDO)
Many customers operate databases that are constantly growing. This was also the case in this specific instance. Our client operates a very large MariaDB server with several hundred terabytes of data. A large part of the data must remain stored and accessible for regulatory reasons. Changes to this data are no longer made, but must be kept readable....
Weiterlesen
"Deflate!": Detecting Buffer Pool Fragmentation in SQL Server
Andreas Jordan
Data Management
In database systems, the size of the main memory has a significant impact on performance. The goal is to keep as much relevant data as possible in the memory. Due to the structure of the memory, it can happen that part of the memory contains "air" in a figurative sense that could be used much more sensibly. Fortunately, Microsoft SQL Server provide...
Weiterlesen
Streamlining Login with Hashicorp Vault´s Single-Sign-On Solution
Philipp Srock
Cloud Services
In IT, regulations and laws dictate the way Cybersecurity is supposed to be handled. To meet requirements in a rather comfortable way, Single-Sign-On (SSO) turns out to be the go-to solution. We have taken a closer look at a major player in the field: Hashicorp Vault  Unlock the Power of Single-Sign-On: Say Goodbye to Multiple Passwords With t...
Weiterlesen
ksqlDB, the superpower in the Kafka universe - Part 2
Muriel Djanko Kamdoum
News
KsqlDB is an event streaming database for building stream processing applications on top of Apache Kafka. In the previous article, ksqlDB was introduced and the benefits, and reasons for the existence of another solution within the Kafka universe to build stream processing applications were outlined. KsqlDB proposes a different approach to Kafka St...
Weiterlesen