Re: [appfuse-user] Appfuse w/ MySQL Cluster

2007-02-25 Thread Dale Newfield
I have not worked with it, but Sequoia might be an option: http://sequoia.continuent.org Sequoia is a transparent middleware solution offering clustering, load balancing and failover services for any database. -Dale - To un

Re: [appfuse-user] Appfuse w/ MySQL Cluster

2007-02-25 Thread Amin Lalji
Just a quick update, Found this in option for using Hibernate with/ MySQL Cluster http://dev.mysql.com/tech-resources/articles/mysql-enforcing-foreign-keys.ht ml Essentially, you use triggers to manage your constraints... Problem is you will need to write a set of triggers for each table which c

Re: [appfuse-user] Appfuse w/ MySQL Cluster

2007-02-24 Thread Amin Lalji
Yeah it bites (for now)... Here's the reference: http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-limitations.html "Unsupported features (do not cause errors, but are not supported or enforced): The foreign key construct is ignored, just as it is in MyISAM tables." I guess the only option

Re: [appfuse-user] Appfuse w/ MySQL Cluster

2007-02-24 Thread Matt Raible
If it's true that MySQL Cluster doesn't support foreign key constraints - I would find another database. That's a pretty basic feature of relational databases. Matt On 2/24/07, Amin Lalji <[EMAIL PROTECTED]> wrote: Hey All, Has anybody had any success with using Appfuse + Hibernate with a

[appfuse-user] Appfuse w/ MySQL Cluster

2007-02-24 Thread Amin Lalji
Hey All, Has anybody had any success with using Appfuse + Hibernate with a MySQL Cluster? >From what I can tell, MySQL Cluster (5.1.15) does not support foreign key constraints which hibernate depends on to manage relationships between objects... One option might be to dump the cluster in favour o

[appfuse-user] Appfuse w/ MySQL Cluster

2007-02-24 Thread Amin Lalji
Hey All, Has anybody had any success with using Appfuse + Hibernate with a MySQL Cluster? >From what I can tell, MySQL Cluster (5.1.15) does not support foreign key constraints which hibernate depends on to manage relationships between objects... One option might be to dump the cluster in favour o