Why does the mysql client says it’s 5.1.70? Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 138 Server version: 5.1.70-rel14.7-log Percona Server (GPL), 14.7, Revision 572
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 17, 2013 By 3 Comments
Comment: Converting Character Sets
June 12, 2013 By 22 Comments
Approach number 1 is correct. There was no truncation: MEDIUMTEXT is bigger than TEXT. MySQL does this to make sure there’s…* truncation, as explained in the manual – http://dev.mysql.com/doc/refman/5.1/en/alter-table.html “For a column that…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…: ms_MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona2 (unmanaged) p_mysql:1 (ocf::percona:mysql): Started percona3 (unmanaged) Stopped: [ p_mysql:2 ] Now…: 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:2 (ocf::percona:mysql…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.1.69-14.7[/caption] Percona is glad to announce… drop in replacement for MySQL, downloads are available here and from the Percona Software Repositories. Based on MySQL 5.1.69, this release…, bug fixed #1153651. Release notes for Percona Server for MySQL 5.1.69-17.4 are available in our online documentation. Bugs…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
… glad to announce the release of Percona XtraBackup 2.1.3 for MySQL on May 22, 2013. Downloads are available from our… to faster restore time XtraBackup makes MySQL hot backups for all versions of Percona Server, MySQL, MariaDB, and Drizzle. It performs streaming, compressed, and incremental MySQL backups. Percona’s enterprise-grade commercial MySQL Support contracts include support for XtraBackup. We…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… share my experience in this post. Auditing user activity in MySQL has traditionally been challenging. Most data can be obtained from… test (5.5.28-29.1). This is needed as the plugin needs the offset to some MySQL data structures that, the…_json_file=1 audit_json_socket_name=/tmp/audit.sock #audit_json_socket=1 audit_json_log_file=/var/lib/mysql/audit.log…
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… sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath=/usr/share/java/mysql-connector-java.jar…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… server can easily handle the write load of all the MySQL instances. The original idea was to configure them with raid… raid controller write cache use. Even the fairly slow gzip-1 mode works well. The tpcc database, which contains a lot… together, ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact on performance…
Post: Summertime Percona MySQL training update
June 6, 2013 By 1 Comment
… – 5pm In July we have: Moving to MySQL 5.6 – Utrecht, Netherlands Begins Monday, July 1, 2013 , 9am – 5pm London, United Kingdom Begins Monday, July 15, 2013 , 9am – 5pm BST Moving to MySQL 5.6… Moving to MySQL 5.6 – Belfast, IE Begins Thursday, August 1, 2013 , 9am – 5pm In August we have: Moving to MySQL 5.6…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… into the target database: mysql orig_old < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare the…_old Make sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run: ALTER TABLE…_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF mysql -N -B <<'EOF' > import-ddl.sql SELECT CONCAT(‘ALTER TABLE…
