[HyperDB] Select in multiple partitions

Pablo Fabregat pablo.fabregat at gmail.com
Wed Mar 3 19:47:58 UTC 2010


Ok,
so there's a way to switch between different partitions ?



On 3 March 2010 16:45, Andy Skelton <skeltoac at gmail.com> wrote:

> Sorry, hyperdb does not help you select across partitions. You must query
> each partition yourself and then collate the results.
>
> You might also be interested in the MySQL Federated storage engine.
>
> Andy
>
> On Mar 3, 2010 10:47 AM, "Pablo Fabregat" <pablo.fabregat at gmail.com>
> wrote:
>
> Hi all, i'm using hyperDB with WP MU and i'm trying to do a select in all
> the partitions...
> that is,
> i want to make a "SELECT fields FROM table WHERE etc..." but i need the
> results from all the partitions, is this possible ?
> I set up the servers with add_db_server.
>
> Thanks in advance
> _______________________________________________
> HyperDB mailing list
> HyperDB at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/hyperdb
> _______________________________________________
> HyperDB mailing list
> HyperDB at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/hyperdb
>


More information about the HyperDB mailing list