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 » Aug 17, 2018 10:46 pm

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

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

Re: mysql read write split?

Post by atrol » Aug 18, 2018 7:39 am

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 » Mar 11, 2019 11:12 am

no immediate solution :( probably need to add a proxy

Post Reply