MySQL Load Balancing
<p>We have 6 Servers (4 Applications servers and 2 DB Servers)</p>

<p>We are using HAProxy to load balance between the Application and API servers (2/2)</p>

<p>Now the issue I'm having is that the system administrator setup a Master/Slave on the MySQL but it's always failing and until now we cannot use the slave since most data are always corrupted and we always need to fix it and each time we are getting different errors .</p>

<p>We tried to make some sort of load balancing for the read/write (write on master , read on slave) but we were not able to use that since slave data are not always correct .</p>

<p>What I'm wondering is how the big guys proceed when dealing with high load servers where you always need the data to be accurate and cannot take any risk?</p>

<p>Can someone tell me his own experience and what he used ?</p>

<p>What i found : <a href="https://www.percona.com/software/mysql-database/percona-xtradb-cluster" rel="nofollow">Percona XtraDB Cluster</a> , but before going into this direction need input ...</p>

<p>Thank's !!</p>