@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.

@FATeknollogee said:

@scottalanmiller said:

I'm watching the videos trying to figure out what it does. Looks like a decent product but haven't seen any single pane of glass stuff yet.

Did you at least find one compelling feature?

Not yet.

@LAH3385
Eventually I will end up where you are suggesting - though I currently use Dell's Appassure Replay, not Veeam.

Looks like the topic ran away from me...been swamped with other things this past week...glad to see it made for good conversation.

@Danp said:

@johnhooks said:

So I've waited about 30 minutes or so, much longer after the backup completed. I still have a snapshot called XO_DELTA_BASE_VDI_SNAPSHOT. Am I able to delete it and it not affect the backup or is the delta based off of the snapshot?

Did you every get clarification on this? I suspect this is needed for the delta backup.

Yes, it uses the snapshots to make the backups. That's what I figured it was doing, but since Dustin didn't see it I thought maybe something was wrong.

We resolved it in another thread, I can't remember which one at this point.

The one big difference is that snowflake firms (or any size) tend to lean towards platform-based, agentless backups while DevOps firms almost never take platform-based backups because they have no need to ever restore a full VM, only the data.

@Dashrender said:

@scottalanmiller earlier was mentioning differentials vs incrementals.

I wonder if the terms still apply, or if the industry at large has dropped the two terms and simply moved to the use of incrementals.

Pretty big deal... if you delete a differential nothing bad happens. Delete an incremental and you have a disaster...

http://community.spiceworks.com/topic/1276968-backing-up-6-pc-s-to-a-nas-using-acronis?page=1#entry-5202270

MySQL seems to be completely hosed. I'm going to have to rebuild the server, as restoring from backups even a week ago, even at the VM level, is not working!

It's the curse of large companies. Once you get to a certain size you have more than enough unhappy customers (or people with a reason to make you look bad) that will be vocal in any setting that you just always have them no matter what you do. No way to be a huge company without that happening.

I tried adding open-files-limit=4096 in /etc/my.cnf and restart mysql. Then executed automysqlbackup again, this time got something else.

Errors reported during AutoMySQLBackup execution.. Backup failed
Error log below..
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES

Checking for fixes