(Vadim Tkachenko and Alexey Stroganov) In our latest release of Percona XtraDB Cluster, we’ve introduced major performance improvements to the MySQLwrite-set replication layer. In this post, we want to show what these improvements look like.
Tag: Open Source
New MySQL JSON Functions (more)
(Dave Stokes) MySQL 8 is going to have new batch of JSON functions and last time JSON_PRETTY() was covered in some details. The recent release of 8.0.1 provides an opportunity to try these new functions and a few that might have been missed with 8.0.0.
New monitoring replication features and more!
(Maria Couceiro) The new release of MySQL is packed with exciting features that help detecting and analyzing replication lag. In this post, you will be able to learn all about the new replication timestamps, the new useful information that is now reported by performance schema tables, and how delaye
How to Set Up Asynchronous Replication from Galera Cluster to Standalone MySQL server with GTID
(Art van Scheppingen) Hybrid replication, i.e. combining Galera and asynchronous MySQL replication in the same setup, became much easier since GTID got introduced in MySQL 5.6. Although it was fairly straightforward to replicate from a standalone MySQL server to a Galera Cluster, doing it the other
Experimental Build of MyRocks with Percona Server for MySQL
(Vadim Tkachenko) We have been working on bringing out a build of MyRocks with Percona Server for MySQL.
On demand query routing – how to prevent downtime on your main MySQL server
(René Cannaò) In a previous post I wrote about how read/write split is implemented in ProxySQL, and what I believe is the best practice for read/write split on top of MySQL servers:
The mysqlpump Utility
(Pablo Padua) In this blog, we’ll look at the mysqlpump utility.
Obfuscate data from mysqldump with ProxySQL
(René Cannaò) While me and Fred were presenting Inexpensive Datamasking for MySQL with ProxySQL at FOSDEM 2017, we got a very interesting question: can ProxySQL be used to obfuscate backups obtained from mysqldump?
Installing MySQL Cluster 7.5.6 on Red Hat derivatives
(Mikael Ronström) MySQL Cluster 7.5.6 comes with a new nice feature. It is now possible to install MySQL Cluster using the MySQL repos. I made an exercise today in setting up a cluster today in the cloud using these new MySQL repos. This blog describes the work to install MySQL Cluster on the VMs.
MySQL 8.0.1: Accent and case sensitive collations for utf8mb4
(xing zhang) In MySQL 8.0 we have been working to improve our support for utf8 as we make the transition to switch it to the default character set. For more details see our earlier posts:
