Hi Jonathan, > > Hi, > > > > > Good Day everyone, > > > > > > I am interested on putting racktables on a mysql cluster. Is anyone > > > doing this now? Did you have to do anything special? > > > > Is this because you have a MySQL Cluster, or you need Racktables to > run in some sort of HA configuration? > > I am not running Racktables on MySQL Cluster, but I don't see > anything obvious to prevent it. I wouldn't create a new cluster > specifically for Racktables though. If you have one already, then > it might be worth testing. > > > > From what I read so far (an it is not much) you need to change the > > > engine to ndbcluser. > > > > I don't have access to a test MySQL Cluster right now, or I would > try it. > > > > > This depends on how you're intending to cluster MySQL. There are many ways > > to > > do this using Linux HA software or through MySQL clustering/relication > > systems. > > > > > Personally if I was doing this I'd use software like linuxha.net to make a > > MySQL cluster app, and then tell Racktables to use that MySQL instance via > > a > > hostname or IP address. > > > > I can think of three options in order of complexity (most to least): > MySQL Cluster, MySQL / DRBD, MySQL Multi-master / Virtual IP. > > MySQL Cluster requires at least 3 servers just to run the database > (if you want any type of HA). There are lots of things to think > about, like all indexes are stored ONLY in RAM (as is ALL data by > default) which can be rather limiting if not engineered correctly. Yeah, it sounds like for that you need pretty good DBA skills. > A MySQL/DRBD option is also somewhat tricky to get going if you haven't > before. It does require less hardware (2 servers) and no > modifications to the tables. If you can be tolorent of a few > seconds of downtime if a node fails, then this should work just > fine. You would have to write a script to launch MySQL on the > failover node too. It's been years since I was "new" to linuxha.net but even then I didn't really find it hard to get going, and the years since it's just gotten easier. I currently run five linuxha.net clusters (most with MySQL HA'ed in them) and another three for clients. The most recent linuxha.net cluster I built HA's XEN guest's and I found that easier to setup than actual cluster apps (which need file syncing and scripts between nodes). Because the XEN guest is self-contained, there's not much to it apart from bringing it down on one node and up on another. > MySQL Multi-master would let you update to either server, and only requires > 2 servers. It could also be more geographically redundant (except > for the shared IP, but you could get around that by using a load > balance like Pirahna in front). This type of replication is > asynchronous and you could lose data. That's something I've always wanted to "try" just out of interest but if there's the possibility of losing data? hmm.. maybe not. Michael. > Hope that helps. > > -Jonathan ------- End of Original Message -------