Thanks for the heads up Andrew, let me know if I can help in any way,
Richard
On Fri, 2009-10-02 at 17:30 +0100, Andrew Morgan wrote:
> Hi Richard,
>
> Great to hear that things are going well :)
>
> We intend to include foreign key support at some point but it hasn't been
> decided when yet (so read not in the very near future) and so you should go
> ahead and look at the stored procedure approach.
>
> Regards, Andrew.
>
> > -----Original Message-----
> > From: Richard McCluskey [mailto:rmccluskey@stripped]
> > Sent: 02 October 2009 16:14
> > To: cluster@stripped
> > Subject: Upcoming features for NDB, FKC soon ?
> >
> > Hi Folks,
> >
> > Well it is 22 hours into my cluster being live, and it appears to be
> > doing rather well :
> >
> > mysql> status
> > --------------
> > mysql Ver 14.14 Distrib 5.1.31, for debian-linux-gnu (x86_64) using
> > EditLine wrapper
> >
> > Connection id: 575918
> > Current database:
> > Current user: admin@stripped
> > SSL: Not in use
> > Current pager: stdout
> > Using outfile: ''
> > Using delimiter: ;
> > Server version: 5.1.35-ndb-7.0.7-cluster-gpl MySQL Cluster
> > Server (GPL)
> > Protocol version: 10
> > Connection: 10.31.4.99 via TCP/IP
> > Server characterset: latin1
> > Db characterset: latin1
> > Client characterset: latin1
> > Conn. characterset: latin1
> > TCP port: 3306
> > Uptime: 22 hours 25 min 36 sec
> >
> > Threads: 169 Questions: 88865750 Slow queries: 61 Opens: 2329814
> > Flush tables: 2 Open tables: 64 Queries per second avg: 1100.695
> > -----
> >
> > Having said that, we have lost on of our applications, as it used
> > CONSTRAINTS and the cluster does not (currently?) support Foreign key
> > constraints. So I was wondering before I try to tackle this issue and
> > try to get round it with triggers and stored procedures:
> >
> > Is there any prospect of NDBCLUSTER engine supporting FKC in the
> > future,
> > and if yes, how far off is it ?
> >
> > I would also like to say 'Thanks' to MySQL/Sun etc for putting out the
> > FOSS version of this application,
> > We would have been dead in the water without it.
> >
> > Best Regards,
> >
> > Richard
> >
> > --
> > Richard McCluskey
> > Senior Engineer,
> > go2 Media Inc.
> > rmccluskey@stripped
> > (617) 457-7870 ext 108
> >
> > m.go2.com - The best entertainment guide on mobile.
> >
> > --
> > MySQL Cluster Mailing List
> > For list archives: http://lists.mysql.com/cluster
> > To unsubscribe:
> > http://lists.mysql.com/cluster?unsub=1
>
>
