Hi, Having implemented all the solutions you suggest, I would need more information to answer this problem.
1. What is the acceptable uptime of the system? 95%, 99%, 99.9%, 99.99% ? 2. In the event of a failure, what is the acceptable recovery time? None, 20 mins, 1 hr, 5 hrs, 1 day ? 3. What hardware is running the DB now? 4. How many queries per second is the system running? Is it read heavy or write heavy? (and what about the future) 5. What is the hardware budget? Just the existing hardware, $1000, $5000 etc.. 6. How much time can you afford to spend on it? With this info, I could help to suggest a solution... But without it, You may receive ideas for solutions that are overkill or underkill for your needs. Hope this helps, Andrew -----Original Message----- From: Richard Reina [mailto:[EMAIL PROTECTED] Sent: Monday 06 October 2003 20:36 To: [EMAIL PROTECTED] Subject: RAID, miiror OR replication? I am wanting to protect myself against future potential hard drive failures on my database server running version 3.23.49a. Should I try and set up a RAID, a mirror or would the best solution be to set up MySQL replication. Any suggestions would be greatly appreciated. Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]