Re:“We have been experiencing a catastrophic DDoS attack”
by eblanshey on Sunday September 04, 2016 @09:42AM
(#12424263)
No need to take production offline when using the percona xtrabackup tool to set up the slave. It's super easy to use, and I've done it multiple times on databases in the hundreds of gigabytes.
[ Parent
| on HN ]
Re:“We have been experiencing a catastrophic DDoS attack”
by tempestn on Monday September 05, 2016 @03:31AM
(#12428699)
That does look like a great tool! If we were on all InnoDB I'd probably try switching over to it instead of LVM snapshot-based backups right now. (Since it can do incremental, mostly.) We have a bunch of large MyISAM tables though (MyISAM used because the tables are read-only, so read speed is the only real consideration), so those would have to be handled separately. I could always xtrabackup all the innodb stuff and then just file copy the myisam tables separately though, since I know they won't be changing.
Hmm, may have to give it a try! Thanks.