…are one of the new features regarding replication in MySQL 5.6. They open up a lot of…replication configuration with one master and two slaves, all running MySQL 5.6 with GTIDs disabled. First try: configure…of any use case, so in practice, you’ll probably use either file-based replication only (gtid_…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
…MySQL Audit Plugin and would like to share my experience in this post. Auditing user activity in MySQL… the McAffee plugin does. Installation and configuration are straightforward following the available instructions…. one commented line for switching between file and socket for output): plugin-load…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…: #For s2 (the new master), we remove its configuration as a slave s1> stop slave; s1> reset…# For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then… crashed, the server UUID can be read in the auto.cnf file in the datadir). So the last executed…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…the configuration file is OK: [root@percona1 ~]# ccs_config_validate -f /etc/cluster/cluster.conf Configuration validates We can now copy the configuration file … Master/Slave Set: ms_MySQL [p_mysql] Masters: [ percona1 ] Slaves: [ percona2 percona3 ] So if you were in maintenance mode, you should …
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…replication filters on the slave, as described in the MySQL manual. You can configure the slave to only replicate a …usr/libexec/mysqld: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, …
Post: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
… that I’ll be at the Percona Live MySQL Conference and Expo next week in Santa Clara, California so look for me…, we disable the MySQL slow logs temporarily during log rotation. Putting it all together Here is a logrotate configuration file for a slow log that illustrates these best practices: /var/mysql/slow_query.log { nocompress create 660 mysql mysql size 1G…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. This release of Percona XtraDB Cluster… fixed #1104977 (Raghavendra D Prabhu). Clustercheck script would hang in case the MySQL server on a node is hung. As a consequence… would fail if the tmpdir was specified more than once in the MySQL configuration file (my.cnf). Bugs fixed #1160047 and #1086978 (Raghavendra D…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… perfect case for read-only transaction optimization in MySQL 5.6, because all SELECT queries in the AUTOCOMMIT mode are, by definition, read…scope of descriptors optimization. Server Configuration: [mysqld] user=root port=3306 innodb_status_file=0 innodb_data_file_path=ibdata1:100M:autoextend innodb…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…) mysql> show slave status\G Empty set (0.00 sec) mysql> start slave; ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER… to remove all replication-related configuration: mysql> stop slave; Query OK, 0 rows affected (0,00 sec) mysql> reset slave all; Query OK…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6… by log copying thread is now configurable by innobackupex –log-copy-interval. Making the interval configurable allows to reduce the time between…
