I've multiple linux servers which runs MySQL server and my applicaiton each.
I have a cron job which creates daily backups and uploads them to another server. Daily backups are OK but, i want to be able to recover the current state of the database in case of the server goes down or whatever happens.
Can I create a single "read only async replication server" and configure all other servers to create replications to that server?
OR, what is the right way to do that?