Hi,
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:
http://mikaelronstrom.blogspot.com
Edited 1 time(s). Last edit at 03/28/2006 02:21PM by Mikael Ronstrom.