…) the pacemaker mysql plugin (ocf:heartbeat:mysql) doesn’t work, because since mysql 5.5 the statement “CHANGE MASTER TO MASTER_HOST=” ” will make… in his the last version on gitub. But in my MySQL – installation a “SHOW SLAVE STATUS” will ALWAYS produce a completely…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 16, 2012 By 94 Comments
Post: Community events around Percona Live MySQL Conference and Expo 2012
March 26, 2012 By 1 Comment
… to organize traditional MySQL Community Dinner event during Tutorial Day of the conference (April 10th) SkySQL and MariaDB are hosting SkySQL Solutions… Day hosted by Sphinx Technologies (April 13) All these events are free to attend (registration needed) whenever you’re attending MySQL Conference…
Post: Percona Live MySQL Conference & Expo Was A Great Event
April 17, 2012 By 2 Comments
… Oracle for their new development milestone release for MySQL 5.6, released on Monday. MySQL 5.6 just keeps looking better and… also recorded some of the breakout sessions, so watch Planet MySQL for an announcement when she posts those online. Presentation slides… offer from Box, we are creating a custom site to host the speaker slides in a central repository so the knowledge…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… complete. Here is example how it can look: mysql> show processlist; +——-+——+———–+———-+———+——+————————-+—————————–+———–+—————+———–+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows…
Comment: Should MySQL and Web Server share the same box ?
April 23, 2012 By 9 Comments
Hello Peter, It sounds like splitting the servers for both MySQL and web, will require external help either experienced developer or assistance from hosting server to split the servers. Not something easy to do even for the good-known forum owner ?
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
… (${full}%, ${avail}MB free)”>&2 exit 1 fi host=$(mysql -ss -e ‘SELECT p.HOST FROM information_schema.innodb_lock_waits w INNER… p on b.trx_mysql_thread_id = p.ID LIMIT 1′) if [ "${host}" ]; then echo “Host ${host} is blocking” port=$(echo ${host} | cut -d: -f2… port 3306 and port ${port} > /root/tcpdumps/`date +%s`-tcpdump & mysql -e ‘show innodb status\Gshow full processlist’ > /root/tcpdumps/`date +%s…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
Amazon’s Relational Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on …
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
…-query-digest output was obviously bogus when compared to the host‘s slow-query-log (for example, none of the top… and resulted in about 0.2% packet loss on this host, which is acceptable — the variances are statistically smoothed out and… to forward the tcpdump output to another host for processing because the database host couldn’t handle the additional IO or CPU…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But …skip_external_lockingblogpercona.commanual skip_grant_tablesblogpercona.commanual skip_host_cacheblogpercona.commanual skip_lockingblogpercona.commanual skip_log_warningsblogpercona.commanual…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… an overview of these two approaches to hosting MySQL in the Amazon cloud. In general, MySQL performance overall on EC2 and EBS isn… were similar to the performance improvements I saw versus stock MySQL 5.1. This leads me to a second unverifiable speculation, that Amazon RDS’s version of MySQL is probably closer to stock MySQL than it is to Percona Server. I…
