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.