lefred's blog


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

MySQL 8.0 : more about new authentication plugin and replication

MySQL 8.0’s new default authentication plugin means more secure connections for users connections but also for replication… but you need to be aware of it ! Yesterday Giuseppe – the datacharmer – Maxia, submitted a bug related to a strange behavior of MySQL’s replication. He observed that after creating a new user for replication (using the new authentication method, caching_sha2_password), … Read More


MySQL HA Architecture #1 : InnoDB Cluster & Consul

  I received many request about MySQL High Availability Architecture. There are a lot of tools, but how can we use them to achieve MySQL HA without over engineering everything. To answer such demand, there is no generic architecture, of course there are leaders in solutions, but put them together can result in many different designs, I will start a … Read More


MySQL InnoDB Cluster: how to handle performance issue on one member ?

  Sometimes when you are using a MySQL InnoDB Cluster, you might encounter some performance issue because one node becomes dramatically slow. Why ? First of all, why ? A node can apply the transactions slower than the other nodes for many different reasons. The most frequents are for example, slower disks (remember, it’s advised to have nodes with the … Read More


Reduce human interaction when using an asynchronous slave to a MySQL InnoDB Cluster

A MySQL replication topology can be very complex (never underestimate a DBA’s creativity). But it’s very frequent to use an asynchronous slave from your primary database to run reporting or logical backup… or any kind of read workload you need. It can also be used as delay slave for data restore purpose. Once you decided to provide HA to your … Read More


MySQL Team speaking at Percona Live Dublin 2017

From September 25th to 27th 2017, the MySQL engineers and community team will be speaking at Percona Live Europe in Dublin. MySQL is also part of the contributing sponsors. For the conference, we tried to bring new faces to the Community. Usually, it’s always the same famous team leaders speaking at the conferences, this time, it’s not. A lot of … Read More


recent

Last Tweets Last Tweets

    Locations of visitors to this page
    categories