This is my file my.cnf<br>#<br># The MySQL database server configuration file.<br>#<br># You can copy this to one of:<br># - "/etc/mysql/my.cnf" to set global options,<br># - "~/.my.cnf" to set user-specific options.<br>
# <br># One can use all long options that the program supports.<br># Run program with --help to get a list of available options and with<br># --print-defaults to see which it would actually understand and use.<br>#<br># For explanations see<br>
# <a href="http://dev.mysql.com/doc/mysql/en/server-system-variables.html">http://dev.mysql.com/doc/mysql/en/server-system-variables.html</a><br><br># This will be passed to all mysql clients<br># It has been reported that passwords should be enclosed with ticks/quotes<br>
# escpecially if they contain "#" chars...<br># Remember to edit /etc/mysql/debian.cnf when changing the socket location.<br>[client]<br>port = 3306<br>socket = /var/run/mysqld/mysqld.sock<br><br># Here is entries for some specific programs<br>
# The following values assume you have at least 32M ram<br><br># This was formally known as [safe_mysqld]. Both versions are currently parsed.<br>[mysqld_safe]<br>socket = /var/run/mysqld/mysqld.sock<br>nice = 0<br>
<br>[mysqld]<br>#<br># * Basic Settings<br>#<br><br>#<br># * IMPORTANT<br># If you make changes to these settings and your system uses apparmor, you may<br># also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.<br>
#<br><br>user = mysql<br>socket = /var/run/mysqld/mysqld.sock<br>port = 3306<br>basedir = /usr<br>#datadir = /var/lib/mysql/<br>datadir = /data/mysql/<br>tmpdir = /tmp<br>skip-external-locking<br>
#<br># Instead of skip-networking the default is now to listen only on<br># localhost which is more compatible and is not less secure.<br>#bind-address = 127.0.0.1<br>bind-address = 10.10.7.100<br>#<br># * Fine Tuning<br>
#<br>key_buffer = 16M<br>max_allowed_packet = 16M<br>thread_stack = 192K<br>thread_cache_size = 8<br># This replaces the startup script and checks MyISAM tables if needed<br># the first time they are touched<br>
myisam-recover = BACKUP<br>#max_connections = 100<br>#table_cache = 64<br>#thread_concurrency = 10<br>#<br># * Query Cache Configuration<br>#<br>query_cache_limit = 1M<br>query_cache_size = 16M<br>
#<br># * Logging and Replication<br>#<br># Both location gets rotated by the cronjob.<br># Be aware that this log type is a performance killer.<br># As of 5.1 you can enable the log at runtime!<br>#general_log_file = /var/log/mysql/mysql.log<br>
#general_log = 1<br><br>log_error = /var/log/mysql/error.log<br><br># Here you can see queries with especially long duration<br>#log_slow_queries = /var/log/mysql/mysql-slow.log<br>#long_query_time = 2<br>
#log-queries-not-using-indexes<br>#<br># The following can be used as easy to replay backup logs or for replication.<br># note: if you are setting up a replication slave, see README.Debian about<br># other settings you may need to change.<br>
#server-id = 1<br>#log_bin = /var/log/mysql/mysql-bin.log<br>expire_logs_days = 10<br>max_binlog_size = 100M<br>#binlog_do_db = include_database_name<br>#binlog_ignore_db = include_database_name<br>
#<br># * InnoDB<br>#<br># InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.<br># Read the manual for more InnoDB related options. There are many!<br>#<br># * Security Features<br>#<br># Read the manual, too, if you want chroot!<br>
# chroot = /var/lib/mysql/<br>#<br># For generating SSL certificates I recommend the OpenSSL GUI "tinyca".<br>#<br># ssl-ca=/etc/mysql/cacert.pem<br># ssl-cert=/etc/mysql/server-cert.pem<br># ssl-key=/etc/mysql/server-key.pem<br>
<br><br><br>[mysqldump]<br>quick<br>quote-names<br>max_allowed_packet = 16M<br><br>[mysql]<br>#no-auto-rehash # faster start of mysql but no tab completition<br><br>[isamchk]<br>key_buffer = 16M<br><br>#<br># * IMPORTANT: Additional settings that can override those from this file!<br>
# The files must end with '.cnf', otherwise they'll be ignored.<br>#<br>!includedir /etc/mysql/conf.d/<br><br>and i've changed something on my crm configuration:<br>node server1 \<br> attributes standby="off"<br>
node server2 \<br> attributes standby="off"<br>primitive WebSite lsb:apache2<br>primitive drbd_mysql ocf:linbit:drbd \<br> params drbd_resource="r0" \<br> op monitor interval="15s" \<br>
op start interval="0" timeout="240" \<br> op stop interval="0" timeout="100"<br>primitive fs_mysql ocf:heartbeat:Filesystem \<br> params device="/dev/drbd/by-res/r0" directory="/data" fstype="ext3"<br>
primitive mysqld ocf:heartbeat:mysql \<br> params binary="/usr/bin/mysqld_safe" config="/data/mysql/my.cnf" socket="/var/run/mysqld/mysqld.sock" pid="/var/run/mysqld/mysqld.pid" datadir="/data/mysql" \<br>
meta target-role="Started"<br>primitive vip ocf:heartbeat:IPaddr2 \<br> params ip="10.10.7.100" \<br> op monitor interval="5s"<br>group mysql vip fs_mysql WebSite mysqld<br>ms ms_drbd_mysql drbd_mysql \<br>
meta master-max="1" master-node-max="1" clone-max="2" clone-node-max="1" notify="true"<br>colocation mysql_on_drbd inf: mysql ms_drbd_mysql:Master<br>order mysql_after_drbd inf: ms_drbd_mysql:promote mysql:start<br>
property $id="cib-bootstrap-options" \<br> dc-version="1.0.9-unknown" \<br> cluster-infrastructure="openais" \<br> expected-quorum-votes="2" \<br> no-quorum-policy="ignore" \<br>
stonith-enabled="false"<br>rsc_defaults $id="rsc-options" \<br> resource-stickiness="100"<br><br>Thank you!<br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div>
> on each mode there is an installation of mysql-server but the same my.cnf<br>
> file<br>
<br>
</div>I don't have any experience with ubuntu server, but it sounds like you set it<br>
up right. Are you using the default my.cnf from the distro? Can you post it? I<br>
don't have any more suggestions. Hopefully someone else with more cluster<br>
experience can help.<br>
<div><div></div><div><br>
_______________________________________________<br>
Pacemaker mailing list: <a href="mailto:Pacemaker@oss.clusterlabs.org" target="_blank">Pacemaker@oss.clusterlabs.org</a><br>
<a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
<br>
Project Home: <a href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a><br>
Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a><br>
Bugs: <a href="http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker" target="_blank">http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker</a><br>
</div></div></blockquote></div><br>