9 messages in com.mysql.lists.clusterRe: SQL Servers in relation to Data N...
FromSent OnAttachments
Dan Trainor23 Jan 2006 10:07 
Mikael Ronström23 Jan 2006 11:55 
Dan Trainor23 Jan 2006 12:06 
Mikael Ronström23 Jan 2006 12:58 
Dan Trainor23 Jan 2006 16:26 
Alex Davies23 Jan 2006 16:32 
Dan Trainor23 Jan 2006 16:42 
Alex Davies23 Jan 2006 16:58 
Dan Trainor23 Jan 2006 17:06 
Subject:Re: SQL Servers in relation to Data Nodes
From:Mikael Ronström (mik@mysql.com)
Date:01/23/2006 11:55:48 AM
List:com.mysql.lists.cluster

Hi,

Data Node is where the data resides but no SQL functionality. SQL Nodes is a MySQL Server that gets data for queries from the Data Nodes. There can be several Data Nodes and several SQL Nodes in a cluster and each SQL node sees all data in all Data Nodes.

Rgrds Mikael PS: For more info check on-line MySQL Reference Manual

2006-01-23 kl. 19.08 skrev Dan Trainor:

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

Good morning, all -

I've been becoming increasingly familiar with how the MySQL Cluster operates, and I'm very, very excited. So excited, in fact, that we're doing heavy development on an application based upon it. However, there are still some loose ends which I'd like tied up.

I have searched the archives, and although I've found some responses that are close, I have not found an exact answer for what I'm looking for.

I understand the uses of (naturally) the mnanagement server and the data node. However, I don't understand where the SQL Server comes into play. Don't the data nodes just appear as large SQL Servers which participate in the cluster configuration?

I suppose it would make sense to have data nodse and SQL nodes if they were completely seperate beasts. I believe it would make sense for clients to query the SQL nodes instead of the data nodes, thus decreasing any load which may have applied to the data nodes. However, using an SQL server in this manner, wouldn't this defeat the purpose of the cluster as a whole?

Thanks for your time, it's much appreciated - -Dan Trainor -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFD1RuHhTPx3xy3bu0RAsOVAJ4uytCUzeOOD7JMY9/XpkBR9rbUOwCfbYh6 ThlqkRXrCclL7uiyquhwKVI= =ZfXo -----END PGP SIGNATURE-----

-- MySQL Cluster Mailing List For list archives: http://lists.mysql.com/cluster To unsubscribe: http://lists.mysql.com/cluster?unsub=mik@mysql.com

Mikael Ronstrom, Senior Software Architect MySQL AB, www.mysql.com

Jumpstart your cluster: http://www.mysql.com/consulting/packaged/cluster.html My blog: http://mikaelronstrom.blogspot.com