David T-G wrote:
I was going to say the same thing; its always good (legally) to say you might be down, instead of doing it and having people sue you.Hmmm... Speaking as a SysAdmin, that looks like a cover-all-bases general announcement.
Ditto ;-)Indeed. If your provider is going to take down your web site on a daily basis, you may need to find another provider [...] We do hot backups of mysql with no down time. Drop me a note if you'd like more info on how to switch to us.
For what its worth, sites like http://www.findsp.com will help you search for ISPs that support various features like MySQL. Just talk to the techs responsible for MySQL at your ISP (they have at least one, right?) and ask if they pay for support (helps if they have a problem; but I'm in a glass house here -- we don't yet) and how they do the backups.
Depending on server load, it may be more reasonable to shut down MySQL or at least lock it solid with table locks before doing a backup to get it over with, but backing up from a replication client is much smarter, imho.No, it doesn't; one can use mysqlhotcopy, a filesystem copy, a slave server, or backup software smart enough to quickly lock things as it reads a table -- just to name a few of the *many* possibilities and permutations thereof.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
