June 18, 2013

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

… reach a threshold where it’s easier to find folks with PXC in production and such the need for more advanced… more on some key questions/issues/pain-points for those with PXC in production already.   As such, I’m giving a…

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!

… work with BigData effectively Justin Swanhart, our Senior MySQL Instructor, will continue the topic of BigData with a talk titled, “Conquering BigData with MySQL and… work with MySQL, then this is an event you can’t afford to miss… :)   So register now! Please also join the Portland MySQL

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… using MySQL, Percona Server, MariaDB, Drizzle or (fill in the blank) in production? Are you managing multiple environments? Are you working with MySQL

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

… post focuses on the key aspects of synchronous replication setup with high-availability guarantees like split-brain immunity. Nobody likes to… aspects: Initial setup Setup of other nodes with SST (Xtrabackup SST) Integration of chef with PXC Finally, integration of HAProxy as a… recommended for use with PXC. The other one is glb. HAProxy is used with xinetd on the node along with a script which…

Comment: Sphinx search performance optimization: attribute-based filters

… have few distinct values (e.g status, gender, group_id with only 10 groups per 10M records), then you don’t…

Comment: Sphinx search performance optimization: attribute-based filters

… to our website where we have about 1200 tables each with hundreds of thousands of records, for we use sphinx based…

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…