MySQL Forums
Forum List  »  Federated Storage Engine

fault handling
Posted by: Tobias Lindinger
Date: November 06, 2008 02:57AM

Hi all,

I have several (~15) MySQL Databases located in the german e-science network. All of the databases contain about 20 tables owning the exactely identical schema. What I want to do is to set up an additional database serving a view that contains a union of all corresponding foreign tables. The import of the foreign tables is implemented with the MySQl federated engine; the views looks like

create view TEST
as
(
(select * from remoteTable1)
union
(select * from remoteTable2)
union
(select * from remoteTable3)
union
...
);

This works fine so far, but if one of the remote MySQL hosts is down querying the view fails. Is there any possibility to handle this error in a way that hosts, that are not available are just skiped and the view contains a union of all available databases?

Thanks in advance!
Best regards,
Tobias

Options: ReplyQuote


Subject
Views
Written By
Posted
fault handling
5754
November 06, 2008 02:57AM


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.