[Maria-discuss] Clustering with Maria/Aria engine
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. -- http://twitter.com/scrum8
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
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
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
Hi Joshua On 24/08/2010, at 9:41 PM, Joshua Partogi wrote:
Does Maria/Aria engine supports clustering? Or do we still have to use NDB for this?
No, but we really need to go back a step and look at your basic requirements, before discussing technologies that might fit those requirements. What do you need to do, in terms of overall profile: reads vs writes, their absolute and relative numbers and growth projection, dataset size and growth, schema and whether you need lots of joins, and so on. Once you have that info, you can see what technologies might be suitable for the purpose. Just looking for something with the term "clustering" makes no sense, not least because the term is overloaded and means something else for each architecture (think oracle cluster, ndb cluster, and so on - completely different). Regards, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Exceptional Services for MySQL at a fixed budget. Follow our blog at http://openquery.com/blog/ OurDelta: packages for MySQL and MariaDB @ http://ourdelta.org
participants (3)
-
Alexandre Almeida -
Arjen Lentz -
Joshua Partogi