Joshua, Federated instead of Federated ;-) So, it's amazing you can join tables within different server, isn't it? But it could be little tricky, because, when you are performing a SELECT (for example) against a federated table you must be aware the data is remotely stored. The data is "downloaded" from the remote server on the fly... the only issue I see is: time! And time is money ;-))))) Sometimes, I prefer have a replication between servers I need tables to be joinned ( when it's applicable, of course). Now, it's the servers you want to federate are tight linked, go for. Is this crap usable for u? :-))))) I hope I helped you. Alex Em 25/08/2010, às 19:11, Joshua Partogi escreveu:
Hi Alexandre,
Thanks for the reply. I might try doing clustering with Aria since someone has mentioned that Aria is similar to MyISAM (CMIIIW). I also won't do it with NDB since I am not convinced after reading what you wrote. =D Any thoughts about Federated though?
Kind regards, Joshua.
On Tue, Aug 24, 2010 at 10:32 PM, Alexandre Almeida <alexandre@hti.com.br> wrote:
Joshua,
Greentings from Brazil!
I never tried clustering Aria before. I have several clusters running with MyISAM. And it works smoothly. You have to go deeper into cons & pros before try. I recommend you test your app's adherence into a cluster enviroment, and, most important be aware about limitations, race conditions, buffer & key behaviour, etc.
With MyISAM you can create Active-Passive and Active-Passive cluster sharing disk (or not). It's quite easy. NDBcluster is a sharing nothing style cluster, fast, reliable and it comes with a lot of bugs & problems - for free ;-))))))) It's a joke. NDB rocks, but I strongly recommend to know the concept behind NDB before think about it.
Regards,
Alex
Em 24/08/2010, às 08:41, Joshua Partogi escreveu:
Hi all,
Does Maria/Aria engine supports clustering? Or do we still have to use NDB for this?
Thanks for your help.
Kind regards, Joshua.
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp