You say you want a Replication?
One of the best features of MySQL is the ability to use MySQL‘s built-in database replication feature to automatically replicate data from one server (source/master) to another (slave/replica). Group Replication was added in MySQL 5.7 as a way to provide a high-availability solution using a new variation of MySQL replication.
(In some earlier posts, I explained how to setup Group Replication using three MySQL database servers and how to …
[Read more]MariaDB OpenWorks happened February 25 – 27, 2019 in New York City. It was filled with plenty of activity.
The keynote by Michael Howard, C.E.O. of MariaDB, is an interesting watch, one with many quoted articles especially around “strip-mining open-source technologies and companies,” and “abusing the license and privilege, and not giving back to the community.” Many articles were written about this topic, and it’s clear that open-source has arrived considering all of the success around the IBM acquisition of Red Hat, the Elastic I.P.O., the Microsoft acquisition of GitHub, the SalesForce acquisition fo MuleSoft and the MongoDB I.P.O.
Seppo Jaakola, the C.E.O. of Codership, talked about …
[Read more]
The much anticipated release of Galera 4 makes
its way first in the latest release of MariaDB Server
10.4.3 Release Candidate which you can download now. Congratulations to MariaDB
Corporation and MariaDB Foundation on this release candidate — please get testing Galera
4, and share your feedback with us via our Google Group discussion list! Do not forget that
you can always reach us via email: mailto:info@galeracluster.com
and via our contact us form.
The feature we are excited about the most, is a feature request from many users. This is none other than huge transaction …
[Read more]In a MySQL hosting replication setup, the parameter Seconds_Behind_Master (SBM), as displayed by the SHOW SLAVE STATUS command, is commonly used as an indication of the current replication lag of the slave. In this blog post, we examine how to understand and interpret this value in various situations.
Possible Values of Seconds Behind Master
The value of SBM, as explained in the MySQL documentation, depends on the state of the MySQL slave in general, and the states of MySQL slave SQL_THREAD and IO_THREAD in particular. While IO_THREAD connects with the master and reads the updates, SQL_THREAD applies these updates on the slave. Let’s examine the possible values of SBM during different states of the MySQL Slave.
When SBM Value is Null
The encrypted binary log file format introduced in MySQL version 8.0.14 was designed to allow a “manual” decryption of the file data when the value of the key that encrypted its file password is known.
Each encrypted binary (or relay) log file is composed by an encrypted binary log file header and the encrypted binary log content (the file data).…
Starting in version 8.0.14, MySQL server can encrypt all new binary and relay
log files on disk. In order to do so, you just need to enable
the new binlog_encryption option (and also
ensure that you have a keyring).…
In Part I, we introduced a High Availability (HA) framework for MySQL hosting and discussed various components and their functionality. Now in Part II, we will discuss the details of MySQL semisynchronous replication and the related configuration settings that help us ensure redundancy and consistency of the data in our HA setup. Make sure to check back in for Part III where we will review various failure scenarios that could arise and the way the framework responds and recovers from these conditions.
What is MySQL Semisynchronous Replication?
Simply put, in a …
[Read more]MySQL 8.0.13 improves replication lag monitoring by extending the instrumentation for transaction transient errors. These temporary errors, which include lock timeouts caused by client transactions executing concurrently as the slave is replicating, do not stop the applier thread: instead, they cause a transaction to retry.…
The MySQL Replication was my first project as a Database
Administrator (DBA) and I have been working with Replication
technologies for last few years and I am indebted to contribute
my little part for development of this technology. MySQL supports
different replication topologies, having better understanding of
basic concepts will help you in building and managing various and
complex topologies.I am writing here, some of the key points to
taken care when you are building MySQL replication. I consider
this post as a starting point for building a high performance and
consistent MySQL servers. Let me start with below key
points Hardware.MySQL Server VersionMySQL Server
ConfigurationPrimary KeyStorage EngineI will update this post
with relevant points, whenever I get time. I am trying to provide
generic concepts and it will be applicable to all version of
MySQL, however, some of the concepts are new and applicable to
latest versions …
Did you know that Continuent Clustering supports having clusters at multiple sites world-wide with either active-active or active-passive replication meshing them together?
Not only that, but we support a flexible hybrid model that allows for a blended architecture using any combination of node types. So mix-and-match your highly available database layer on bare metal, Amazon Web Services (AWS), Azure, Google Cloud, VMware, etc.
In this article we will discuss using the Active/Passive model to scale reads worldwide.
The model is simple: select one site as the Primary where all writes will happen. The rest of the sites will pull events as quickly as possible over the WAN and make the data available to all local clients. This means your application gets the best of both worlds: