installation with Docker

MySQL Group Replication was released as GA with MySQL 5.7.17. It is essentially a plugin that, when enabled, allows users to set replication with this new way.There has been some confusion about the stability a...
Read more...
tusacentral.net working for a better world... before the end!Setup ProxySQL as High Available (and not a SPOF)

tusacentral.net working for a better world... before the end!Setup ProxySQL as High Available (and not a SPOF)

During the last few months we had a lot of opportunities to present and discuss about a very powerful tool that will become more and more used in the architectures supporting MySQL, ProxySQL. ProxySQL is becom...
Read more...
Solving MySQL Replication Lag with LOGICAL_CLOCK and Calibrated Delay

Solving MySQL Replication Lag with LOGICAL_CLOCK and Calibrated Delay

Last week VividCortex's published a post on examining how our engineering team had overcome a problem with MySQL replication by using a new parallelization policy introduced in MySQL 5.7: LOGICAL_CLOCK. The so...
Read more...

Oracle MySQL and the funny replication breakage of Friday, January 13

In my previous post, I talked about a funny replication breakage that I experienced with MariaDB.  So what about different versions of MySQL... So in Oracle MySQL land: All latest versions are consistent (so...
Read more...

Funny replication breakage of Friday, January 13

A funny replication breakage kept me at the office longer than expected today (Friday 13 is not kind with me). So question of the day: can you guess what the below statement does (or what is wrong with it)? H...
Read more...

PHP and MySQL Basics III -- Resulting Results

In the first two blogs entries on this series we set up a connection to MySQL and sent off a query. Now we need to get the data back from the database and into the application. An Embarrassment of Riches PHP ...
Read more...
The Impact of Swapping on MySQL Performance

The Impact of Swapping on MySQL Performance

In this blog, I’ll look at the impact of swapping on MySQL performance. It’s common sense that when you’re running MySQL (or really any other DBMS) you don’t want to see any I/O in your swap space. Sca...
Read more...

throttling and changing configuration at runtime

Back to Blog Online schema change with gh-ost - throttling and changing configuration at runtime Previous post
Read more...
CVE-2016-6225: Percona Xtrabackup Encryption IV Not Being Set Properly

CVE-2016-6225: Percona Xtrabackup Encryption IV Not Being Set Properly

If you are using Percona XtraBackup with to create encrypted backups, and are using versions older than 2.3.6 or 2.4.5, we advise that you upgrade Percona XtraBackup. Note: this does not affect encryption of...
Read more...
MySQL Day – Sessions review #2

MySQL Day – Sessions review #2

As written yesterday, on February 3rd, just before Fosdem and the MySQL & Friends Devroom, MySQL’s Community Team is organizing the pre-Fosdem MySQL Day. The second talk of this series is the session of Bern...
Read more...

skip_nextNext