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 …
Post: Call for papers: Percona Live London
June 14, 2013 By Leave a Comment
… unique insights into MySQL and MySQL-related technologies either as a keynote, tutorial or breakout session. Tell us your war story: What have you experienced while actively using MySQL, Percona Server, MariaDB, Drizzle or (fill…
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
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?
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
… architectural setup around PXC – any challenges you faced (and horror stories if any), any special deployment methodologies you employed (Puppet, Chef…
Comment: Performance Schema overhead
June 12, 2013 By 22 Comments
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
June 12, 2013 By 22 Comments
… 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: 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…_dir variable didn’t have the path separator at the end. Bug fixed #1181887. A warning is now returned if a…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… same server. It caught me off guard because I’d never really thought about it – typically, I’ve used Xtrabackup simply…_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: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… just a moderate load on the host system, DRBD can end up in a split-brain situation. Typically DRBD is run… in a MySQL Cluster installation are going to be talking to the same set of data nodes on the back end, but… latency wreaking havoc with MySQL‘s internal understanding of what’s happening on the system below. Having never experimented with GlusterFS, though…
