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
We saw yesterday that the new MySQL Shell was out and how we could create a MySQL InnoDB Cluster manually using the Shell. Today, I would like to show you how easy it is to create recipes to automate all the process. I have created a Puppet module that can be used as Proof-of-concept (You might need more features to … Read More
Earlier this week, MySQL Shell 1.08 has been released. This is the first Release Candidate of this major piece of MySQL InnoDB Cluster. Some commands have been changed and some new ones were added. For example the following useful commands were added: dba.checkInstanceConfiguration() cluster.checkInstanceState() dba.rebootClusterFromCompleteOutage() So let’s have a look on how to use the new MySQL Shell to create … Read More
Last Tweets
RT @ValaAfshar: 3D illusions of Kokichi Sugihara, an engineering professor at Meiji Institute https://t.co/vfwyeWT38b
Oracle Code in Brussels on June 6th: Learn from technical experts & other developers in sessions & hands-on labs: https://t.co/CBc0HkQ09XTo my Russian speaking friends, @MySQL needs you ! https://t.co/DfOoeIgllY@twindba let's add some more fancy char too:
cat /dev/urandom | tr -Cd a-zA-Z0-9[@#$!%\(\)] | fold -w 16 | head -1
comments