… step up and volunteer to present your unique insights into MySQL and MySQL-related technologies either as a keynote, tutorial or breakout… using MySQL, Percona Server, MariaDB, Drizzle or (fill in the blank) in production? Are you managing multiple environments? Are you working with MySQL…
Post: MySQL Webinar: Percona XtraDB Cluster Operations, June 26
June 18, 2013 By Leave a Comment
Percona XtraDB Cluster (PXC) was released over a year ago and since then there has been tremendous interest and adoption. There’s plenty of talks that explain the fundamentals of PXC, but we’re starting to reach a threshold where it’s easier to find folks with PXC in production and such the need …
Comment: Percona Server 5.6.11-60.3 first Release Candidate now available
June 18, 2013 By 3 Comments
does/will Percona 5.6 include handlersocket? I assume it’s including the memcache nosql interface in mysql 5.6, correct?
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 17, 2013 By 3 Comments
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: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…allow you to stripe a TCP connection over multiple ports, and with a two-NIC bonded …in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under…server up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying …
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you…compare the use of subqueries/multiple joins vs. multiple queries (e.g. temp … every solution for randomly choosing rows involves some compromise, either of… the sequence after making certain insert/update/delete operations. If …
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… Percona 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-connector-java.jar Example Schema… tabs: Tables – Names, number of children, parents, count of columns, row counts, and comments — a great way for a high level…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
…, 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: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
….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…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… 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…
