mysql - How to configure 1 MySQL database running on 2 different servers?

Question

For my current environment, I am running 2 separate Linux boxes each running MySQL. Each server should have the exact same db (one of the servers should host the db and the other one points to it). I know this could be possible using "federated tables" but the application that the database supports has hundreds of tables. It would be very recursive to point each table to the other db.

Does anyone have any suggestions how this could be possible? I have looked all over and have not found anything quite like this scenario.

标签： mysqldatabase