I have 2 Raspberry PI's and each run a MariaDB 10.3 server. Each has the same databases:
- vennens
- scheduler
On the slave I've configured the 50-server.conf
file with follow contents:
master_pi1.replicate_do_db=scheduler_pi1
master_pi1.replicate_do_db=vennens_pi1
master_pi2.replicate_do_db=scheduler_pi2
master_pi2.replicate_do_db=vennens_pi2
master_pi1.replicate_rewrite_db=scheduler->scheduler_pi1
master_pi1.replicate_rewrite_db=vennens->vennens_pi1
master_pi2.replicate_rewrite_db=scheduler->scheduler_pi2
master_pi2.replicate_rewrite_db=vennens->vennens_pi2
Then I have run the CHANGE MASTER
queries with the correct information.
When I update data on the PI's, they are not synced with the slave. I see an error when I ask for statuses.
I've removed the replicate_rewrite_db and did the process all over again for replication but now each has Raspberry PI has an unique database name. And this setup works. There is nothing wrong with the connection.
I also see in the relay log of each connection that queries are received.
On the server I run MariaDB 10.5
What could be the issue here?
I've read: