fault handling
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
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.