lefred's blog


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

Ripple Binlog Server for MySQL

Today I started to check ripple the new MySQL binlog server. I don’t want to give yet any feedback neither I want to answer THE question: Is this the Binlog Server we were all waiting for ? But I had some difficulties to build it on my test machines (rpm based as mostly everybody knows). I think this might be … Read More


Replace MariaDB 10.3 by MySQL 8.0

Why migrating to MySQL 8.0 ? MySQL 8.0 brings a lot of new features. These features make MySQL database much more secure (like new authentication, secure password policies and management, …) and fault tolerant (new data dictionary), more powerful (new redo log design, less contention, extreme scale out of InnoDB, …), better operation management (SQL Roles, instant add columns), many … Read More


Migrate from MariaDB to MySQL on CentOS

On this article, I will show you how to migrate your wordpress database from the MariaDB on CentOS to the real MySQL. Why migrating to MySQL 8.0 ? MySQL 8.0 brings a lot of new features. These features make MySQL database much more secure (like new authentication, secure password policies and management, …) and fault tolerant (new data dictionary), more … Read More


MySQL InnoDB Cluster – consistency levels

Consistency during reads have been a small concern from the adopters of MySQL InnoDB Cluster (see this post and this one). This is why MySQL supports now (since 8.0.14) a new consistency model to avoid such situation when needed. Nuno Carvalho and Aníbal Pinto already posted a blog series I highly encourage you to read: Group Replication – Consistency Levels … Read More


MySQL InnoDB Cluster – howto install it from scratch

MySQL InnoDB Cluster is evolving very nicely. I realized that the MySQL Shell also improved a lot and that it has never been so easy to setup a cluster on 3 new nodes. This is a video of the updated procedure on how to install MySQL InnoDB Cluster on GNU Linux rpm based (Oracle Linux, RedHat, CentOS, Fedora, …)


recent

Last Tweets

Locations of visitors to this page
categories

 

the database server for this blog has been upgraded to MySQL 8.0.16
+