On Saturday, June 11, 2011 14:29:54 Alfredo Parisi wrote: > If I start on mysql, in the /var/run/mysqld there is the .sock file...so I > think that the path is correct
How are you starting mysql? I thought you said mysql couldn't write to that directory and you had to create the file yourself to get mysql to work. I can't give you any advice about cluster configuration since I'm a beginner myself, but I know a bit about mysql and I think the problem here is you are trying to create a mysql cluster configuration using 3 different sources: the mysql site, the defaults in the pacemaker mysql script, and the distro defaults. For some reason these all have very different default values for the parameters you need, and the configuration you posted doesn't match any of them. A few thoughts: Are you using the mysql installation that came with the distro, did you install mysql yourself on each node, or did you install it on the drbd device? Each of these will change the default values and the settings you need. If you're using mysql from the distro, what distro are you using? Distros based on openSUSE and Redhat use the pid and socket directories I listed earlier. You can change them, but then you break all the mysql tools and clients that came with the distro. If you're going to use the distro version of mysql I don't know of a good reason to change the defaults. According to the documentation you need to use the same my.cnf for all the nodes and it must reside on the drbd. It should also have the same settings as the default my.cnf on each node if possible since any other setting will break the tools on that node. My suggestion: Unless you need to compile your own mysqld, I would install the distro version on each node and use the distro defaults for both my.cfn and pacemaker. Jeff _______________________________________________ Pacemaker mailing list: Pacemaker@oss.clusterlabs.org http://oss.clusterlabs.org/mailman/listinfo/pacemaker Project Home: http://www.clusterlabs.org Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf Bugs: http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker
