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.
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
… makes sense only when addition/removal of hosts from a cluster or a HA setup is simple and uncomplicated. Their post focuses…) Integration of chef with PXC Finally, integration of HAProxy as a loadbalancer. To elucidate, their initial setup goes into bootstrapping the… sync status. As referenced in that post, you can refer a post by Peter Boros (“Percona XtraDB Cluster reference architecture with…
Comment: Converting Character Sets
June 12, 2013 By 22 Comments
…/refman/5.1/en/alter-table.html “For a column that has a data type of VARCHAR or one of the TEXT… ensure that the new column is long enough to store as many characters as the original column.” [followed by a complete explanation…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
… at Portland, Oregon next Monday, June 17. The latest in a series of FREE one-day educational events, we are pleased…, Percona Xtrabackup and Performance and Improvements and new Features in MySQL 5.6 Garrick Peterson, a member of Percona’s RemoteDBA team… Senior MySQL Instructor, will continue the topic of BigData with a talk titled, “Conquering BigData with MySQL and Shard Query” Daniel…
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
…. With simple services or development systems, many people are using a single server with some backups configured, and then simply take the downtime when a restore is needed. As the application evolves, additional requirements will… have to deal with. Even later, when asynchronous or single-threaded replication is not enough, people can use Percona XtraDB Cluster…
Post: Call for papers: Percona Live London
June 14, 2013 By Leave a Comment
… submit your proposals. Your participation is an opportunity to make a difference. After all, the conference would be meaningless without great…, technology evangelists, DBAs and entrepreneurs. Download the prospectus and take a closer look at the benefits of sponsorship. Questions? Let me…
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: Impact of logging on MySQL’s performance
June 11, 2013 By 8 Comments
… for very large (but not necessarily slow) queries. It’s a good tool but it should only be used when needed…
Comment: Migrating between MySQL schemas with Percona Xtrabackup
June 11, 2013 By 2 Comments
Is there a way to modify the discard script so that it deals with foreign key constraints?
