mysql read write split?

General discussion of Mantis.

Moderators: Developer, Contributor

Post Reply
jingshaochen
Posts: 10
Joined: Jul 20, 2018 12:15 pm

mysql read write split?

Post by jingshaochen »

Does mantis support mysql cluster with a master for read and write, but multiple slaves for read only?

atrol
Site Admin
Posts: 7791
Joined: Mar 26, 2008 4:37 pm
Location: Germany

Re: mysql read write split?

Post 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.
Please use Search before posting and read the Manual

jingshaochen
Posts: 10
Joined: Jul 20, 2018 12:15 pm

Re: mysql read write split?

Post by jingshaochen »

no immediate solution :( probably need to add a proxy

Post Reply