RE: Stored Procedues - Jason Brooke - com.mysql.lists.cluster

8 messages in com.mysql.lists.clusterRE: Stored Procedues

From	Sent On	Attachments
Nick Hoffman	21 Aug 2006 17:15
Stewart Smith	21 Aug 2006 20:19
Benton, Kevin	22 Aug 2006 16:46
Jason Brooke	22 Aug 2006 17:00
Stewart Smith	23 Aug 2006 03:15
Benton, Kevin	23 Aug 2006 08:54
Nick Hoffman	23 Aug 2006 16:46
Stewart Smith	23 Aug 2006 18:03

Subject:	RE: Stored Procedues
From:	Jason Brooke (jas...@ausgamers.com)
Date:	08/22/2006 05:00:15 PM
List:	com.mysql.lists.cluster

I haven't tried it myself, but I'd have thought that if stored procs are stored in an SQL node and not within the cluster, that you'd just create the stored proc on each attached SQL node - akin to creating a new database.

-----Original Message----- From: Benton, Kevin [mailto:kevi...@amd.com] Sent: Wednesday, 23 August 2006 9:47 AM To: Stewart Smith; nick...@altcall.com Cc: MySQL Cluster Mailing List Subject: RE: Stored Procedues

On Tue, 2006-08-22 at 10:15 +1000, Nick Hoffman wrote:

which says that stored procedures exist within a mysqld process

rather

than

within an actual database, and that creating a stored procedure on one mysqld node will not make the SP available on any other mysqld nodes. Is this still the case?

yes.

So, if I understand you correctly, Stewart, if I define a stored procedure while connected to node B, node C will never know about it. If that's the case, IMO - that's a serious bug with NDBCluster. What happens if node B dies?

The opinions stated in this communication do not necessarily reflect the view of Advanced Micro Devices and have not been reviewed by management. This communication may contain sensitive and/or confidential and/or proprietary information. Distribution of such information is strictly prohibited without prior consent of Advanced Micro Devices. This communication is for the intended recipient(s) only. If you have received this communication in error, please notify the sender, then destroy any remaining copies of this communication.