MySQL Read-Slave, Write-Master with PHP mysqlnd_ms ?

[sbnd]

Hi,

looking for a MySQL Master-Slave solution, I was wondering, if anybody is running XenForo with PHPs mysqlnd_ms to do transparent splitting of read and write queries?

If so, I would be happy to hear your experience...

Thanks in advance and regards,
Stefan

 

[rdn]

https://marketplace.digitalpoint.com/master-slave-database.890/item

 

[HWS]

You may use Galera for easy Master/Master replication.

 

[sbnd]

https://marketplace.digitalpoint.com/master-slave-database.890/item

Thanks for your reply. Im aware of this plugin and we currently use it. But I just wanted to know, if anybody played around with mysqlnd_ms as another approach to solve the problem...

 

[Floren]

I personally believe a master/slave setup is a bad idea... but that is just myself. Why not use a single server with xtrabackup for incremental backups performed every 3 hours? If you really want proper redundancy, you should look into GFS, MariaDB Galera Cluster or Vitess... is your site that big (i.e. 4 dedicated nodes for MySQL only)?