… by the new log data. In some corner cases this could lead to assertion errors in the log parser or bad changed… #1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on… the upstream bug #69379 which caused MySQL clients to return bogus error number for host-not-found errors on Ubuntu 13.04. Bug…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/… sanity check of your schema for any significant errors or items requiring review. Columns – a listing of … via crontab once you’re done. What are some ERD tools you use and how do they …
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run: … compare and restore values (potentially corrupted via user error or other issues) with SQL rather than needing …Percona Server 5.5.30 Xtrabackup 2.0.6 Some other use cases that come to mind for …
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… configuration and restart it: mysql> show slave status\G [...] Slave_IO_Running: No Slave_SQL_Running: Yes [...] The error log tells us why… not on slave #2: # slave #1 mysql> change master to master_auto_position = 1; mysql> start slave; and let’s create a… enabled on all servers, you can have some slaves using file-based positioning and some other slaves using GTID-based positioning. This…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… on the mysql_install_db process. Every time I tried, I got some variant of this message: 130606 2:22:41 [ERROR] /usr/libexec/mysqld: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… to do something like this in MySQL 5.5, you will succeed without errors or warnings: mysql> ALTER TABLE test ADD INDEX (col2… there that use MySQL, for which we at Percona tend to find redundant indexes. And second, because in some cases, we may… keys in InnoDB. As some of this redundancies could be necessary, depending on the query optimizer and the MySQL version, we always…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…for a star schema. A star schema presents some unique challenge to the database optimizer. The …datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_…innodb_stats_auto_update=off [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…/Slave Set: ms_MySQL [p_mysql] Masters: [ percona2 ] Slaves: [ percona3 ] Stopped: [ p_mysql:2 ] After the update and after fixing some small issues like… 
May 23 08:34:12 percona1 corosync[1535]: [MAIN ] parse error in config: Can’t open logfile ‘/var/log/corosync.log… percona1 Master/Slave Set: ms_MySQL [p_mysql] Masters: [ percona1 ] Slaves: [ percona2 percona3 ] We can see that some resources changed this is because…
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
MySQL can be deployed in several ways, and that means you … has some caveats). Also, because of asynchronous replication, you can end up having inconsistent data on the nodes and encounter replication errors… in Budapest, Hungary. My presentation will provide an overview of some possible deployment and scaling scenarios, when it makes sense to…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
….1.3. My node is crashed and I have this error in my log : 07:53:55 UTC – mysqld got signal… misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will…:53:56 mysqld_safe mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in an another environment I…
