maria-discuss team mailing list archive
Mailing list archive
Re: Problem with Master/Slave <=> Master/Slave <=> Master/Slave Replication
Am 25.10.2016 um 05:51 schrieb LinuXperia:
Hi Guillaume Lefranc!
> If you want to have synchronous replication across all 3 servers I would
> NOT recommend using this kind of setup. Please use Galera Cluster
> Probably something in your settings is wrong and/or servers are not
> replicating. For example you have: binlog_do_db = >
> This means that statements will only replicate if you are connected
to this DB.
Thanks a Lot for your helpful Suggestions Guillaume.
I have managed now finally to make a Hybrid Cluster where all the DB
Servers on the Cloud are in a Galera Cluster and for feeding the Cluster
i have turned it into a Hybrid Master/Slave <=> [Master/Slave Galera]
After lot of Failures and Trying i finally got it to run Smoothly and
The Documentation in MariaDB Website is not really much helpful as even
the Default Values MariaDB use prevent a smooth less Syncing of the
Data. With the Default Values especially the Network Values used by
MariaDB getting Out of Sync when using a Cluster is guaranteed!
* After getting it finally to work everything like it should
I donated now also 100.00 USD just right now to the MaraiDB Foundation
for the Work and Engagement that was done till yet.*
If everything works well and play out as planned i am willing to donate
further and on a regular basis, heck maybe even do a sponsorship.
Because of the not very helpful documentation i was on the way to
install MemSQL. The only thing that prevented me to Install it after the
Download was that a 32 Bit version do not exist and i could not run it
and ditch MariaDB.
After this a gave MariaDB another try an finally got it running like it
I recommend the People at MariaDB to provide at least Donators access to
Best Use and Configuration Settings that works best in Production.
That way people like me that are willing to pay dont waste their time on
the Internet to find out what the problem with MariaDB is when it comes
to Clustering and Out Of Sync Problems.
Thanks for everything.
Till next Time.
I am having a Problem with getting mariadb works flawless using a
Master/Slave <=> Master/Slave <=> Master/Slave
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!
I expected that the deleted row should be also deleted on all
master/slave servers but it did not!
Thanks in advance for any helpful Tip and Answer!