maria-discuss team mailing list archive

[Alexandre Almeida <alexandre@xxxxxxxxxx>]

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@xxxxxxxxxx> 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.
> > >
> > > --
> > > http://twitter.com/scrum8
> > >
> > > _______________________________________________
> > > 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
>
>
>
> --
> http://twitter.com/scrum8