June 19, 2013

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

June 18, 2013 By Leave a Comment

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

Filed Under: Events and Announcements, Percona XtraDB Cluster Tagged With: , , , , , ,

Comment: Call for papers: Percona Live London

June 18, 2013 By Leave a Comment

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

Filed Under: MySQL, Percona Live Tagged With:

Comment: Percona Server 5.6.11-60.3 first Release Candidate now available

June 18, 2013 By 3 Comments

does/will Percona 5.6 include handlersocket? I assume it’s including the memcache nosql interface in mysql 5.6, correct?

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

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

June 17, 2013 By Leave a Comment

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

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

Comment: Converting Character Sets

June 12, 2013 By 22 Comments

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

Filed Under: Insight for Developers 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

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

Filed Under: MySQL, Percona Live 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: Data mart or data warehouse?

June 17, 2013 By 14 Comments

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.

Filed Under: Insight for Developers, MySQL

Comment: Sphinx search performance optimization: attribute-based filters

June 13, 2013 By 11 Comments

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

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