Question regarding MySQL module and NDB Clustering

For the life of me I can’t remember whether I hacked a solution, or whether there was one officially put in that I just don’t remember.

So here’s the short version. I had to shut down my company about a year ago, sadly. When I was in business, I have a cluster of MySQL servers running NDB as the default table type, and I know for fact Jamie added NDBCluster as a table type in the MySQL module, and also put a feature in place that when you create a MySQL user on one box, also create it on other cluster servers, so far, so good.

The other hurdle is that when you create a database, it doesn’t automatically exist on the other cluster nodes. I can create a database on box one, then create a table, go to the other box, and nothing is there. If I create the database on the second box however, and then do “show tables”, the table I create on box 1 appears. The reason here is that not all tables are ndb, even in a cluster. What I wanted to do was to create databases on all boxes by default, and if I override to the default table type from ndb, that’s fine, but I wanted to have Webmin/Virtualmin go ahead and create/delete the databases automatically.

I’m pretty sure my old servers DID this though. I just don’t remember if it was an official thing, or if I went mucking through the code to make it happen just in my setup. :slight_smile: Help?

Sorry to hear about your business!

Regarding NDB, I’ll begin by offering that I’ve never set that up :slight_smile:

I’m some quick digging here though, it looks like you can solve the issue of adding users to other servers in System Settings -> Module Config, and set “Additional MySQL servers to create users on”.

As far as the recommended way of pushing out databases across your cluster – that I’m not sure of :slight_smile: I don’t see that built into Virtualmin, but I could be overlooking it, or you may need to install a plugin from the Webmin site.

I’m just trying to get you started – if that doesn’t help, just yell and I’ll make sure Joe or Jamie take a look at your question :slight_smile:

Thanks,
-Eric

Yeah, I was aware of the "Additional MySQL servers to create users on.". I actually pushed for that feature. :slight_smile:

I just didn’t recall if I’d gotten the database creation on other servers in there or not. It’s looking like that was a hack on my own installation.

Can’t find this option “Additional MySQL servers to create users on.” VM 3.87 GPL