lefred's blog


There Are 10 Types of People in the World....

MySQL Shell and storing passwords

If you plan for example to have a bastion host in the cloud to access all your MySQL servers and use only MySQL Shell, the first time you connect to one of the host, you will realize that MySQL Shell prompts for a password but doesn’t ask you to store it of not. Example: mysqlsh fred@192.168.5.94 Please provide the password … Read More


From MySQL Group Replication to MySQL InnoDB Cluster

I wanted to be brave and I installed MySQL Group Replication manually…. it was painful ! Then I realized that managing those servers and especially deal with MySQL Routers was even more painful ! What are my options now ? Is there a solution or do I need to restart from scratch ? Asking the answer is already answering it… … Read More


MySQL – Keep an eye on your auto_increment values

In MySQL, it’s very common and recommended to you an auto_increment as Primary Key. However that integer can have different types each having their size limitation, and they can also be signed or not. Many people when creating a table use by default the following syntax do define their auto_increment primary key: id int auto_increment primary key This is a … Read More


MySQL 8.0 InnoDB Cluster with WordPress in OCI – part III

With this post we are reaching the end of our journey to HA for WordPress & MySQL 8.0 on OCI. If you have not read the two previous articles, this is just the right time. MySQL 8.0 InnoDB ReplicaSet with WordPress in OCI MySQL 8.0 InnoDB ReplicaSet with WordPress in OCI – part II We started this trip using the … Read More


MySQL 8.0 InnoDB ReplicaSet with WordPress in OCI

Today’s article is again related to WordPress and MySQL 8.0. We will see how we can setup MySQL InnoDB ReplicaSet and configure WordPress to split the load using both MySQL Instances: we will split reads and writes between the Primary and the Secondary member of our ReplicaSet. This will be the first part of our journey to achieve HA for … Read More


I deeply value the diversity of MySQL developers, users, community and my blog readers. I cannot agree the suffering, oppression, and systemic racism the Black community faces every day. Black lives matter.
recent
categories