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