← Back to team overview

maria-discuss team mailing list archive

Re: Clustering with Maria/Aria engine



	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.


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,

On Tue, Aug 24, 2010 at 10:32 PM, Alexandre Almeida
<alexandre@xxxxxxxxxx> wrote:

       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.



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,


Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp


TIFF image