I have 2 Raspberry PI's and each run a MariaDB 10.3 server. Each has the same databases:
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?