Replication Commands

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. See MDEV-18777 to follow progress on this effort.

A list of replication-related commands. See replication for more replication-related information.

Title Description
CHANGE MASTER TO Set or change replica parameters for connecting to the primary.
START SLAVE Start replica threads.
STOP SLAVE Stop replica threads.
RESET SLAVE Forget slave connection information and start a new relay log file.
SET GLOBAL SQL_SLAVE_SKIP_COUNTER Skips a number of events from the master.
SHOW RELAYLOG EVENTS Show events in the relay log.
SHOW SLAVE STATUS Show status for one or all masters.
SHOW MASTER STATUS Status information about the binary log.
SHOW SLAVE HOSTS Display replicas currently registered with the primary.
RESET MASTER Delete binary log files.
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/replication-commands/