Approach number 1 is correct. There was no truncation: MEDIUMTEXT is bigger than TEXT. MySQL does this to make sure there’s *no… or one of the TEXT types, CONVERT TO CHARACTER SET will change the data type as necessary to ensure that the new column is long enough to store as many characters as the…
Comment: On Benchmarks on SSD
June 17, 2013 By 4 Comments
great write up, heres a video I did on my SSD: http://www.youtube.com/watch?v=gZJ-pPeE5lA
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.
Comment: How to change innodb_log_file_size safely
June 13, 2013 By 17 Comments
@Question: Did your innodb engine startup correctly? Seems to me that you can see any innodb dbs because of this.
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.
Comment: Minimizing Downtime from Lengthy AWS Outages
June 12, 2013 By 7 Comments
Please post your experience on Percona XtraDB Cluster (PXC) on AWS. I would help us since we want to explore this option.
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…to 6.4, upgrading your distribution to 6.4 may break your cluster. In this post I will explain you how to…” transport=”udpu” Let’s check if the configuration file is OK: [root@percona1 ~]# …or clustat (if you have installed rgmanager) [root@percona3 ~]# cman_tool nodes Node Sts Inc Joined Name 1 M 64…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…is explicit. This has an impact on how SchemaSpy identifies the relationship, and whether you need to provide a hint or…SQL NULL value. This is basically a quick sanity check of your schema for any significant errors or…
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
…you have to deal with. Even later, when asynchronous or single-threaded replication is not… replication. If the application gets really popular, sooner or later you have to …My presentation will provide an overview of some possible deployment and scaling scenarios, when it makes sense to use one or…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…My apologies if we weren’t able to get to…bit during the session, but to provide a bit…to slave, and if so, how? A: Yes. There are a few of ways to do it. One way is to…is also somewhat similar to Oracle RAC; all of the SQL nodes in a MySQL Cluster installation are going to be talking to…
