[nycphp-talk] MySQL Clustering & HA
Jon Baer
jonbaer at jonbaer.com
Sat Mar 17 19:06:37 EDT 2007
I think they are trying to get out of having all of the data in
memory ...
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-disk-data.html
The one slick part of ~newer~ versions is autodiscovery ...
-snip-
Autodiscovery of databases is now supported for multiple MySQL
servers accessing the same MySQL Cluster, provided that a given
mysqld is already running and is connected to the cluster at the time
that the database is created on a different mysqld.
-snip-
- Jon
On Mar 16, 2007, at 10:10 PM, Hans Zaunere wrote:
>
> Dave,
>
> Dave Youn wrote on Friday, March 16, 2007 8:35 AM:
>> This might be a little off topic, but I'm wondering if anyone has
>> experience with MySQL clustering?
>
> I do...
>
>> I'm working with a System Administrator to architect a failover
>> solution and he's under the impression that we need MySQL HA, but I
>> don't see that product offered on mysql.com, all I see are MySQL
>> Cluster, and MySQL Cluster Carrier Grade.
>>
>> Also, what are the limitations/requirements for deploying a cluster
>> into production? Is this something easy to setup, or worth hiring a
>> consultant for?
>
> Clustering can be a little tricky. For one thing, it's a RAM based
> database, so capacity planning is important. It's fairly
> straightforward to
> set up, but not as simple as MySQL itself.
>
> I think I'm actually speaking with someone from Columbia about
> cluster next
> week.
>
> ---
> Hans Zaunere / President / New York PHP
> www.nyphp.org / www.nyphp.com
>
>
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
>
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php
More information about the talk
mailing list