June 19, 2013

Post: Announcement of Percona XtraDB Cluster 5.5.23

to announce next version Percona XtraDB Cluster 5.5.23, which comes with bug fixes and improvements. List of changes: Fixes merged from upstream (Codership-mysql….04, they are coming soon. If you want to know more how to migrate to XtraDB Cluster, we will be giving a free webinar…

Post: Migrating to XtraDB Cluster Webinar follow up questions

… monitoring plugins, and I misspoke: The Percona Monitoring Plugins have a check that enables you to set thresholds on an arbitrary expression… monitored MySQL server in question.  It should be easy to use this tool to monitor at least some of the monitoring recommendations from Codership…

Post: Data compression in InnoDB for text and blob fields

MySQL 5.5) you can now leverage table compression by specifying ROW_FORMAT=COMPRESSED.  In our case we only wanted MySQL to try toto 30GB.  Happy customer :) One parting idea: you may be able to leverage pt-online-schema-change from Percona Toolkit 2.1 in order to

Post: Facebook at Percona Live MySQL Conference and Expo and Advanced Registration Ending Soon

Migration (OLM)”. He will discuss migrating a logical database from on MySQL master A (and its slaves) to another MySQL master B (and its slaves) to

Post: devops webinar - follow up Q&A

… Does Percona provide plugin for cacti? A: Yes we do. They are part of Percona … for example), but when I need to validate changes for production (continuous integration),…from your configuration management when a file with those ALTERs is modified then deltas will be easier. Q: When doing a migration

Post: Onsite and Remote - getting best of both worlds

Percona we provide services both Onsite – visiting the customers and Remote – logging in tomigration projects, any forms of scripting, implementation (writing queries), hands on setting up MySQL

Comment: What Linux Distribution do you use to run MySQL ?

… ran out of options. We moved from RH to Cent in dev/staging, it was … various distributions and MySQL versions (5.1 and 5.5, commercial, GPL, and Percona). Cent 6…to trust my limited statistics and do the Cent -> Debian migration across the board…after almost completing the RH -> Cent migration

Post: Percona turns two today !

… working for MySQL and August 1st I started what later was incorporated Percona with … us to provide additional services such as capacity planning, migrations, web layer optimizations, MySQL Customizations/Optimizations…two years we’ve grown from 2 person company to company employing over 20 full …

Post: Why you don't want to shard.

…of 4 on building our training workshop. The Percona training workshop will not cover sharding. If …busy tables, and move them onto their own MySQL server.  Partition-by-function keeps the … you write scripts to be able to migrate users to/from shards you can tweak and rebalanced to make sure that all…

Post: Converting Character Sets

to store text data, and those who are still using latin1 have begun to migrate their databases to utf8.  Googling for “mysql convert charset tofrom text to mediumtext…to parallel-ize the ALTER statements and is available at: %> wget http://www.pablowe.net/convert_charset It will be added to Percona