The slave applier plugin, named slave, provides a native implementation of replication between Drizzle servers by applying replication events from multiple “master” servers to a “slave” server. A slave is a server on which the slave plugin is loaded, configured, and ran. Slaves can connect to up to ten masters at once over the network and pair with the Default Replicator on each them. Slaves apply every replication event from every master; conequently, they contain the same schemas and data as their masters.
Replication chains are supported: slaves can also be masters and replicate events to other slaves. There is no limit to the number of levels in which masters and slaves can be enchained.
Replication circles, or master-master replication, are not currently supported. Replication will break on one of the masters if this is attempted.
The next two sections, slave_configuration and slave_administration, contain necessary information for configuring and administering slave-based replication. The third section, slave_details, covers technical details about how the slave plugin and slave-based replication work.
This documentation applies to slave_1.1_drizzle_7.1.
To see which version of the slave plugin a Drizzle server is running, execute:
SELECT MODULE_VERSION FROM DATA_DICTIONARY.MODULES WHERE MODULE_NAME='slave'