… be located on the master During a master switch, connections are killed on the demoted master to avoid …10.2.2.162″ primitive p_mysql ocf:heartbeat:mysql \ params config=”/etc/mysql/my.cnf” pid=”/var/run/mysqld/…that will be used for replication. This is a real IP address not a reader or writer VIP. …
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
Post: The Math of Automated Failover
September 18, 2012 By 9 Comments
… packets on firewall which gives you instant connection failure, while in real life you could see connection to take significant time before timing… the art high availability solutions for MySQL such as Clustrix, Tungsten Replicator, PRM, Percona XtraDB Cluster, MySQL and DRBD as well as…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…name | Value | +———————————–+———————-+ | Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use |… in the real world and …
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… redirect requests to PXC nodes. This approach works well in real-world scenarios too. Running HaProxy on the application servers instead… [Note] /usr/sbin/mysqld: ready for connections. Version: ’5.5.24-log’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Percona XtraDB Cluster… HaProxy instance, each application server connects to 127.0.0.1, so MySQL will see that connections are coming from the application servers…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…because their skills in SQL are limited. The real life customers generate very uneven load – some … outputs: mysql> SHOW USER_STATISTICS LIKE ‘hosting2′\G *************************** 1. row *************************** User: hosting2 Total_connections: 84 Concurrent_connections: 0 Connected_time:…
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
… sometimes which is obviously the problem – they take Apache Slot, MySQL Connection and other resources. I had discussion today who was thinking… do some cleanup work – for example you can open another MySQL connection to kill the query which was running (otherwise query may… with sleep() function is wrong and if I would use real MySQL queries this would be counted to max_execution_time and…
Post: Handling big result sets
June 26, 2006 By 13 Comments
… rows from the table: < ?php $link = mysql_connect(‘localhost’, ‘root’, ”) or die(‘Could not connect: ‘ . mysql_error()); mysql_select_db(‘test’) or die(‘Could not…_STORE_RESULT. (Also there can be used pair mysql_real_query / mysql_use_result or mysql_store_result, which are the same). mysqli_query…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… having few connections which use appropriate operations heavily you can reduce system performance beyond being functional. General Overload As MySQL does not… slower than in normal case. Some of these comes from real experiences others are just my guesses of what could break… connection. P.S You would say how this all could be true if there are thousands of virtual hosting companies offering MySQL…
Post: MySQL net_write_timeout vs wait_timeout and protocol notes
July 8, 2007 By 1 Comment
… that. MySQL uses a lot of different timeout variables at different stages. For example when connection is just being established connect_timeout is… I know of. You can’t use something like mysql_ping because connection is in the stage of getting the data. You… data because there is buffering happening inside MySQL client library so you never know when real network read will happen. As net…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
… a large wait_timeout for the MySQL connection, innobackupex will regularly poll the server, keeping the connection alive while the backup is taking… instead of the real password. Bug fixed#729843 (Alexey Kopytov and Valentine Gostev) innobackupex did not check that MySQL datadir was empty…
