Hi,
Michael Gargiullo Wrote:
-------------------------------------------------------
> Hey all,
>
> I'm working on a project to convert an existing
> data storage system to MySQL from Oracle.
> Currently in Oracle, we have 3hour partitions
> setup, each partition on it's own physical disk.
>
> Currently, each night we create the table space
> and partitions 48 hours in advance. The table
> receives an insane amount of data (Currently
> inserting 770M/day moving towards 2B/day) while
> maintaining indexes, querying,etc.
>
> Can I specify physical paths per partition/index?
> We would like to partition out the indexes from
> the data as well. These data rates have already
> pushed us away from SCSI to SATA, just for the
> throughput to disk.
>
If you are using MyISAM as storage engine this is possible.
Then you can use the DATA DIRECTORY parameter on a partition
to specify the path to the data file of the partition. With
INDEX DIRECTORY you can set the path to the index file of the
partition.
> Is any of this possible in MySQL?
All storage engines that make use of the DATA DIRECTORY and INDEX
DIRECTORY feature of partitions will make this possible.
Rgrds Mikael
Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog:
http://mikaelronstrom.blogspot.com