Is there a way to have a second mysql database on a separate server that is a live mirror of the main database? As our site and database grows, we are increasing concerned with data security and maintaining backups. We dump the db nightly, but hundreds of records are added daily and this number could soon grow shortly into the thousands per day.
Is there a method to create a live mirror that mimicks the actions of the first database?
Is there a method to create a live mirror that mimicks the actions of the first database?