June 18, 2013

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

…, naturally duration of SST is paramount. We recommend Xtrabackup SST for its reduced locking period from its use (which means the… compression, parallel streaming, encryption, compact backups which can be used for SST (Note, the wsrep_sst_xtrabackup in 5.5.30… HaProxy”) for details. In their setup they have automated this with a HAProxy in each AZ (Availability Zone) for the API server. To…

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: Call for papers: Percona Live London

… using MySQL, Percona Server, MariaDB, Drizzle or (fill in the blank) in production? Are you managing multiple environments? Are you working with MySQL… content for MySQL newcomers as well as the veterans. We’re also looking for sponsors. This is the showcase event for Europe’s growing MySQL

Post: Percona MySQL University @Portland next Monday!

… member of Percona’s RemoteDBA team, will talk about MHA for MySQL High Availability in the Cloud Matt Yonkovit, our VP of… possibilities and free drinks for event attendees. If you’re in the Portland area and work with MySQL, then this is an… join the Portland MySQL Meetup group for more MySQL-focused events in Portland If you love the ideal of Percona MySQL University and would…

Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)

MySQL can be deployed in several ways, and that means you … services or development systems, many people are using a single server with some backups configured, and then simply take the downtime…

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: Converting Character Sets

… correct. There was no truncation: MEDIUMTEXT is bigger than TEXT. MySQL does this to make sure there’s *no* truncation, as… in the manual – http://dev.mysql.com/doc/refman/5.1/en/alter-table.html “For a column that has a data…

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: Sphinx search performance optimization: attribute-based filters

…, as stated in the article, this technique only works well for highly selective attributes. If attributes only have few distinct values… to use this. Please see “Highly selective columns only” section for examples where it doesn’t work well…

Comment: Sphinx search performance optimization: attribute-based filters

… about 1200 tables each with hundreds of thousands of records, for we use sphinx based on attributes, but memory consumption is…