June 20, 2013

Comment: Visualization tools for pt-query-digest tables

… setting // use host=hostname:port if not the default port ‘dsn’ => ‘mysql:host=hostname;dbname=percona’, … $explainhosts = array( ‘label1′ => array( ‘dsn’ => ‘mysql:host=hostname1:3306… Fatal error: Can’t connect to the database server. (test@:/) SQLSTATE[HY000] [2005] Unknown MySQL server host ‘localhost:3306′ (0) [#2005] in /home/html/QDU…

Post: 10+ Ways to Crash or Overload MySQL

MySQL account and they have been normally treated very quickly by MySQL. The moment you give someone access to MySQL Server, all MySQLMySQL versions which typically have more issues. P.P.S Nothing I write here is security hole which is unknown to MySQL

Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances

mysql host would…unknown expected votes 1 Resources configured. ============ Online: [ monitor hamysql ] Install MySQL For the sake of simplicity, we will just install the MySQL version in the Ubuntu repository by doing: root@hamysql:~# apt-get install mysql-server-5.1 The package install MySQL

Comment: Rendundant Array of Inexpensive Servers

… (MySQL) failure rate is… unknown, really. The #1 cause of database downtime has been me (running destructive commands on the wrong host. Twice…. I have to say I’m completely blown away by MySQL‘s stability. Apart from the datafile corruption a couple of…, growing by about 120 GB/yr. These are commodity (Dell) servers – cheap and easy. Hell, with the starting price of EMC…