…”] Percona Server for MySQL version 5.1.69-14.7[/caption] Percona is glad to announce the release of Percona Server 5.1… integers now. Bug fixed #714925. mysql_set_permission was failing on Debian due to missing libdbd-mysql-perl package. Fixed by adding the… fixed #1132412, bug fixed #1153651. Release notes for Percona Server for MySQL 5.1.69-17.4 are available in our online…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…”] Percona Server for MySQL version 5.5.31-30.3[/caption] Percona is glad to announce the release of Percona Server for MySQL 5… MDEV-3915). Bug fixed #1172090. mysql_set_permission was failing on Debian due to missing libdbd-mysql-perl package. Fixed by adding the… the MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes for Percona Server for MySQL…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… html after each run, so I find it convenient to set it up on crontab so that schema changes are automatically… in use for my Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1… can then be accessed by a web server. Also note that since I created the mysql.properties file in the same directory…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… Server for MySQL version 5.6.11-60.3[/caption] Percona is glad to announce the first Release Candidate release of Percona Server…_PAGES query started returning data to indicate an incomplete result set. Bug fixed #1185040. The INNODB_CHANGED_PAGES table couldn’t… fixed #1177780, bug fixed #1154954. Release notes for Percona Server for MySQL 5.6.11-60.3 are available in our online…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
…. The flexibility comes from the three variables that can be set to control what is logged by the plugin: – audit_record… possibilities of extending MySQL‘s behavior in a way that, once set up, is transparent to users, and the McAfee MySQL Audit Plugin… has been an important missing feature on the server, which has made using MySQL in PCI or SOX compliant environments, to name…
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 …services or development systems, many people are using a single server with some backups configured, and then simply take the …caveats, but you can also gain a lot from write set replication. If the application gets really popular, sooner or …
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… snapshot of a particular MySQL schema and then reload it with a different schema name on the same server. It caught me…, given the import/export functionality of Xtrabackup combined with Percona Server (Exporting and Importing Tables), it did seem possible. Further discussion…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…also configure the slave to replicate everything EXCEPT a specified set of databases and tables. With this method, every event is…/mysqld: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I saw…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…, following various scenarios: For these tests, all servers are running on 127.0.0.1 …For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And … executed: s1> show slave status\G [...] Executed_Gtid_Set: 219be3a9-c3ae-11e2-b985-0800272864ba:1, 3d3871d1-…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… two slaves, all running MySQL 5.6 with GTIDs disabled. First try: configure only one of the servers with GTIDs Let’s stop slave #2, change configuration and restart it: mysql> show slave status\G [...] Slave… can have different replication modes on different servers, but only if all servers have gtid_mode set to ON. Could it be interesting…
