Re: Replication setup (for the first time)
> the LVM option and they do not think it's a good and cheap solution to backup databases.
The setup:
* Create a volume of 5-10% of the disk.
The backup:
* Enable the VM
* Stop mysqld
* Do "snapshot" (takes a minute or so; establishes a copy-on-write copy of the disk)
* Start mysqld
* Copy the snapshot to some other location (SAN, another machine, backup tape, cloud, whatever). This does a lot of I/O. This step must be finished before the 5-10% is filled up. (It probably won't fill up in a day, maybe a week.)
* Release the VM.
Note: I do not recommend leaving the backup on the original machine; after all, what if that disk crashes? You could use rsync to copy to another machine which, itself, has some number of LVMs. You could probably keep a few dozen daily (or weekly) copies of your 500GB in less than 1TB.
Any form of "backup" requires at least 500GB for one full copy. (OK, possibly less if compressed.) So, I don't see where the SAN guys think it is "costly".
> these kind of backups are not good solutions for Relational Databases as they may not be consistent in terms of transactions.
Hence my suggestion to stop+restart mysqld.
> I will work more on xtrabackup and its incremental backup options.
Good.
(I argue in favor of either LVM and XtraBackup -- but you have to decide what you are comfortable with.)
> Thanks for your guidance Rick!
My pleasure.
Subject
Views
Written By
Posted
2728
May 23, 2014 02:36AM
1073
May 26, 2014 09:42PM
Re: Replication setup (for the first time)
953
May 27, 2014 10:16PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.