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. :) Help?
Sorry to hear about your business!
Regarding NDB, I'll begin by offering that I've never set that up :-)
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 :-) 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 :-)
Thanks,
-Eric
Yeah, I was aware of the "Additional MySQL servers to create users on.". I actually pushed for that feature. :)
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