Arno Lehmann wrote:
Hello,
Dmitry S. Vlasov wrote:
Hello!
Can anyone tell me right solution for backup MySQL databases (MyISAM
and InnoDB) without slave server ( i mean without any replication)
and without stopping service?
How I feel, backup binary files on-the-fly is realy bad idea :)
There are different options, and which one is best for you depends on
your needs.
- You could use a run before script that stops the databse and a run
after script to start it again. This makes database access unpossible
during backup, obviously, and when using the same database server for
your backup that's not really an option.
In one situation I can stop/start mysqld before/after job...
I add folowing in my job:
Client Run Before Job = "/usr/local/etc/rc.d/mysql-server.sh stop"
Client Run After Job = "/usr/local/etc/rc.d/mysql-server.sh start"
and see:
244 Increme pluto.2005-09-02_15.11.32 has terminated
for a long time
then I run
/usr/local/etc/rc.d/mysql-server.sh stop
on the remote host - and in the same time jod finish.
next I insert exit 0; in /usr/local/etc/rc.d/mysql-server.sh for both
stop and start but still have 'frozen' job
:(
Do you have any idea ?
- You could use a snapshop, but this doesn't guarantee a consistent
state of the database before backup, it only lowers the risk of the
database changing during backup and thus creating an inconsistent backup.
- Use mysqldump to dump the database(s) to a file or sucket you then
store. The options --lock-tables and --single-transaction could be useful
- mysqlhotcopy could also be used.
- Using any of the above, you could inform your applications that the
database is to be modified and they have to keep their fingers off it.
Arno
-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle
Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing
& QA
Security * Process Improvement & Measurement *
http://www.sqe.com/bsce5sf
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
