Comments - Setting Up Replication
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.
I'm running primary as 10.11.3-MariaDB-1+rpi1-log Raspbian 12 and secondary as 10.11.4-MariaDB-1deb12u1 Debian 12. Obviously version mismatch is an issue but I have a more basic issue.
The file /.my.cnf sets server_id=2 in the secondary. It seems that this value is picked correctly because SHOW GLOBAL VARIABLES reports server_id=2.
Yet, I get the following message in SHOW SLAVE STATUS\G Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MariaDB server ids; these ids must be different for replication to work (or the --replicate-same-server-id option must be used on slave but this does not always make sense; please check the manual before using it).
The primary is implicitly using server_id=1. In my limited knowledge there should be no conflict but there (apart from knowing which .cnf file is being used). Therefore, should not be any mismatch.
I am assuming that the primary is working fine (server_id=1) but what/where changes are needed in the secondary server for replication to start? Thanks.
Regards.