I have the following master / slave configuration: 1 master and 3 slaves (slaves used in time-consuming queries for reports).
I need to know if it is possible to convert a slave to master in a master / master configuration by keeping the 2 remaining slaves as in the following image.
In this case the webservice would send all requests to Master 1 and Master 2 would serve as a redundancy server in case Master 1 goes offline.
My intention is that in the event of a Master 1 failure, redirect requests to Master 2, and as soon as Master 1 is available, wait for it to be synchronized with Master 2 and then redirect the requests back to the Master 1.