EmergencyEMERGENCY? Get 24/7 Help Now!

MySQL 5.6’s new replication features: Benefits, Limitations and Challenges

 | October 21, 2013 |  Posted In: MySQL, MySQL Webinars

On Wednesday I’ll be leading a webinar exploring MySQL 5.6’s new replication features. And yes, as usual I’ll deliver news on the good, the bad and the ugly (that is to say the benefits, limitations and challenges). The webinar, appropriately titled, “New Replication Features in MySQL 5.6: Benefits, Limitations, and Challenges“, is scheduled for Oct. […]

Read More

Innotop: A real-time, advanced investigation tool for MySQL

 | October 14, 2013 |  Posted In: Insight for DBAs, MySQL, Percona MySQL Support

GUI monitoring tools for MySQL are not always suitable for all our needs or situations. Most of them are designed to provide historical views into what happens to our database over time rather then real-time insight into current MySQL server status. Excellent free tools for this include Cacti, Zabbix, Ganglia, Nagios, etc. But each of […]

Read More

MySQL 5.6 Configuration Optimization Webinar, Sept. 25

 | September 24, 2013 |  Posted In: Insight for DBAs, MySQL, MySQL Webinars

This Wednesday in our next webinar I’ll share how to configure a better-performing MySQL 5.6 server. You’ll lean a practical approach to generating a sensible configuration file that sets what is needed and omits what is not. Why dedicate an entire webinar to the new configuration settings within MySQL 5.6? Mainly because the default configuration […]

Read More

Enabling crash-safe slaves with MySQL 5.6

 | September 13, 2013 |  Posted In: Insight for DBAs, MySQL

Being able to configure slaves to be crash-safe is one of the major improvements of MySQL 5.6 with regards to replication. However we noticed confusion on how to enable this feature correctly, so let’s clarify how it should be done. In short 1. Stop MySQL on slave 2. Add relay_log_info_repository = TABLE and relay_log_recovery = […]

Read More

Here’s my favorite secret MySQL 5.6 feature. What’s yours?

 | September 5, 2013 |  Posted In: MySQL

MySQL 5.6 has a great many new features, including, but certainly not limited to a number of performance improvements. However, besides the widely talked-about features such as InnoDB support for full text search, optimizer, performance schema improvements and GTID, there are also a few tiny improvements that nobody cared to mention. One such feature is…

Read More

Amazon RDS with MySQL 5.6 – Configuration Variables

 | August 21, 2013 |  Posted In: Cloud and NoSQL, MySQL, MySQL Webinars

One longstanding complaint I have heard for the past several years, and still hear today, is that Amazon’s Relational Database Service (RDS) does not allow the configuration flexibility as running MySQL in an ec2 instance. While true, this ignores the consistent work that Amazon has done to provide access to the most important configuration variables […]

Read More

MySQL 5.6 security vs ease of use

 | August 17, 2013 |  Posted In: MySQL

MySQL 5.6 surely changes the game when it comes to security vs ease of use. Before MySQL 5.6 we would get default MySQL installation being pretty insecure – the user “root” will be created with no password as well as anonymous user with limited access from local host (though still enough to cause DOS attack […]

Read More

MySQL Security: Armoring Your Dolphin

 | August 16, 2013 |  Posted In: Insight for DBAs, MySQL, MySQL Webinars

My colleague and teammate Ernie Souhrada will be presenting a webinar on Wednesday, August 21, 2013 at 10 a.m. PDT titled “MySQL Security: Armoring Your Dolphin.” This is a popular topic with news breaking routinely that yet another Internet company has leaked private data of one form or another. Ernie’s webinar will be a great […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.