Mirroring mysql dbs using rsync?

[ayksolutions]

Hello,

I am going to start offering a mirror service so in case my main server goes down, it'll kick all of the 'signed' up sites to our secondary server on another network. I am going to use failover DNS ad RSYNC for this. My problem is, how would i "mirror" the MySQL databases as they are not located in the /home/acctname folders?

Any ideas would be greatly appreciated.


Thank you