Re: Mysql backup for large databases

at doesn't take long and don't impact system >>> 2. Restore needs to be done on a quick as possible way in order to >> minimize downtime. >>> >>> The one client is running master - master replication with master server >> in usa, and slave in south africa. They need mast

Re: Mysql backup for large databases

ster - master replication with master server > in usa, and slave in south africa. They need master backup to be done in > the states. > > > > > > Sent via my BlackBerry from Vodacom - let your email find you! > > > > -Original Message- >

Re: Mysql backup for large databases

; Sent via my BlackBerry from Vodacom - let your email find you! > > -Original Message- > From: Reindl Harald > Date: Thu, 01 Nov 2012 16:49:45 > To: mysql@lists.mysql.com > Subject: Re: Mysql backup for large databases > > good luck &g

RE: Mysql backup for large databases

machiel.richa...@gmail.com [mailto:machiel.richa...@gmail.com] > Sent: Thursday, November 01, 2012 8:54 AM > To: Reindl Harald; mysql@lists.mysql.com > Subject: Re: Mysql backup for large databases > > Well, the biggest problem we have to answer for the clients is the > followin

Re: Mysql backup for large databases

ent via my BlackBerry from Vodacom - let your email find you! > > -Original Message- > From: Reindl Harald > Date: Thu, 01 Nov 2012 16:49:45 > To: mysql@lists.mysql.com > Subject: Re: Mysql backup for large databases > > good luck >

Re: Mysql backup for large databases

ith master server in usa, and slave in south africa. They need master backup to be done in the states. Sent via my BlackBerry from Vodacom - let your email find you! -Original Message- From: Reindl Harald Date: Thu, 01 Nov 2012 16:49:45 To: mysql@lists.mysql.com Subject: Re: Mysql backup

Re: Mysql backup for large databases

good luck i would call snapshots on a running system much more dumb than "innodb_flush_log_at_trx_commit = 2" on systems with 100% stable power instead waste IOPS on shared storages Am 01.11.2012 16:45, schrieb Singer Wang: > Assuming you're not doing dumb stuff like innodb_flush_log_at_tx=0 or 2

Re: Mysql backup for large databases

Assuming you're not doing dumb stuff like innodb_flush_log_at_tx=0 or 2 and etc, you should be fine. We have been using the trio: flush tables with read lock, xfs_freeze, snapshot for months now without any issues. And we test the backups (we load the backup into a staging once a day, and dev once

Re: Mysql backup for large databases

Am 01.11.2012 16:36, schrieb Singer Wang: > On Thu, Nov 1, 2012 at 11:34 AM, Rick James > wrote: > > Full backup: > * Xtrabackup (Backup: slight impact on source; more if you have MyISAM > (as mentioned)) > * Slave (Backup: zero impact on Master -- once

Re: Mysql backup for large databases

e (5.6.x?), you can disconnect a partition from a > table and move it to another table; this will greatly speed up "archiving". > > > -Original Message- > > From: Reindl Harald [mailto:h.rei...@thelounge.net] > > Sent: Thursday, November 01, 2012 4:47 AM > > To:

RE: Mysql backup for large databases

t] > Sent: Thursday, November 01, 2012 4:47 AM > To: mysql@lists.mysql.com > Subject: Re: Mysql backup for large databases > > > > Am 01.11.2012 11:28, schrieb Machiel Richards - Gmail: > > Using mysqldump and restores on an 80-100GB database seems a bit > > un

Re: Mysql backup for large databases

Am 01.11.2012 11:28, schrieb Machiel Richards - Gmail: > Using mysqldump and restores on an 80-100GB database seems a bit unpractical > as the restore times seems to > get quite long as well as the backup times. * setup a master/slave configuration * stop the slave * rsync the raw datadir to wh

Re: Mysql backup for large databases

On 01/11/2012 11.28, Machiel Richards - Gmail wrote: [...] I am busy investigating some options relating to the backup for MySQL databases when they get quite large. When using the MySQL enterprise, there is the option to use the MySQL enterprise backup as it is part of the Enterprise

Mysql backup for large databases

Hi All I am busy investigating some options relating to the backup for MySQL databases when they get quite large. When using the MySQL enterprise, there is the option to use the MySQL enterprise backup as it is part of the Enterprise license. However, when using the GA (fre