RE: MySQL - Jimmy Guerrero - com.mysql.lists.cluster

8 messages in com.mysql.lists.clusterRE: MySQL

From	Sent On	Attachments
Yee Hsu	14 Jul 2006 18:00
Jimmy Guerrero	17 Jul 2006 05:56
Yee Hsu	17 Jul 2006 09:50
Jimmy Guerrero	17 Jul 2006 10:18
Yee Hsu	17 Jul 2006 10:35
John David Duncan	17 Jul 2006 10:36
Yee Hsu	17 Jul 2006 11:01
John David Duncan	17 Jul 2006 15:00

Subject:	RE: MySQL
From:	Jimmy Guerrero (jgue...@mysql.com)
Date:	07/17/2006 10:18:16 AM
List:	com.mysql.lists.cluster

Hello,

You would still have to migrate your data to NDB on Linux, which doesn't sound like an option for you.

Also, depending on the storage engines you are currently using, you may lose/gain functionality moving to NDB from say MyISAM/Innodb.

For example...

- InnoDB supports more transactional isolation levels then NDB. - MyISAM supports full-text, NDB does not

There are also storage considerations, Cluster 5.0 supports in-memory data only (5.1 supports memory and disk data.)

I suspect MySQL Cluster may not be a good fit for you if you want to avoid any migration issues but still have some sort of synchronous data replication.

FYI, we are doing a Webinar on Thursday titled "High Availability Solutions for MySQL" where we will look at:

MySQL Replication MySQL Cluster MySQL Cluster & Replication Linux Heartbeat & MySQL Replication Linux Heartbeat, DRBD & MySQL Load Balancing & MySQL MySQL w/ Shared-Storage & Clustering Agents Other HA Solutions for MySQL

http://www.mysql.com/news-and-events/web-seminars/

-----Original Message----- From: Yee Hsu [mailto:yee...@opswat.com] Sent: Monday, July 17, 2006 11:51 AM To: 'Jimmy Guerrero'; clus...@lists.mysql.com Subject: RE: MySQL

Okay, problem with my setup is that....

I am running 3 windows machine right now and with 3 databases. They all have the same data, I just need to find a good way to synchronize them.

I currently use a utility called sqlyog to sync them. But it seems inefficient for larger databases. I need a fast good way to do it. But I read MySQL doesn't support clustering in Windows.

So what are my options? I cannot really port to Linux as that might take a lot of resources and time. Is there a workaround solution on this?

How about my 3 database stay on the Windows machine running MySQL. But the MySQL server manager run on the Linux box, can it be setup like this?

Thanks. yee

-----Original Message----- From: Jimmy Guerrero [mailto:jgue...@mysql.com] Sent: Monday, July 17, 2006 5:57 AM To: 'Yee Hsu'; clus...@lists.mysql.com Subject: RE: MySQL

Hello,

Probably best to start with the FAQ:

http://www.mysql.com/products/database/cluster/faq.html

Then, I suggest the reference manual:

http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster.html

Also, take a look at Davies and Fisk's book on MySQL Clustering:

http://dev.mysql.com/books/mysqlpress/

Thanks,

-----Original Message----- From: Yee Hsu [mailto:yee...@opswat.com] Sent: Friday, July 14, 2006 8:01 PM To: clus...@lists.mysql.com Subject: MySQL

I have 3 databases. They all must be the same, thus redundant data.

How do I set them up in a cluster? Can anyone point me to any directions. Thanks.

yee