> > > Again, this is a lot of work to avoid master / slave with failover. > Are you sure it's really needed for your situation? > > What is the most straightforward and simple way to achieve master slave with failover?
Preferably a solution that would have decent monitoring, alerting and failback capacity. It would be also nice if you could use the standby as a read only database for reporting or something.
