Recently, my friend Marco Tusa(MySQL Daddy or the Grinch) wrote his first impression on MySQL Group Replication (part of InnoDB Cluster). And his conclusion was not that positive. But when I analyze his setup, I understand that his assumptions were not so right. Let's try to explain what were the issues and why his test wasn't correct. Before commenting Marco's … Read More
As you may know by now, MySQL 8.0.2 DMR is out ! \o/ Many features have been added (see Geir Høydalsvik‘s announcement) and of course the replication also brought new features and improvements (see this post from Luís Soares). But some improvements in the monitoring broke the added sys view used by ProxySQL to monitor the state of a member … Read More
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