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...

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...

Even as an experienced consultant, you don't think about many things until you are faced with them. I have put several InnoDB clusters including MySQL router into operation over the past few years. Up to now, this was always an interactive process where it was no problem to simply enter the passwords of privileged users (at the console). It was cle...