MySQL Forums
Forum List  »  Newbie

Re: Creating a view from database tables on different servers
Posted by: Phillip Ward
Date: October 20, 2016 05:08AM

In my opinion; no, it's not.

If the second host is taken down for any reason, then your database has to deal with it. The database is not well suited to doing this. The best it can do is to throw some sort of error. Your application now has to work out whether any error that it receives is a "real" error - a "local" table that isn't there - or a "remote" error - the other database has "disappeared".
This makes your error handling appallingly complicated for no real benefit.

An Application can handle the disappearance of one of more of its data resources far more gracefully.

Regards, Phill W.

Options: ReplyQuote


Subject
Written By
Posted
Re: Creating a view from database tables on different servers
October 20, 2016 05:08AM


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.