June 19, 2013

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

… starting to reach a threshold where it’s easier to find folks with PXC in production and such the need for more… some key questions/issues/pain-points for those with PXC in production already.   As such, I’m giving a webinar entitled… will include: Backups from the cluster Avoiding SST Flow Control What and How to Monitor Tuning best practices This webinar is…

Comment: Call for papers: Percona Live London

… with us of their upcoming live performances. If you’re in the mood to enjoy a live performance while eating, drinking…, or by type or genre of shows you are interested in.

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!

… initial setup goes into bootstrapping the first node. Note that in the cloud environment other nodes are not known until they… (Note, the wsrep_sst_xtrabackup in 5.5.30 can’t do those except parallel, the one in 5.5.31 will handle them all, also… clustercheck with a single serving process (we are adding one in 5.5.31), looking for optimizations with HAProxy to account for high…

Comment: Converting Character Sets

… to make sure there’s *no* truncation, as explained in the manual – http://dev.mysql.com/doc/refman/5.1/en/alter-table… change the data type as necessary to ensure that the new column is long enough to store as many characters as…

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

… your war story: What have you experienced while actively using MySQL, Percona Server, MariaDB, Drizzle or (fill in the blank) in production? Are… looking for sponsors. This is the showcase event for Europe’s growing MySQL community of developers, business managers, technology evangelists, DBAs…

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: Data mart or data warehouse?

Great article. Did you do a part 3-6? I did not see them in your posts. I would appreciate an email if you did. Thanks.

Comment: Sphinx search performance optimization: attribute-based filters

Fabian, – please note that, as stated in the article, this technique only works well for highly selective …