MySQL Forums
Forum List  »  Partitioning

Re: Partitioning in MySQL: Range Partitioning
Posted by: Mikael Ronström
Date: May 24, 2005 01:52AM

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:

Options: ReplyQuote

Written By
Re: Partitioning in MySQL: Range Partitioning
May 24, 2005 01:52AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.