With the brand-new Innovation Release 8.1.0, Oracle has once again given the MySQL InnoDB Cluster a new “feature”: “Read Replicas”. This allows an InnoDB cluster to be supplemented with additional read-only instances. This article explains how this works and why it can make sense. A, B, C An InnoDB cluster usually consists of three nodes that provi...
We frequently experience situations where PowerShell scripts need to be run as local system (NT AUTHORITY\SYSTEM). For one of our customers, we wanted to use this method to store a password encrypted by Export-Clixml with the key of the local system, so that another process can decrypt and use it again with Import-Clixml. What are the options? Seve...
One of the typical requirements for new software is a prescribed minimum level of code coverage, i.e., the proportion of the source code that is executed by automated tests. Especially in areas such as medical technology, the automotive industry, or financial systems, 100 % code coverage is often required. But even code that is completely covered b...
A few days ago, I changed the service account of the SQL Server instances in my lab environment for Always On Availability Groups and now use a group Managed Service Account (gMSA). In the following, I present the necessary adjustments. Which service account do we recommend? As a service account for Microsoft SQL Server, we now generally recom...
Which services have been created during the installation? After installing a SQL Server instance, I typically look at the installed services with the customer or training participants. During installation, the “SQL Server Configuration Manager” is set up and linked in the Windows Start menu. The advantage of this interface is that only the services...
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...