On Mon, 2003-10-06 at 14:21, Richard Reina wrote:
> I am wanting to protect myself against future potential hard drive
> failures on my DB 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, if you have the resources available I would suggest doing both
RAID and Replication. RAID 5 maximizes your disk space, while making
your system pretty fault tolerant. (this of course assumes Hot
Swappable SCSI Drives). The replication gives you the added level of
fault tolerance, plus on a busy server DB reads can be offloaded to the
replicant freeing up resources on the Master.
Don't know how familiar you are with RAID so this is a breakdown of the
most common options.
RAID0 - disk Stripeing (very fast reads but one drive fails and
everything is lost). Absolutely no fault tolerance. But an option for
a Replicant.
RAID1 - disk mirroring (Duplicate copy of everything on another
harddrive - the problem is that you have to duplicate your drives. If
you have a 80GB disk, you need 2 of them, but you still only use 80GB.
RAID0+1 - disk striping w/ Mirroring, you have 2 RAID0 volumes of
identical size that mirror to each other. You get the speed of RAID0,
and the fault tolerance of RAID1. If you have 2 80GB disk striped, now
you need 4 80GB disks and you only get space of 2 of the 80GBs.
RAID5 - In my opinion the best choice. You maximize available space,
since its (N-1) * Drive capacity. Meaning The number of drives - 1 is
your capacity. The equivilent of 1 drive is used to store parity
information. If one drive fails, the RAID Controller can autocorrect
the missing information on the fly so your system slows down, but stays
available. You remove the bad drive, put a new one in, and the new
drive gets rebuilt and in a few hours you are back to full steam.
You build a raid set with 4 80GB drives, your available capacity would
be 240GB (4 Drives - 1 for parity) * 80GB.
> Richard
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
Woody
In a world without boundaries why
do we need Gates and Windows?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
