-----Original Message----- From: users-bounces@lists.openser.org [mailto:users-bounces@lists.openser.org] On Behalf Of Sajith T S Sent: Tuesday, July 22, 2008 7:01 AM To: Stanisław Pitucha Cc: users@lists.openser.org Subject: Re: [OpenSER-Users] openser + mysql clusters
Thank you so much for these advises, they are so valuable. Another "gotcha" (well, not really a gotcha...) is that you need to re-create a schema on all other nodes in order to make it "visible" across the cluster.
This is mentioned in mysql official documentation, but not in the quickstart kind of guides I went through. Spent quite a bit of time on this, pulling my hair... until I chanced upon the official documentation and felt all embarassed.
I'm not sure about MySQL Cluster 5.0, but early versions of 5.1.x only required creating the database ("create database ...") and not the entire schema.
However, a pleasant surprise to me when I recently upgraded to 5.1.23 NDB 6.2.15 was that even the database creation was unnecessary. So it appears this frustration has been resolved. I agree though that it was annoying, and that was with just having to create the DB.
There is still the frustration that views and triggers have to be created invidually on the MySQL nodes.
Regards, - Brad