The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

MariaDB Parallel Replication

Is parallel replication already enabled in MariaDB 10.1.14? I am asking this since i did SHOW PROCESSLIST on slave system and it gave me a output with 6 system users which according to this page are replication threads (https://mariadb.com/kb/en/mariadb/parallel-replication/) Also the system is a multi source replication environment and I am using the default in-order conservative mode. I tried optimising the replication using this link https://mariadb.com/blog/optimizing-conservative-order-parallel-replication-mariadb-100 but the ratio doesnt seem to change even if different values are being given. Also i tried to change the slave_parallel_threads and slave_parallel_mode to 0 and none respectively but still the SHOW PROCESSLIST output gives 6 system users.

I want to test if parallel replication is working and multiple threads are doing the task. Please tell me if I am doing something wrong or what should be done to see multiple threads doing the task.

Answer Answered by Ian Gilfillan in this comment.

Did you take the slaves down when changing the settings? They are dynamic, so can be set while the server is running, but the slave needs to be down when the setting is changed. See slave_parallel_threads.

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.