On Sun, Jul 06, 2003 at 10:10:22PM -0600, Jim McAtee wrote:
> Jim McAtee wrote:
>
> > David Lloyd wrote:
> >
> > > > What would be the ideal RAID configuration for a dedicated MySQL db
> > > > server running on FreeBSD?
> > > >
> > > > We're also running some MySQL databases on Windows 2000 Server
Jim McAtee wrote:
David Lloyd wrote:
What would be the ideal RAID configuration for a dedicated MySQL db
server running on FreeBSD?
We're also running some MySQL databases on Windows 2000 Servers. What
about the best configuration for a dedicated W2k server running MySQL?
That depends
Jim McAtee wrote:
> David Lloyd wrote:
>
> > > What would be the ideal RAID configuration for a dedicated MySQL db
> > > server running on FreeBSD?
> > >
> > > We're also running some MySQL databases on Windows 2000 Servers. What
> > > about the best configuration for a dedicated W2k server runni
David Lloyd wrote:
> > What would be the ideal RAID configuration for a dedicated MySQL db
> > server running on FreeBSD?
> >
> > We're also running some MySQL databases on Windows 2000 Servers. What
> > about the best configuration for a dedicated W2k server running MySQL?
>
> That depends on
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jim,
> What would be the ideal RAID configuration for a dedicated MySQL db
> server running on FreeBSD?
>
> We're also running some MySQL databases on Windows 2000 Servers. What
> about the best configuration for a dedicated W2k server running MySQ
I just assumed your question was for mysql data only..
If you want total I use:
OS - raid 1 (2 X 18.2gb - 10kRPM)
DATA - raid 0+1 (# X 18.2gb - 15kRPM)
usually a dataset is comprised of 6-10 disks.. you could go larger with
the drive size.. but more spindles = more thruput
Swap isn't much of
That's it? The entire system - OS, swap space and data in a single array?
Nothing more involved?
[EMAIL PROTECTED] wrote:
> My favourite for dedicated db servers (good amount of data, but a ton of
> access, queries/sec) is raid 0+1 ... fast access, but requires a good number
of disks..
>
> Be
My favourite for dedicated db servers (good amount of data, but a ton of
access, queries/sec) is raid 0+1 ... fast access, but requires a good number of
disks..
Be sure to use a good raid controller, multiple channels for the disks if
possible..
On Sat, 5 Jul 2003, Jim McAtee wrote:
> What w
It depends on what your goal is and how many disks your system will
contain.
Personally I like a disk configuration with multiple spindels for
performance. I also require redundancy, RAID-5 sounds good and is but I
want the most out of writes, so I go with RAID-1+0.
Hope this helps.
On Sat,
