MySQL InnoDB Cluster (or only Group Replication) becomes more and more popular. This solution doesn’t attract only experts anymore. On social medias, forums and other discussions, people are asking me what it the best way to migrate a running environment using traditional asynchronous replication [Master -> Slave(s)] to InnoDB Cluster.
Today I presented MySQL InnoDB Cluster at the Helsinki MySQL User Group. To demonstrate how easy it’s to deploy a cluster with MySQL Shell and used the prompt that will be part of a future release just because it’s beautiful. If you also want to see how it looks like, just check the video below: There were several MongoDB … Read More
ProxySQL is the leader in proxy and load balancing solution for MySQL. It has great features like query caching, multiplexing, mirroring, read/write splitting, routing, etc… The latest enhancement in ProxySQL is the native support of MySQL Group Replication. No more need to use an external script within the scheduler like I explained in this previous post. This implementation supports Groups … Read More
As you know, MySQL Group Replication runs by default in single primary mode. mysql2 mysql> show global variables like ‘group_replication_single_primary_mode’; +—————————————+——-+ | Variable_name | Value | +—————————————+——-+ | group_replication_single_primary_mode | ON | +—————————————+——-+ But how can we easily find which member of the group is the Primary-Master ? Of course you could check which one is not in read_only: mysql2 … Read More
Yesterday I was invited to speak at the “Jeudis du Libre” in Mons. The location was very special as it was in one auditorium of Polytech, the oldest university in the city of Mons. I presented in French two very hot topics in the MySQL ecosystem: MySQL InnoDB Cluster MySQL as Document Store with JSON datatype & X plugin Those … Read More