[ale] MySQL Cluster

[Lightner, Jeff]

OP was asking to pick the brain of anyone that is actually doing MySQL in a clustered environment.  The post I responded to makes it sound like he'd be amenable to doing it with Postgresql instead so long as someone who is actually doing it already can talk to him about it.





-----Original Message-----
From: ale-bounces at ale.org [mailto:ale-bounces at ale.org] On Behalf Of Geoffrey Myers
Sent: Friday, February 17, 2012 9:25 AM
To: Atlanta Linux Enthusiasts
Subject: Re: [ale] MySQL Cluster

Lightner, Jeff wrote:
> Given that MySQL is now owned by Oracle and they're already doing
> unfriendly things with the OEL as opposed to other Linux distros as
> regards Oracle products I wouldn't trust them to continue playing
> nice with MySQL.  So if you're making a choice you probably want to
> look at Postgresql.
>
> Unfortunately I've not done clustering with either of them so can't
> help you.

I've been working with a client for a few years now who has used
postgresql for their database of choice.  It works and works well.  I
can't now recall the OPs original post regarding clustering.  Are we
talking about clustered servers?

>
>
>
>
>
> -----Original Message----- From: ale-bounces at ale.org
> [mailto:ale-bounces at ale.org] On Behalf Of Mike Harrison Sent:
> Thursday, February 16, 2012 4:57 PM To: Atlanta Linux Enthusiasts
> Subject: Re: [ale] MySQL Cluster
>
> On Thu, 16 Feb 2012, mike at trausch.us wrote:
>> On 02/16/2012 02:35 PM, Jim Kinney wrote:
>>> the writes are screaming fast and the reads are always
>>> consistent!
>> Additionally, it is FAST and has MANY TUTORIALS!  And hey, magic
>> pixies are always fun, right?  :-)
>>
>> http://www.xtranormal.com/watch/7091415/mysql-is-a-database
>
> While cute and funny, and in some cases true...
>
> It's really not constructive in this case. I'm looking for some
> feedback from someone that has actually or is actually using MySQL in
> a cluster configuration. Yeah, I've been googling, reading, etc.. I
> was hoping to find someone whith whome I have an idea about what kind
> of user/person they were, and what their feedback is.  Random blog
> entries are interesting, but are hard to gauge the relevance.
>
> It's being considered aong other options, including retooling to
> PostgreSQL. Heck... considered Sybase/M$-SQL just because of the
> tools and support for it. (have past experience with them as well)
>
> My personal experience using MySQL, stand alone and master-slave with
> databases in the 1 to 8gb range (small?) in mission critical
> situations has been pretty darn impressive. There are things I wish
> it did better (crosstabs for example) but if used simply, it rocks.
>
> Anyone out there got any constructive criticism or commentary?
>
>
> _______________________________________________ Ale mailing list
> Ale at ale.org http://mail.ale.org/mailman/listinfo/ale See JOBS,
> ANNOUNCE and SCHOOLS lists at http://mail.ale.org/mailman/listinfo
>
>
>
>
> Athena(r), Created for the Cause(tm) Making a Difference in the Fight
> Against Breast Cancer
>
> --------------------------------- CONFIDENTIALITY NOTICE: This e-mail
> may contain privileged or confidential information and is for the
> sole use of the intended recipient(s). If you are not the intended
> recipient, any disclosure, copying, distribution, or use of the
> contents of this information is prohibited and may be unlawful. If
> you have received this electronic transmission in error, please reply
> immediately to the sender that you have received the message in
> error, and delete it. Thank you. ----------------------------------
>
>
> _______________________________________________ Ale mailing list
> Ale at ale.org http://mail.ale.org/mailman/listinfo/ale See JOBS,
> ANNOUNCE and SCHOOLS lists at http://mail.ale.org/mailman/listinfo


--
Until later, Geoffrey

"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson
_______________________________________________
Ale mailing list
Ale at ale.org
http://mail.ale.org/mailman/listinfo/ale
See JOBS, ANNOUNCE and SCHOOLS lists at
http://mail.ale.org/mailman/listinfo




Athena(r), Created for the Cause(tm)
Making a Difference in the Fight Against Breast Cancer

---------------------------------
CONFIDENTIALITY NOTICE: This e-mail may contain privileged or confidential information and is for the sole use of the intended recipient(s). If you are not the intended recipient, any disclosure, copying, distribution, or use of the contents of this information is prohibited and may be unlawful. If you have received this electronic transmission in error, please reply immediately to the sender that you have received the message in error, and delete it. Thank you.
----------------------------------