EmergencyEMERGENCY? Get 24/7 Help Now!

Encrypt your –defaults-file

 | October 12, 2016 |  Posted In: Insight for DBAs, MySQL, Percona Toolkit

encrypt

This blog post will look how to use encryption to secure your database credentials. In the recent blog post Use MySQL Shell Securely from Bash, there are some good examples of how you might avoid using a ~/.my.cnf – but you still need to put that password down on disk in the script. MySQL 5.6.6 and later introduced […]

Read More

Webinar Thursday September 22 – Black Friday and Cyber Monday: How to Avoid an E-Commerce Disaster

 | September 21, 2016 |  Posted In: Insight for DBAs, MongoDB, MySQL

e-commerce disaster

Join Percona’s Sr. Technical Operations Architect, Tim Vaillancourt on Thursday, September 22, at 10 am PDT (UTC-7) for the webinar Black Friday and Cyber Monday: How to Avoid an E-Commerce Disaster. This webinar will provide some best practices to ensure the performance of your system under high-traffic conditions. Can your retail site handle the traffic […]

Read More

How X Plugin Works Under the Hood

 | September 16, 2016 |  Posted In: Insight for DBAs, MySQL

X Plugin

In this blog post, we’ll look at what MySQL does under the hood to transform NoSQL requests to SQL (and then store them in InnoDB transactional engine) when using the X Plugin. X Plugin allows MySQL to function as a document store. We don’t need to define any schema or use SQL language while still […]

Read More

Black Friday and Cyber Monday: Best Practices for Your E-Commerce Database

 | September 14, 2016 |  Posted In: Insight for DBAs, MongoDB, MySQL, Technical Webinars

E-Commerce Database

This blog post discusses how you can protect your e-commerce database from a high traffic disaster. Databases power today’s e-commerce. Whether it’s listing items on your site, contacting your distributor for inventory, tracking shipments, payments, or customer data, your database must be up, running, tuned and available for your business to be successful. There is […]

Read More

Basic Housekeeping for MySQL Indexes

 | September 9, 2016 |  Posted In: Insight for DBAs, MySQL

MySQL Indexes

In this blog post, we’ll look at some of the basic housekeeping steps for MySQL indexes. We all know that indexes can be the difference between a high-performance database and a bad/slow/painful query ride. It’s a critical part that needs deserves some housekeeping once in a while. So, what should you check? In no particular order, […]

Read More

pt-online-schema-change (if misused) can’t save the day

 | May 24, 2016 |  Posted In: Insight for DBAs, MySQL, Percona Toolkit, Replication

GTID replication

In this blog post we’ll discuss pt-online-schema-change, and how to correctly use it. Always use pt-osc? Altering large tables can be still a problematic DBA task, even now after we’ve improved Online DDL features in MySQL 5.6 and 5.7. Some ALTER types are still not online, or sometimes just too expensive to execute on busy production […]

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.