June 19, 2013

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

… interest and adoption.  There’s plenty of talks that explain the fundamentals of PXC, but we’re starting to reach a… wanted to shift gears from the standard introductory talk and focus instead more on some key questions/issues/pain-points for those… 2013 from 10-11AM PDT.  Topics will include: Backups from the cluster Avoiding SST Flow Control What and How to Monitor…

Comment: Call for papers: Percona Live London

… us of their upcoming live performances. If you’re in the mood to enjoy a live performance while eating, drinking or simply watching the show, this is the place to begin your search. At TicTune you…

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!

…), and also to solicit use cases from the readers. One of the prominent usages in the production environment that we have come across… bootstrapping with an empty gcomm:// is done for the first node by the chef. The second node is then added which SSTs with… referenced in that post, you can refer a post by Peter Boros (“Percona XtraDB Cluster reference architecture with HaProxy”) for details…

Comment: On Benchmarks on SSD

great write up, heres a video I did on my SSD: http://www.youtube.com/watch?v=gZJ-pPeE5lA

Post: Call for papers: Percona Live London

… actively using MySQL, Percona Server, MariaDB, Drizzle or (fill in the blank) in production? Are you managing multiple environments? Are you… and entrepreneurs. Download the prospectus and take a closer look at the benefits of sponsorship. Questions? Let me know in the comments section. I…

Comment: Converting Character Sets

… sure there’s *no* truncation, as explained in the manual – http://dev.mysql.com/doc/refman/5.1/en/alter-table.html…, CONVERT TO CHARACTER SET will change the data type as necessary to ensure that the new column is long enough to store as many characters as the original column.” [followed by a complete explanation of why TEXT…

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.