Re: Partitioning in MySQL: Range Partitioning
Hi,
On many web site or e-commerce site, databases are used to store unstructured data and since MySQL is more used in such domain, round robin partitionning even if it is done via a hash table can be of a great help.
By the way some DBEngine use a hash table mapping to support round robin partitionning over multiple instance, and some others use an Instead Of trigger to populate tables which are parts of a global view !
As your memory come back, :-), yes this could help in maintenance operations by disabling a partition in order to restore it : "Writes than are possible on the other partitions and partial data read can be done only on the remaining partitions".
In range partitionning mode, a partition can be disabled, dropped or moved to a table and then if an insert occurs it will make an Exception in some cases. In other cases when enabling the disabled partition row movement occurs if it's enabled.
Rgrds Mohamed