MySQL 8 is shaping up quite nicely. And we are having a blast in the MySQL replication team while this is happening. We are continuously improving all-things-replication by introducing new and interesting features. In addition, we have been listening to our community and addressing their feedback.…
10 Older Entries »
Join Percona’s MySQL Practice Manager Kenny Gryp and QA Engineer, Ramesh Sivaraman as they present a high availability webinar around Percona XtraDB Cluster, Galera Cluster, MySQL Group Replication on Wednesday, June 21, 2017 at 10:00 am PDT / 1:00 pm EDT (UTC-7).
What are the implementation differences between Percona XtraDB Cluster 5.7, Galera Cluster 5.7 and MySQL Group Replication?
- How do they work? …
The white paper shares lessons learned from a careful, component level analysis of China Mobile’s 1000-node OpenStack cloud. They uncovered three major issues in the course of this study, all addressed through OpenStack configuration changes. The result: a more stable and performant China Mobile OpenStack cloud and insights into scale bottlenecks and areas for future work.
Read the full story: Analyzing and Tuning China Mobile’s OpenStack Production Cloud white paper below
Starting on MySQL 8.0.1, a very updated replica server will be more efficient (and probably faster) than previous MySQL versions because of improvements in the relationship between the replication threads. Preliminary testing showed a benefit of up to 65% on Sysbench Update Index.…
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 delayed replication was improved.…
On the same day last year, I wrote a post about replication filters in MySQL Multi Source Replication and whether we can set the filters per replication channel or not (Bug #80843). My feature request – as well as some others – has been implemented in MySQL 8.0.1. Thanks Oracle for the implementation. (Full list of changes can be checked out here)
In this post, I’ll demonstrate how to set replication filters per
channel in MySQL Multi Source Replication.
Setting up and configuring Multi Source …[Read more]
This blog we describe an issue with MySQL 5.7’s super_read_only feature when used alongside with GTID in chained slave instances.
In MySQL 5.7.5 and onward introduced the
gtid_executed table in the MySQL database to store
every GTID. This allows slave instances to use the GTID feature
regardless whether the binlog option is set or not. Here is an
example of the rows in the
mysql> SELECT * FROM mysql.gtid_executed; +--------------------------------------+----------------+--------------+ | source_uuid | interval_start | interval_end | …[Read more]
Great news: Group Replication is now officially released with MySQL 5.7.17, congratulations to everybody that worked so hard for it!
In this post I plan to share more details about the performance of Group Replication while addressing one of our frequently asked questions, which is how it performs compared to Galera.…
Multi-Source Replication is one of the awesome
features in MySQL 5.7 which allows the slave to get the
replication streams from multiple masters by having a replication
channel for each master.
But what about the replication filters? Can we set replication filters per channel in the multi-source replication?
In brief, replication filtering is a way used to eliminate part
of the master’s events (not) to be replicated to the slaves (Also
known as Partial Replication). This can be done on either master
--binlog-ignore-db options) or slaves (using
--replicate-* options) while it is not recommended
on the master anyway at least to provide Point in Time Recovery
In the first post, I showed you how to use the
tools in a typical MySQL replication setup. In this post, we’ll discuss MySQL replication for more advanced topologies. I will show you how to use these tools in a chained …[Read more]
10 Older Entries »