Page 1 of 1

CONFIGURE THE PROCESSMAKER TO USE MULTIPLE MYSQL SERVERS

Posted: Wed Jun 17, 2020 4:43 am
by pawansaxena
I have installed two processmaker instances and serving them via a reverse proxy.
I have installed two mysql servers and used master-slave replication on those. Configured remote access on master mysql server. The replication is working correctly.

I checked this wiki : https://wiki.processmaker.com/3.2/Double_Connection
1. Here what is the significance of creating a master user on slave
( search text : "Finally, create a user for the master server to access the slave database." )

2. If i have to configure processmaker to redirect the read queries to slave and write, update and delete transactions to master do i need to modify the source code of processmaker ?
( search for text : "Configuring the Double Connection in the ProcessMaker Code" in the above wiki )

3. Let's say if i have 100 workspaces, do i need to duplicate that code block hundred times ?

4. And lastly what if the master goes down, would slave become master and if so, what about the code we changed in processmaker, how would the processmaker know that old slave is now new master ?


Thanks in advance

Re: CONFIGURE THE PROCESSMAKER TO USE MULTIPLE MYSQL SERVERS

Posted: Tue Jul 07, 2020 6:18 am
by MaxPayne
This situation is indeed not handled. The general assumption is that there is never a situation in which the entire cluster is down. MaxScale tries to get the cluster running with the best https://vidmate.bet/ server available. This may require a new configuration setting. Please make a feature request on our JIRA.