MySQL Cluster Solution

[Neil Tompkins]

Hi,

I've used in the past MySQL Community Server 5.x.  Everything is fine,
however I'm now wanting to implement a new High Availability solution and
am considering MySQL Cluster.  However, I heard that MySQL Cluster doesn't
support store procedures ?  Are there any other restrictions I need to be
aware of.

Thanks
Neil

RE: MySQL Cluster Solution

[Andrew Morgan]

Hi Neil,

 MySQL Cluster *does* support stored procedures. There are some limitation that 
MySQL Cluster has; this white paper would be a good place to start... 
http://www.mysql.com/why-mysql/white-papers/mysql-cluster-evaluation-guide/

Regards, Andrew.



 -Original Message-
 From: Neil Tompkins [mailto:neil.tompk...@googlemail.com]
 Sent: 07 March 2013 14:57
 To: [MySQL]
 Subject: MySQL Cluster Solution
 
 Hi,
 
 I've used in the past MySQL Community Server 5.x.  Everything is fine,
 however I'm now wanting to implement a new High Availability solution
 and am considering MySQL Cluster.  However, I heard that MySQL Cluster
 doesn't support store procedures ?  Are there any other restrictions I
 need to be aware of.
 
 Thanks
 Neil

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: MySQL Cluster Solution

[Johan De Meersman]

- Original Message -
 From: Neil Tompkins neil.tompk...@googlemail.com
 Subject: MySQL Cluster Solution
 
 I've used in the past MySQL Community Server 5.x.  Everything is
 fine, however I'm now wanting to implement a new High Availability solution
 and am considering MySQL Cluster.  However, I heard that MySQL Cluster
 doesn't support store procedures ?  Are there any other restrictions I need
 to be aware of.

It is a completely different product, Neil, which just happens to also have a 
gateway for MySQL. It is not 'just another storage engine' - study it hard, and 
do extensive testing before you even consider switching.

That is not to say that it might not be a good match for your needs; just that 
it's not a quick switch.


-- 
Unhappiness is discouraged and will be corrected with kitten pictures.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

RE: MySQL Cluster Solution

[Rick James]

What do _you_ mean by  a new High Availability solution?

See also Percona Cluster.  It uses InnoDB (XtraDB), so that might be zero 
change for you.  Oops, except that you should check for errors after COMMIT.

 -Original Message-
 From: Johan De Meersman [mailto:vegiv...@tuxera.be]
 Sent: Thursday, March 07, 2013 7:06 AM
 To: Neil Tompkins
 Cc: [MySQL]
 Subject: Re: MySQL Cluster Solution
 
 - Original Message -
  From: Neil Tompkins neil.tompk...@googlemail.com
  Subject: MySQL Cluster Solution
 
  I've used in the past MySQL Community Server 5.x.  Everything is
 fine,
  however I'm now wanting to implement a new High Availability solution
  and am considering MySQL Cluster.  However, I heard that MySQL
 Cluster
  doesn't support store procedures ?  Are there any other restrictions
 I
  need to be aware of.
 
 It is a completely different product, Neil, which just happens to also
 have a gateway for MySQL. It is not 'just another storage engine' -
 study it hard, and do extensive testing before you even consider
 switching.
 
 That is not to say that it might not be a good match for your needs;
 just that it's not a quick switch.
 
 
 --
 Unhappiness is discouraged and will be corrected with kitten pictures.
 
 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/mysql