maria-discuss team mailing list archive
Mailing list archive
Re: Problem with Master/Slave <=> Master/Slave <=> Master/Slave Replication
On Tue, Oct 25, 2016 at 5:51 AM LinuXperia <linuxperia@xxxxxx> wrote:
> Hi All!
> I am having a Problem with getting mariadb works flawless using a
> Master/Slave <=> Master/Slave <=> Master/Slave
> If you want to have synchronous replication across all 3 servers I would
NOT recommend using this kind of setup. Please use Galera Cluster instead.
The First Time i was able to insert a row on the Master Server
> and the data was reproduced/replicated to all servers.
> At this Time i thinked everything is fine now.
> But then when i tryed to deleted the new Created Row on Master
> the Data was only deleted on the Master Server while
> the others Servers  and  still had the data!
Probably something in your settings is wrong and/or servers are not
replicating. For example you have: binlog_do_db = logedin_users
This means that statements will only replicate if you are connected to this
> I expected that the deleted row should be also deleted on all
> master/slave servers but it did not!
> How can i solve this Problem? And what is actually the Problem with
> MySQL/MariaDB? I am getting the impression that MariaDB is really bad
> when it comes to Replication/Sync of Data in a Distributed Architecture.
I recommend you read some more documentation and refer to the MariaDB KB
about use cases and replication configuration.
> As a Example let say on server has to reboot because of a Cloud
> maintenance. From what i see this MaraiDB server will be forever
> corrupted after the restart and never sync again as first it has to
> manually be adjusted to the master bin log position and second it has
> also be told to work as a slave after this.
You shouldn't have to do this if you've configured your servers and
As mentioned before if you need a three server cluster setup I recommend
using MariaDB Galera Cluster. It is easy to set up in MariaDB 10.1.
Not really what i would expect from a autonomous replicating Master
> Slave Data Base Server after a restart!
> Hope somebody can tell me how to resolve all this Sync Problems so
> finally MariaDB Master/Slave Database Server work flawless without to
> worry that sooner or later a node or a few of them will get useless and
> Thanks in advance for any helpful Tip and Answer!
> A example of my my.cnf Master/Slave Server changes!
> server-id = 2
> replicate-same-server-id = 0
> auto-increment-increment = 8
> auto-increment-offset = 1
> log_bin = /var/log/mysql/mariadb-bin
> log_bin_index = /var/log/mysql/mariadb-bin.index
> # not fab for performance, but safer
> sync_binlog = 1
> expire_logs_days = 10
> max_binlog_size = 100M
> binlog_do_db = logedin_users
> binlog-format = ROW
> # slaves
> relay_log = /var/log/mysql/relay-bin
> relay_log_index = /var/log/mysql/relay-bin.index
> relay_log_info_file = /var/log/mysql/relay-bin.info
> log_slave_updates = 1
> binlog-checksum = 1
> master_verify_checksum = 1
> relay_log_recovery = 1
> slave_compressed_protocol = 1
> slave_sql_verify_checksum = 1
> sync_master_info = 1
> sync_relay_log = 1
> sync_relay_log_info = 1
> Mailing list: https://launchpad.net/~maria-discuss
> Post to : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help : https://help.launchpad.net/ListHelp
Remote DBA Services Manager