hi, I'am useing mariadb-galera cluster. You can run two instances at same macihne ( I'am running two at two machines), then you can remove/close replication copy from for backup and backup it, after backup you start it and it will syncronize,.. You have copy all the time.
Actually I'am running one sql service for BACULA backup, two for all other applications like owncloud, sage, dbmail,... yes at two difrent machines. That way I have replicated copy all the time and can service eighter server. You can backup by mysql dump then copy to safe place or YOU CAN BACKUP whole /var/lib/mysql,... joni 2015-02-04 19:57 GMT+02:00 Curtis Maurand <cur...@maurand.com>: > Hello, > I just had to drop the dbmail database and restore from a backup. The > restore process took an inordinate amount of time for an 8 GB (that was the > size of the dump file) database (it took hours). Is there anyway to speed > that up? are there dump options I should be looking at to make the restore > go faster? > > Thanks, > Curtis > -- > Curtis Maurand > cur...@maurand.com > 207-252-7748 > > _______________________________________________ > DBmail mailing list > DBmail@dbmail.org > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail > > -- Joni-Pekka Kurronen joni.kurro...@gmail.com gsm. +358 50 521 2279
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
