Friday, July 04, 2008

Mysql Federated tables and Oracle Database links


Taking time out from the Big Migration job to share this with you, and before you say anything *I Know* this is old news, but forgive me because I've been away from MySQL for 4 years, and just because you know this doesn't mean that there aren't other "late adopters" like me out there.

Over the past few weeks I've come across quite a few posts on the net from folks who wanted to use oracle style links between MySQL databases (I don't need to, I just spoted a theme). Researching the storage engines in Mysql 5 (we're upgrading as well as migrating) it seems there is now an answer in the form of the Federated storage engine.

The article also provided me an answer for the perennial problem of needing several instances of MySQL in dev and test, often for exactly the task currently at hand, migrating from one version to another, that answer is the mysql sandbox. Neat. Its a shame that I've already set up my dev environment, I'd like to play with that.


Comments:

blog comments powered by Disqus

I know nothing, I'm not a fortune teller, and you'd be insane to think that I am. This disclaimer was cribbed from an email footer I once received. It is so ridiculous I had to have it for myself.

Statements in this blog that are not purely historical are forward-looking statements including, without limitation, statements regarding my expectations, objectives, anticipations, plans, hopes, beliefs, intentions or strategies regarding the future. Factors that could cause actual results to differ materially from the forward looking statements include risks and uncertainties such as any unforeseen event or any unforeseen system failures, and other risks. It is important to note that actual outcomes could differ materially from those in such forward-looking statements.

Danny Angus Copyright © 2006-2013 (OMG that's seven years of this nonsense)