…=”/var/run/mysql/mysql.sock” else OCF_RESKEY_binary_default=”/usr/local/mysql/bin/mysqld_safe” OCF_RESKEY_config_default=”/usr/local/mysql/etc/my….168.163.207″ primitive p_mysql ocf:heartbeat:mysql \ params config=”/usr/local/mysql/etc/my.cnf” pid=”/usr/local/mysql/mysqld.pid” socket=”/tmp… interval=”5s” role=”Master” OCF_CHECK_LEVEL=”1″ \ op monitor interval=”2s” role=”Slave” OCF_CHECK_LEVEL=”1″ primitive reader_vip_1…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 27, 2012 By 102 Comments
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
December 13, 2011 By 38 Comments
…cloning without having to worry about losing config changes, plus it makes reading configs much easier as you can …available across OS releases. I thought I’d double check on my RHN account to see what RH …packages they list are for MySQL 3.23!! The RHEL 6 marketing blurb mentions MySQL 5.1.47, but …
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
February 8, 2012 By 102 Comments
… empty. Any further ideas? Cheers, Andreas PS: Find my whole config below: node ubuntu-cluster03 \n attributes IP=”10.20.0… attributes IP=”10.20.0.22″ primitive p_mysql ocf:heartbeat:mysql \n params config=”/etc/mysql/my.cnf” pid=”/var/run/mysqld/mysqld…_passwd=”r00tp877″ \n op monitor interval=”20s” role=”Master” OCF_CHECK_LEVEL=”1″ \n op monitor interval=”30s” role=”Slave” OCF…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 30, 2011 By 102 Comments
… to it today. Shlomi, as to your comment about the config looking intimidating: I concur, but fear not: it can be… attributes IP=”10.2.2.162″ primitive p_mysql ocf:heartbeat:mysql \n params config=”/etc/mysql/my.cnf” pid=”/var/run/mysqld/mysqld…_passwd=”rootpass” \n op monitor interval=”5s” role=”Master” OCF_CHECK_LEVEL=”1″ \n op monitor interval=”2s” role=”Slave” OCF…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
…_limit PHP config variable because that only controls memory which passes via PHP memory management which does not apply to MySQL result… error checking If you use buffered query the only real call you can get errors is when you run mysql_query , mysql_fetch_row simply reads data from memory and so most applications do not care to check if there…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 30, 2011 By 102 Comments
…. 
node testvirtbox1 node testvirtbox2 node testvirtbox3 primitive p_mysql ocf:heartbeat:mysql \ params config=”/etc/mysql/my.cnf” pid=”/var/run/mysqld/mysqld.pid…” role=”Master” OCF_CHECK_LEVEL=”1″ \ op monitor interval=”30s” role=”Slave” OCF_CHECK_LEVEL=”1″ ms ms_MySQL p_mysql \ meta clone-max…
Comment: Percona XtraDB Cluster reference architecture with HaProxy
August 8, 2012 By 63 Comments
… apply the same concept of using the script clustercheck to check the mysql health with keepalived and vip. Basically by assuming 1… the 2 is slave each keepalived instance on both nodes checks the health of node 1. When health is not ok… 2. Node 3 is always garbd. Is it a reliable config this kind of vip management ? Thx.
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
…of insertions queries on these same tables. I checked “iostat -dx 10″ and the %util is not…_flush_log_at_trx_commit=2″ into the config file. The “innodb_buffer_pool_size” is set…cnf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql max_connections=600 connect_timeout=30…
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
December 9, 2011 By 38 Comments
… install -dy [packages...] ) before lauching the real installs. Regarding specific mysql packages now: you’re right to mention that the debian init script for mysql can do some bad things automatically (system table upgrades, table checks, …). And I agree with you… /etc/mysql/debian-start (add exit 0 at startup for example), to disable these “features”. And this is a config file, so…
Post: Percona Playback 0.3 development release
July 10, 2012 By 15 Comments
…captured either in a MySQL slow query log or a tcpdump capture of the MySQL protocol exchange … gcc 4.6) libmysqlclient-dev libdrizzle-dev pkg-config Source Tarball: percona-playback-0.3.tar….configure && make && make install Run the test suite: make check We are planning binary packages for the next …
