MySQL Forums
Forum List  »  Partitioning

Re: oddball question, can a partition be federated?
Posted by: Mikael Ronström
Date: March 28, 2006 03:43AM


Mark Nielsen wrote:
> I would like to do something that is a little odd.
> I would like to create a table where one of the
> partitions is federated.
> One partition would reside on the local server and
> another partition would be hosted by another
> server.
> Is this possible?

In 5.1, MySQL only supports partitioned tables where all
partitions use the same storage engine. You can however
solve the same problem by using a view instead.

Rgrds Mikael

> I tried to see if I could do it, but I couldn't
> make it happen.
> Thanks!
> Mark

Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog:

Edited 1 time(s). Last edit at 03/28/2006 02:21PM by Mikael Ronstrom.

Options: ReplyQuote

Written By
Re: oddball question, can a partition be federated?
March 28, 2006 03:43AM

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.