… have been working with a set of customers on a longer term basis which has given me time to explore new tools using… after each run, so I find it convenient to set it up on crontab so that schema changes are automatically picked up… Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… time, we will enable GTID replication on slave #1, but not on slave #2: # slave #1 mysql> change master to master_auto_position = 1; mysql> start slave; and let’s create a new table on the master: mysql> create… can have different replication modes on different servers, but only if all servers have gtid_mode set to ON. Could it be interesting…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… log. – audit_whitelist_users : This one is undocumented on the wiki at the time of writing, and is a list of users… possibilities of extending MySQL‘s behavior in a way that, once set up, is transparent to users, and the McAfee MySQL Audit Plugin… support has been an important missing feature on the server, which has made using MySQL in PCI or SOX compliant environments, to…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
On Friday I gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, …a temporary table to store an interim result set, and then use that to ultimately produce … result was a query that took half the time. An important conclusion of my presentation today …
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… do it. One way is to set up replication filters on the slave, as described in the MySQL manual. You can configure the… SQL nodes in a MySQL Cluster installation are going to be talking to the same set of data nodes on the back end…, and went to try to install MySQL. It failed miserably on the mysql_install_db process. Every time I tried, I got some variant…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… default settings using only the InnoDB storage engine. In my testing I discovered that innodb_old_blocks_time had an effect on performance…. All OS caches are dropped at this time as well. These set of queries were tested on the SSB at SCALE FACTOR: 20… [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…on [root@percona2 ~]# chkconfig cman on [root@percona3 ~]# chkconfig cman on And start the services on….4, it’s time to stop the …Set: ms_MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… did not have time to analyze it in-depth. If you try to do something like this in MySQL 5.5, you…’ defined on the table ‘test.test’. This is deprecated and will be disallowed in a future release. 1 row in set (0… by Percona Toolkit. The MySQL server, of course, cannot risk to block directly all cases. A set of MySQL utilities were introduced by…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… about MySQL buffer pools or anything else that’s on your mind! There are numerous solutions for MySQL high availability. Many rely on MySQL’s… for information about discarded designs and benchmarks.) First, we set long_query_time to 0 in order to log every query. (See… –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin –dispatcher-plugin thread-pool –thread-pool-threads-count 100 –session-init-query \”set…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…be loaded by the server either automatically on startup or on demand. Time interval between checks done by … can be imported by ALTER TABLE IMPORT TABLESPACE on MySQL and Percona Server 5.6 as described … on log copying failure. Bug fixed #1170806. innobackupex would fail if the SQL_MODE was set …
