On Thu, Jul 03, 2003 at 01:35:51PM -0700, Dathan Vance Pattishall wrote: > > The 3rd approach was to write software with some pointers from a book > called MySQL "The definitive guide to using, programming, administering > MySQL databases 2nd edition" that I picked up at the last convention. I > created a backup server. This server runs many instances of mysqld > 3.53.27 on RedHat 7.3 Boxes.
Yup, that's what I'd recommend. > In conclusion this one stop location for backups has saved my company > around $110K. I'd like to give a presentation at the next mySQL > convention as to how this is accomplished and what is a generic ratio of > backup servers to masters. Jeremy do you think you can aid me in > getting this done? The current ratio with the hardware I'm running is > about 4 masters to 1 backup server. You're looking for help with determining a reasonable ratio for multi-instance backup slaves? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
