LAMP replication to DR site
-
Goal is disaster recovery. What would be the best choice here for the backup? Does mysql replication helps in this case?
-
@Ambarishrh said in LAMP replication to DR site:
Goal is disaster recovery. What would be the best choice here for the backup? Does mysql replication helps in this case?
Only if you want to replicate to the remote site and then take the backup there. Replication is not part of backup. Replication is tightly couples, backup is decoupled.
Replication is disaster avoidance (HA), backup is disaster recovery.
-
So in the case of backup, what would be the best option? I still need to get info if they have virtualised servers, if so was thinking about Veeam
-
@Ambarishrh said in LAMP replication to DR site:
So in the case of backup, what would be the best option? I still need to get info if they have virtualised servers, if so was thinking about Veeam
No, just use MySQL's own backup. Veeam would product a backup of the whole system. You just one a single file.
-
THis is all that you need. Take the backup and SCP it over to the other machine or Rsync it over.
-
Ok, so rsync for the files+mysqldump and rsync that too. So just save the mysqldumps on dr location and when something happens, just restore the last backup and bring the server live?
-
@scottalanmiller What about the files?
-
@Ambarishrh said in LAMP replication to DR site:
Ok, so rsync for the files+mysqldump and rsync that too. So just save the mysqldumps on dr location and when something happens, just restore the last backup and bring the server live?
Yep
-
@aaronstuder said in LAMP replication to DR site:
@scottalanmiller What about the files?
That's the "rsync"
-
How about setup MySQL replication to remote site and then enable MySQLdump local backup on the DR site as well with increased frequency than daily ( may be twice a day). This way we have an up to date/latest copy and in case let's say there was a drop table command on master, and primary site failed, I can still switch to secondary, use the latest mysql backup to restore and make it up and running.
-
@Ambarishrh said in LAMP replication to DR site:
Ok, so rsync for the files+mysqldump and rsync that too. So just save the mysqldumps on dr location and when something happens, just restore the last backup and bring the server live?
Yes. But do a restore from time to time to test them, of course.
-
@Ambarishrh said in LAMP replication to DR site:
How about setup MySQL replication to remote site and then enable MySQLdump local backup on the DR site as well with increased frequency than daily ( may be twice a day). This way we have an up to date/latest copy and in case let's say there was a drop table command on master, and primary site failed, I can still switch to secondary, use the latest mysql backup to restore and make it up and running.
Yup, that's what I would do. Get HA and DR all in one setup. Have it take backups 24 times a day if you want. The impact is pretty much zero.
