June 19, 2013

Post: MySQL Webinar: Percona XtraDB Cluster Operations, June 26

… the standard introductory talk and focus instead more on some key questions/issues/pain-points for those with PXC in production… is not meant to necessarily be exhaustive, but to cover key topics that administrators of PXC will commonly ask about.  You…

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…

Comment: Percona Server 5.6.11-60.3 first Release Candidate now available

does/will Percona 5.6 include handlersocket? I assume it’s including the memcache nosql interface in mysql 5.6, correct?

Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!

… PXC for HP Cloud DNS. The post focuses on the key aspects of synchronous replication setup with high-availability guarantees like…

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

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.

Post: Implementing SchemaSpy in your MySQL environment

….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… AUTO_INCREMENT, `parent_id` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `parent_id` (`parent_id`), CONSTRAINT `child_B_ibfk_1…

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: 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…