Hi, Thanks a lot for all those replies! It seems like my hosting company is using the cheapest and/or easiest way to make a full, consistent backup. And I guess the ideal method from those mentioned is to have a slave server you can take down for backup. The question is then whether such backup is necessary on a daily basis (I get a daily mysqldump for my records anyway without sysadmin intervention), and also how to find this kind of detailed technical information from hosting companies to be able to choose one with a good quality/price ratio. Any opinions on either? Thanks.
"Michael T. Babcock" ha escrito: > David T-G wrote: > > >Hmmm... Speaking as a SysAdmin, that looks like a cover-all-bases > >general announcement. > > > > 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. > > >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. > > > > Ditto ;-) > > 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. > > >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. > > > > 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. > > -- > Michael T. Babcock > C.T.O., FibreSpeed Ltd. > http://www.fibrespeed.net/~mbabcock -- Clemente Zamora GlobalReservas (http://www.clementezamora.com) --------------------------------------------------------------------- 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
