June 18, 2013

Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

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

Post: Percona MySQL University @Portland next Monday!

…, Percona Xtrabackup and Performance and Improvements and new Features in MySQL 5.6 Garrick Peterson, a member of Percona’s RemoteDBA… replication integrity And finally, Andrew Ferlitsch will share with how MySQL can be used to provide access to government data. The…… :)   So register now! Please also join the Portland MySQL Meetup group for more MySQL-focused events in Portland If you love the…

Post: Call for papers: Percona Live London

… step up and volunteer to present your unique insights into MySQL and MySQL-related technologies either as a keynote, tutorial or breakout… sponsors. This is the showcase event for Europe’s growing MySQL community of developers, business managers, technology evangelists, DBAs and entrepreneurs…

Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)

MySQL can be deployed in several ways, and that means you …

Comment: Performance Schema overhead

Great test and report Vadim! I think the performance schema will be a great addition to MySQL once it’s more established. Just starting with MySQL after retiring from handling oracle databases – now volunteering :) Thanks for sharing.

Comment: Converting Character Sets

… correct. There was no truncation: MEDIUMTEXT is bigger than TEXT. MySQL does this to make sure there’s *no* truncation, as explained in the manual – http://dev.mysql.com/doc/refman/5.1/en/alter-table.html “For…

Post: Implementing SchemaSpy in your MySQL environment

… lot more effectively when I know the relationships between tables versus observing queries only.  An additional benefit is that SchemaSpy is… Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath…

Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

….7 on June 10, 2013. A drop in replacement for MySQL, downloads are available  here and from the Percona Software Repositories… #1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on…. Bug fixed #1185040. Fixed the upstream bug #69379 which caused MySQL clients to return bogus error number for host-not-found…

Post: Migrating between MySQL schemas with Percona Xtrabackup

… create orig_old Load the schema into the target database:  mysql orig_old < /tmp/orig.schema.sql Ensure innodb_import_table..._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…

Post: Private, custom Percona MySQL Training

…”] Alexei Rodriguez presenting at PLMCE13[/caption] During the Percona Live MySQL Community Event this year we had the pleasure of Alexei Rodriguez discussing why Evernote uses Percona’s Private Custom MySQL Training. Alexei is VP of operations there and you can…