mysql read write split?

General discussion of Mantis.

Moderators: Developer, Contributor

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

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: 7880
Joined: 26 Mar 2008, 21:37
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: 20 Jul 2018, 17:15

Re: mysql read write split?

Post by jingshaochen »

no immediate solution :( probably need to add a proxy
Post Reply