June 18, 2013

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

June 17, 2013 By Leave a Comment

…, 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…

Filed Under: MySQL, Percona XtraDB Cluster, XtraDB Cluster Tagged With: , , , , , , , ,

Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

June 17, 2013 By 3 Comments

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

Filed Under: MySQL, Percona Server, Percona Software Tagged With:

Post: Call for papers: Percona Live London

June 14, 2013 By Leave a Comment

… 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…

Filed Under: MySQL, Percona Live Tagged With:

Post: Percona MySQL University @Portland next Monday!

June 12, 2013 By Leave a Comment

… 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…

Filed Under: Events and Announcements, MySQL, Percona MySQL Consulting, Percona MySQL Support, Percona MySQL Training, Percona MySQL University, Percona Remote DBA Tagged With: ,

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

June 11, 2013 By Leave a Comment

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…

Filed Under: Events and Announcements, MySQL Tagged With: , ,

Comment: Performance Schema overhead

June 12, 2013 By 22 Comments

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.

Filed Under: Benchmarks, Hardware and Storage, Insight for DBAs, MySQL

Comment: Converting Character Sets

June 12, 2013 By 22 Comments

… 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…

Filed Under: Insight for Developers Tagged With: , ,

Comment: How to calculate a good InnoDB log file size

June 14, 2013 By 38 Comments

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.

Filed Under: Insight for DBAs Tagged With: ,

Comment: Sphinx search performance optimization: attribute-based filters

June 13, 2013 By 11 Comments

…, 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…

Filed Under: Insight for Developers, MySQL Tagged With: , ,

Comment: Sphinx search performance optimization: attribute-based filters

June 12, 2013 By 11 Comments

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

Filed Under: Insight for Developers, MySQL Tagged With: , ,
« Older Posts