Contents
What is replication thread?
Replication I/O thread. When a START SLAVE statement is issued on a replica server, the replica creates an I/O thread, which connects to the source and asks it to send the updates recorded in its binary logs. The state of this thread is shown as Slave_IO_running in the output of SHOW SLAVE STATUS .
How does Active Directory detect replication?
To diagnose replication errors, users can run the AD status replication tool that is available on DCs or read the replication status by running repadmin /showrepl.
What is asynchronous replication in MySQL?
MySQL Replication by default is asynchronous. This is the oldest, most popular and widely deployed replication scheme. With asynchronous replication, the master writes events to its binary log and slaves request them when they are ready. There is no guarantee that any event will ever reach any slave.
What do you need to know about MariaDB replication?
Getting replication working involves steps on both the master server/s and the slave server/s. Setting up a replication slave with Mariabackup. Making replicas read-only. Replication can be used to support the backup strategy. Using replication with many masters. Types of threads that are used to enable replication.
What’s the difference between master and slave in MariaDB?
The terms master and slave have historically been used in replication, but the terms terms primary and replica are now preferred. The old terms are used throughout the documentation, and in MariaDB commands, although MariaDB 10.5 has begun the process of renaming. The documentation will follow over time.
Do you need mariabackup to set up a replication slave?
If you would like to use Mariabackup to set up a replication slave, then you might find the information at Setting up a Replication Slave with Mariabackup helpful. In general, when replicating across different versions of MariaDB, it is best that the master is an older version than the slave.
What are the old terms used in MariaDB?
The old terms are used throughout the documentation, and in MariaDB commands, although MariaDB 10.5 has begun the process of renaming. The documentation will follow over time. See MDEV-18777 to follow progress on this effort.