June 18, 2013

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

… it’s easier to find folks with PXC in production and such the need for more advanced talks has arisen. As…, I wanted to shift gears from the standard introductory talk and focus instead more on some key questions/issues/pain-points… include: Backups from the cluster Avoiding SST Flow Control What and How to Monitor Tuning best practices This webinar is not…

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 MySQL University @Portland next Monday!

… the MySQL Community: Vadim Tkachenko, Percona co-Founder and CTO, will talk about Percona XtraDB Cluster, Percona Xtrabackup and Performance and Improvements and new Features in MySQL 5.6 Garrick Peterson, a member of Percona’s RemoteDBA team, will talk about MHA for MySQL

Post: Call for papers: Percona Live London

… without great content. So step up and volunteer to present your unique insights into MySQL and MySQL-related technologies either as a keynote, tutorial… for Europe’s growing MySQL community of developers, business managers, technology evangelists, DBAs and entrepreneurs. Download the prospectus and take a closer look…

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: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!

… (state snapshot transfer). Node3 subsequently joins the cluster with node1 and node2 in its gcomm:// (since by this time node1, node2… about your architectural setup around PXC – any challenges you faced (and horror stories if any), any special deployment methodologies you employed…

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: Sample datasets for benchmarking and testing

the links here are useful and informative…

Comment: How to calculate a good InnoDB log file size

According to this link, https://mariadb.atlassian.net/browse/MDEV-4662 Jesper is correct and I am wrong: when InnoDB warns about not enough space in the logs, it’s overwritten its last checkpoint. Thanks to Jeremy Cole for finding out the truth.

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…