MySQL Clustering

Dear MySQL,

I am interested in clustering for MySQL. This claims to offer the
redundancy scalability and performance we require.

One thing I am really disappointed at is that clustering seems not to
offer much Referential Integrity (RI). Specifically, Foreign Key
References.

For better or for worse we have always used RI, therefore have come to
expect this in our programs and administration tools. It's therefore an
absolute necessity.

May I ask if any member know whether this is planned, and if so, what
sort of time periods?

Thanks,

Ben.





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

RE: MySQL Clustering

Hello,

We are aware that some user require FK's and would like to see them
supported in MySQL Cluster.

We are hoping to offer this functionality initially through the MySQL
interface (not the NDB API) some time next year.

Look for announcements on the MySQL Cluster forum and mailing list for it's
availability.

Thanks,

Jimmy Guerrero
Sr Product Manager
MySQL, Inc

> -----Original Message-----
> From: Ben Clewett [mailto:Ben.Clewett@roadrunner.uk.com]
> Sent: Tuesday, May 30, 2006 6:48 AM
> To: mysql@lists.mysql.com
> Subject: MySQL Clustering
>
> Dear MySQL,
>
> I am interested in clustering for MySQL. This claims to
> offer the redundancy scalability and performance we require.
>
> One thing I am really disappointed at is that clustering
> seems not to offer much Referential Integrity (RI).
> Specifically, Foreign Key References.
>
> For better or for worse we have always used RI, therefore
> have come to expect this in our programs and administration
> tools. It's therefore an absolute necessity.
>
> May I ask if any member know whether this is planned, and if
> so, what sort of time periods?
>
> Thanks,
>
> Ben.
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=jguerrero@mysql.com
>
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: MySQL Clustering

At 12:47 pm +0100 30/5/06, Ben Clewett wrote:
>I am interested in clustering for MySQL. This claims to offer the redundancy scalability and performance we require.
>
>One thing I am really disappointed at is that clustering seems not to offer much Referential Integrity (RI). Specifically, Foreign Key References.
>
>For better or for worse we have always used RI, therefore have come to expect this in our programs and administration tools. It's therefore an absolute necessity.
>
>May I ask if any member know whether this is planned, and if so, what sort of time periods?

FWIW this is probably not the best place to ask about the roadmap / timescale for the development of MySQL cluster - you would probably have more luck getting the information you want else where (dedicated cluster list/forum or contacting MySQL directly).

However it's possible that this (from the latest MySQL newsletter) might be of interest:

At 6:37 am +0200 24/5/06, MySQL AB wrote:
> Article: Advanced MySQL Replication Techniques
>
> In this article, Giuseppe Maxia, CTO of Stardata IT, provides unique
> insight into circular replication (multi-master replication) with
> failover.
>
> Read the article >>
> http://dev.mysql.com/tech-resources/articles/advanced-mysql- replication.html

HTH,
James Harvard

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: MySQL Clustering

Jimmy,

Thanks for the info. I'll look out for FK's in clustering and hopefully
we can do some testing at that time.

Regards,

Ben



Jimmy Guerrero wrote:
> Hello,
>
> We are aware that some user require FK's and would like to see them
> supported in MySQL Cluster.
>
> We are hoping to offer this functionality initially through the MySQL
> interface (not the NDB API) some time next year.
>
> Look for announcements on the MySQL Cluster forum and mailing list for it's
> availability.
>
> Thanks,
>
> Jimmy Guerrero
> Sr Product Manager
> MySQL, Inc
>
>> -----Original Message-----
>> From: Ben Clewett [mailto:Ben.Clewett@roadrunner.uk.com]
>> Sent: Tuesday, May 30, 2006 6:48 AM
>> To: mysql@lists.mysql.com
>> Subject: MySQL Clustering
>>
>> Dear MySQL,
>>
>> I am interested in clustering for MySQL. This claims to
>> offer the redundancy scalability and performance we require.
>>
>> One thing I am really disappointed at is that clustering
>> seems not to offer much Referential Integrity (RI).
>> Specifically, Foreign Key References.
>>
>> For better or for worse we have always used RI, therefore
>> have come to expect this in our programs and administration
>> tools. It's therefore an absolute necessity.
>>
>> May I ask if any member know whether this is planned, and if
>> so, what sort of time periods?
>>
>> Thanks,
>>
>> Ben.
>>
>>
>>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=jguerrero@mysql.com
>>
>>
>
>


--
Ben Clewett
+44(0)1923 460000
Project Manager
Road Tech Computer Systems Ltd
http://www.roadrunner.uk.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: Mysql clustering

Try search it on howtoforge.com

Or buy a book like "high performance mysql" for reference.

Regards,
mary.



--- machielr@rdc.co.za wrote:

From: Machiel Richards
To: mysql mailing list
Subject: Mysql clustering
Date: Wed, 23 Feb 2011 08:53:10 +0200

Good day all

Does anybody perhaps have a good resource or ebook on how to setup
mysql clustering?

I need to learn how to set this up in order to test and present to a
client.

I tried to find info on the net and on the mysql website, but thus
far I haven't been able to find proper documentation on how to set
everything up.

If someone perhaps have the ebook version of the mysql clustering
certification study guide, that would help me as well as I might be
looking at going for the certification as well.






____________________________________________________________ _
Get your free email address from http://mail.vu

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Mysql clustering

Hi Machiel,

Check these two links for good resources:

http://www.amazon.com/High-Performance-MySQL-Optimization-Re plication/dp/0596101716

http://www.amazon.com/MySQL-High-Availability-Building-Cente rs/dp/0596807309

AFAIK there is no up-to-date (print) book about NDB (anyone?). I've used
the MySQL online reference manual to study for the cluster
certification, so that should be enough to pass the cluster exam ;-)

Sander

On 02/23/2011 09:18 AM, blue mary wrote:
> Try search it on howtoforge.com
>
> Or buy a book like "high performance mysql" for reference.
>
> Regards,
> mary.
>
>
>
> --- machielr@rdc.co.za wrote:
>
> From: Machiel Richards
> To: mysql mailing list
> Subject: Mysql clustering
> Date: Wed, 23 Feb 2011 08:53:10 +0200
>
> Good day all
>
> Does anybody perhaps have a good resource or ebook on how to setup
> mysql clustering?
>
> I need to learn how to set this up in order to test and present to a
> client.
>
> I tried to find info on the net and on the mysql website, but thus
> far I haven't been able to find proper documentation on how to set
> everything up.
>
> If someone perhaps have the ebook version of the mysql clustering
> certification study guide, that would help me as well as I might be
> looking at going for the certification as well.
>
>
>
>
>
>
> ____________________________________________________________ _
> Get your free email address from http://mail.vu
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org