maria-discuss team mailing list archive

[LinuXperia <linuxperia@xxxxxx>]

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 
instead.
>
> 
https://mariadb.com/kb/en/mariadb/getting-started-with-mariadb-galera-cluster/

> 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.

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 
with Data
i have turned it into a Hybrid Master/Slave <=> [Master/Slave Galera] 
Cluster.

After lot of Failures and Trying i finally got it to run Smoothly and 
Flawlessly.

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 
should.

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.
Greetings

> I am having a Problem with getting mariadb works flawless using a
> Master/Slave[1] <=> Master/Slave[2] <=> Master/Slave[3]
>
> 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!
>
> 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!