lefred's blog


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

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


Oracle Open World 2019 – CodeONE Call For Paper

The Oracle Open World 2019 Call For Paper is open until March 13th. MySQL track will be part of CodeONE, the parallel conference focused on developers. We encourage you to submit a session related to the following topics: case studies / user stories of your MySQL usage lessons learned in running web scale MySQL production DBA/devops perspectives into MySQL Architecture, … Read More


MySQL Shell : the best DBA tool?

Last week I presented the following session at the pre-FOSDEM MySQL Day: The audience seemed very interested on how the MySQL Shell can be extended. During the presentation I showed how I extended the MySQL Shell with two new modules in Python: mydba innotop Both projects are on github and are waiting for ideas, feature requests, pull requests, … Here … Read More


recent
Locations of visitors to this page
categories