Dave,
On 1 May 2000 [EMAIL PROTECTED] wrote:
> I have a MySQL database, running on SW RAID-0 over ext2, that wants to
> grow beyond the 2GB file size limit of ext2. I will be moving the
> database this week to a four-way SMP system with six drives, so I want
> to take this opportunity to move to a file system that will support
> larger file sizes.
>
> Does anyone here have experience with ReiserFS or ext3 under software
> RAID? What is the simplest option? Should I consider a development
> kernel? What is the most robust option? (I will be moving to RAID-5
> in the process, but I don't want to shift more responsibility onto
> RAID error correction than I have to.)
There's a much simpler approach, which allows you to stick with
ext2/RAID5... See the MySQL manual at http://www.tcx.se/ :
---------------------------------------
7.7 CREATE TABLE syntax
table_options:
RAID_TYPE= {1 | STRIPED | RAID0 } RAID_CHUNKS=# RAID_CHUNKSIZE=#;
The RAID_TYPE option will help you to break the 2G/4G limit on OSes that
don't support big files. You can get also more speed from I/O bottleneck
by putting RAID directories on different physical disks. RAID_TYPE will
work on any OS, as long as you have configured MySQL with --with-raid. For
now the only allowed RAID_TYPE is STRIPED (1 and RAID0 are aliases for
this). If you specify RAID_TYPE=STRIPED for a MyISAM table, MyISAM will
create RAID_CHUNKS sub-directories named 00, 01, 02 in the database
directory. In each of these directories MyISAM will create an
table_name.MYD. When writing data to the data file, the RAID handler will
map the first RAID_CHUNKSIZE *1024 bytes to the first file, the next
RAID_CHUNKSIZE *1024 bytes to the next file and so on.
---------------------------------------
So, basically, create your table with the options:
RAID_TYPE=STRIPED RAID_CHUNKS=10 RAID_CHUNKSIZE=4
Or something similar (CHUNKSIZE shouldn't matter because you're not
putting each file on a seperate filing system, CHUNKS allows a maximum
table size of 20G, increase if necessary)...
Regards,
Corin
/------------------------+-------------------------------------\
| Corin Hartland-Swann | Mobile: +44 (0) 79 5854 0027 |
| Commerce Internet Ltd | Tel: +44 (0) 20 7491 2000 |
| 22 Cavendish Buildings | Fax: +44 (0) 20 7491 2010 |
| Gilbert Street | |
| Mayfair | Web: http://www.commerce.uk.net/ |
| London W1Y 1FE | E-Mail: [EMAIL PROTECTED] |
\------------------------+-------------------------------------/
