Hi, On Tue, Oct 25, 2016 at 5:51 AM LinuXperia <linuxpe...@gmx.ch> wrote:
> Hi All! > > I am having a Problem with getting mariadb works flawless using a > Master/Slave[1] <=> Master/Slave[2] <=> Master/Slave[3] > > 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. https://mariadb.com/kb/en/mariadb/getting-started-with-mariadb-galera-cluster/ The First Time i was able to insert a row on the Master[1] 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[1] > the Data was only deleted on the Master[1] Server while > the others Servers [2] and [3] 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 DB. > > 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 replication correctly. 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. Best regards GL > 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 > corrupted! > > Thanks in advance for any helpful Tip and Answer! > > A example of my my.cnf Master/Slave[2] 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 > #read_only > > 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@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > -- Guillaume Lefranc Remote DBA Services Manager MariaDB Corporation
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
