lefred's blog


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

MySQL InnoDB Cluster: is the router a single point of failure ?

As you know, MySQL InnoDB Cluster is composed of 3 elements: a group replication cluster of at least 3 servers the MySQL Shell used to manage the cluster the MySQL Router that send the traffic from the application server(s) to the cluster When presenting the solution in conferences, one the main question is Where should I put the router ? … Read More


MySQL InnoDB Cluster : MySQL Shell and the AdminAPI

As promised, here is a post more detailed on how to create a MySQL InnoDB Cluster using MySQL Shell and the AdminAPI. First of all, as a good practice is never enough repeated, whatever the version of MySQL you are using, please use the latest MySQL Shell ! So if you are using 5.7, please use MySQL Shell 8.0.11. See … Read More


MySQL 8.0 InnoDB Cluster – the quick hands-on manual

I’m just back from a trip in Barcelona where I presented MySQL 8.0 InnoDB Cluster (at dataops and Barcelona MySQL Meetup) and the majority of feedback was great, but I also had some comments on the demos I showed. The first one was: This is a joke of course (maybe it’s true for some), people found it very easy and … Read More


MySQL Shell for MySQL 8.0: your best friends in the cloud !

MySQL 8.0.11 seems to be around the corner and the new MySQL Shell will take advantage of all the new improvements made in MySQL 8.0 like SET PERSIST, RESTART, … see this previous post. In the video below, I show you how easy it’s to deploy a MySQL InnoDB Cluster using the Shell that connects remotely to all the instances: … 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


recent

Last Tweets

Locations of visitors to this page
categories