I checked some updates to Shard-Query into SVN. Partitioning
support has been extended for MySQL 5.6+ to ALL partitioning
This includes all previously unsupported types including RANGE
LIST/COLUMNS partitioned tables that are partitioned over more
than one column, and HASH/KEY/LINEAR variants as well.
Shard-Query now exclusively uses the PARTITION hint for partition
elimination instead of WHERE clauses in MySQL 5.6. For 5.5 and
previous versions, support remains limited to LIST,RANGE, and
LIST/RANGE COLUMNS over a single column.
The old mysql interface DAL has been replaced completely by the
There is no major difference for end users except that
you have to check that the return of the query() method is an
object with the is_object() function instead of checking
that it is a resource with the is_resource() function. I updated
bin/run_query, which is the example application.
I …[Read more]