[OpenSER-Users] openser + mysql clusters

[Watkins, Bradley]

> -----Original Message-----
> From: users-bounces at lists.openser.org 
> [mailto:users-bounces at lists.openser.org] On Behalf Of Sajith T S
> Sent: Tuesday, July 22, 2008 7:01 AM
> To: Stanisław Pitucha
> Cc: users at 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