Hi Tim,
The combination of Federated and Partitioned provides exactly that as far as I understand.
The federated handler provides access to tables in other MySQL Servers (or even other
DBMS's like Oracle). An early prototype of this handler is available already in 5.0 and more
development of it happens in 5.1.
It will be possible to use the federated storage engine to handle each partition in the partitioned
table. Thus each partition is in this case a table on a remote MySQL Server.
There is some thought into how to manage this "distributed" table as well. If you have
any ideas or suggestions they are most welcome.
Best regards Mikael Ronstrom
Tim Matthews wrote:
> Mikael,
>
> I was wondering if this will allow partitioning
> across databases. If I read correctly, it seems
> that this feature will only work on the same
> engine, therefore server. Do I have that correct?
> If so, how long before MySQL will support
> partitions across database instances?
>
> Thanks,
>
> Tim
Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog:
http://mikaelronstrom.blogspot.com