22 Jul
2008
22 Jul
'08
9:53 p.m.
-----Original Message-----
From: users-bounces(a)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(a)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