… on MySQL 5.6 GTIDs. You can find part one here. Our goal will be to go from setup #1 to … the auto.cnf file in the datadir). So the last executed event is 219be3a9-c3ae-11e2-b985-0800272864ba:1. How …There is a solution of course, but very poor in my opinion: look for the binlog file/position of the …
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage engine. In my…2 Flight #2 is similar to Flight #1. MyISAM is faster than InnoDB … my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… two-NIC bonded pair you’ll get roughly 1.67x the throughput of a single port. [Don… use the slave_compressed_protocol option in /etc/my.cnf if bandwidth is a concern. If you’re …Q: What is my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5.6, based …
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
…, this isn’t really much different from standard mysql replication. 1 master with 5 async slaves is going to send a separate replication….192.0.11, so we’ll add this to our my.cnf: wsrep_provider_options = “gmcast.mcast_addr=239.192.0.11… mysql]# service mysql stop [root@node1 mysql]# service mysql stop [root@node1 mysql]# service mysql start –wsrep_cluster_address=gcomm:// [root@node2 mysql]# service mysql start [root@node3 mysql…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… master-password settings in my.cnf, this may cause huge problems (it’s anyway no longer supported from MySQL 5.5). If you want to know more details, please read on! MySQL 5.0/5.1 First let’s consider MySQL 5.0 and 5.1. RESET… you want. So never set master-xxx variables in my.cnf! From MySQL 5.5 Starting with MySQL 5.5, the situation has slightly changed. First the master…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…MySQL version 5.5.30-30.2[/caption] Percona is glad to announce the release of Percona Server for MySQL 5.5…Bychko). UDF/configure.ac was incompatible with automake 1.12. Bug fixed #1099387 (Alexey Bychko). …set in the [client] section of the my.cnf. Bug fixed #1155859 (Sergei Glushchenko). Fixed the …
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… Bychko). UDF/configure.ac was incompatible with automake 1.12. Bug fixed #1099387 (Alexey Bychko). Reduced… set in the [client] section of the my.cnf. Bug fixed #1155859 (Sergei Glushchenko). Fixed the …(Hrvoje Matijakovic). Release notes for Percona Server for MySQL 5.5.30-30.2 are available in our …
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
… some memory allocation setting in my.cnf file. On first day after doing memory allocation setting in my.cnf file, site performance was good. But from second day again performance degradation started and now it is slow again. MySQL….15 (CentOS) PHP Version – 5.3.3 MySQL – 5.1.66 [Percona XtraDB Cluster (GPL) (5.5.30)] (InnoDB Engine) PHP My Admin – 5.3.3 Hardware: Node…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… you find in standard async MySQL replication. It is my belief that the lack of …. This setting traditionally defaulted to 0.5, meaning the queue had to fall below…paused – the fraction of time (out of 1.0) since the last SHOW GLOBAL …Ops Bytes Flow Conflct time name P cnf # name cmt sta Up Dn Up …
Comment: Percona Toolkit 2.2.2 released; bug fixes include pt-heartbeat & pt-archiver
May 15, 2013 By 2 Comments
… using 2.2.2 and mysql Ver 14.14 Distrib 5.5.30, for Linux (x86_64) using readline 5.1 i am getting this since the upgrade of percona this week: pt-heartbeat -F/etc/my.cnf -Dpt_heartbeat…
