What are the options for having multiple mysql servers with the same database and data. I know there is replication but I have been reading that it can have issues especially if there are connection issues. Are there any alternatives to the built in replication that are reliable? Someone suggested getting a server on the same network so the mysql server can be accessed by all the servers over lan, but currently that is not an option for me.
Is mysql just not meant for replication? Is there another sql engine that is better for it?