Page 1 of 1

mysql read write split?

Posted: Aug 17, 2018 10:46 pm
by jingshaochen
Does mantis support mysql cluster with a master for read and write, but multiple slaves for read only?

Re: mysql read write split?

Posted: Aug 18, 2018 7:39 am
by atrol
I never used MySQL clusters, but shouldn't this work out of the box without any modifications?
https://dev.mysql.com/doc/refman/5.7/en ... asics.html
Standard MySQL clients. NDB Cluster can be used with existing MySQL applications written in PHP, Perl, C, C++, Java, Python, Ruby, and so on. Such client applications send SQL statements to and receive responses from MySQL servers acting as NDB Cluster SQL nodes in much the same way that they interact with standalone MySQL servers.

Re: mysql read write split?

Posted: Mar 11, 2019 11:12 am
by jingshaochen
no immediate solution :( probably need to add a proxy