I just enabled redundancy on FactorySQL. It seems to be working but I’m not sure if I setup this right. I have two physical servers (A and B) running a virtual servers each with a mirrored database. I setup another two virtual servers (one in A and the other in B) running factorySQL on both. I setup redundancy on the first FactorySQL (A) pointing to the database on A and the second FactorySQL pointing to the database on B, from the second FactorySQL (B) and connected to the service in the Master which is (A). I don’t know how to establish the cross connection.
DB (A) ----------------- DB (B)
| |
FactorySQL (A) ------ FactorySQL (B)