Page 1 of 1

mysql read write split?

Posted: 18 Aug 2018, 03:46
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: 18 Aug 2018, 12:39
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: 11 Mar 2019, 16:12
by jingshaochen
no immediate solution :( probably need to add a proxy