… using MySQL, Percona Server, MariaDB, Drizzle or (fill in the blank) in production? Are you managing multiple environments? Are you working with MySQL or its variants at the code level? Share your perspective about the internals or explain… stories are gold! And you owe it to the MySQL community to share them. Don’t worry about being fancy. Some of…
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… mysql schema to be missing after the clean RPM installation. Bug fixed #1174426. Fixed the Percona-Server-shared-55 and Percona-XtraDB-Cluster-shared RPM package dependences. Bug fixed #1050654. Fixed the upstream bug #68999 which caused compiling Percona Server…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…”] Percona Server for MySQL version 5.1.69-14.7[/caption] Percona is glad to announce the release of Percona Server 5.1… the RPM Percona-Server-shared-compat package naming issue that could lead to unresolved package dependencies when installing Percona Server 5.1. Bug… fixed #1132412, bug fixed #1153651. Release notes for Percona Server for MySQL 5.1.69-17.4 are available in our online…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…: Oracle RAC is a “shared everything” system; there really isn’t anything quite like that in the MySQL world, except maybe MyISAM…/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: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… involving the McAfee MySQL Audit Plugin and would like to share my experience in this post. Auditing user activity in MySQL has traditionally… gives us more flexibility by allowing users to extend the server‘s functionality with their own code, and this is what… has been an important missing feature on the server, which has made using MySQL in PCI or SOX compliant environments, to name…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… your database — I’m using the MySQL Connector/J Install the graphiz package Creating a mysql.properties file While not explicitly required… Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath=/usr/share/java/mysql… can then be accessed by a web server. Also note that since I created the mysql.properties file in the same directory…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… over 1,800 MySQL Servers. MySQL Enterprise provides Monthly Rapid Updates [MRU] while Community MySQL versions updated every quarter or so. MySQL 5.0.51a… Percona Live MySQL Conference and Expo in Santa Clara, Calif., April 22-25. Share a memory you have from past MySQL user conferences…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…MySQL Server 5.5.30, 5.6.11 and Percona Server 5.5.30 and check how these servers… Samples Command Shared Object # …….. ………. ……. ………………. …………………………………………………………………………………………………………………. #…
Post: Percona Server 5.5.30 with TokuDB for MySQL
April 24, 2013 By 26 Comments
…=”alignleft” width=”198″] Percona Server with TokuDB[/caption] I was excited to see that TokuDB for MySQL from Tokutek is now open… with a proprietary license. So I went and built Percona Server 5.5.30 with TokuDB’s storage engine. This is… confusing and this stage, so I want to share it with the entire MySQL community in case you want to try it…
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
… Toolkit for MySQL called pt-query-digest. One customer was suffering from periods of high load on their database server, leading to… to review them in servers with thousands of connections. Enter pt-query-digest. The tool supports its share of format parsers, but… issues. If you regularly work with MySQL databases, getting familiar with Percona Toolkit for MySQL will let you do more work, in…
