EmergencyEMERGENCY? Get 24/7 Help Now!

What to expect at Percona Live 2016!

 | March 9, 2016 |  Posted In: Percona Live

12 Days Until Percona Live

Whew! We’ve just about have all the i’s dotted and t’s crossed for the upcoming Percona Live Data Performance Conference in Santa Clara, April 18-21. We’re looking forward to seeing you there. We’re posting this blog to let you know what to expect at Percona Live 2016. Just to keep you posted on what we’ve […]

Read More

Orchestrator: MySQL Replication Topology Manager

and  | March 8, 2016 |  Posted In: MySQL, Orchestrator, Replication

Orchestrator MySQL topology manager

This blog post discusses Orchestrator: MySQL Replication Topology Manager. What is Orchestrator? Orchestrator is a replication topology manager for MySQL. It has many great features: The topology and status of the replication tree is automatically detected and monitored Either a GUI, CLI or API can be used to check the status and perform operations Supports automatic […]

Read More

High availability with asynchronous replication… and transparent R/W split

 | February 25, 2016 |  Posted In: GTID, High-availability, MariaDB, Maxscale, MySQL

High availability with asynchronous replication

In this post, the first one of a Maxscale series, I describe how to use MariaDB’s MaxScale and MySQL-utilities with MySQL Asynchronous replication. When we talk about high availability with asynchronous replication, we always think about MHA or PRM. But if we want to transparently use the slave(s) for READs, what can we use ? Description: […]

Read More

MySQL connection using SSL… or not ?

 | February 23, 2016 |  Posted In: MySQL, MySQL 5.7

MySQL connection using SSL

In this blog post, we’ll discuss how we can determine if a MySQL connection is using SSL. Since MySQL 5.7.5 the server generates SSL certificates (see auto_generate_certs) by default if compiled with SSL, or uses mysql_ssl_rsa_setup if compiled with YaSSL. But how can we check to see if our MySQL client connection uses SSL ? When using an […]

Read More

Upcoming Webinar Wednesday: Using Grafana for MySQL Monitoring

 | February 21, 2016 |  Posted In: MySQL

Grafana MySql monitoring

Grafana is the leading graph and dashboard builder for visualizing time series, which is a great tool for visual monitoring of MySQL databases. Come learn how to use Grafana for MySQL monitoring. In this webinar, Torkel Odegaard, Grafana Founder and Creator, will provide an introduction to Grafana and talk about adding data sources, creating dashboards […]

Read More

MySQL Auditing with MariaDB Auditing Plugin

 | February 15, 2016 |  Posted In: MariaDB, MySQL, MySQL Audit Log Plugin

MySQL MariaDB audit

This blog will address how the MariaDB Auditing Plugin can help monitor database activity to help with security, accountability and troubleshooting. Why Audit Your Databases? Auditing is an essential task for monitoring your database environment. By auditing your database, you can achieve accountability for actions taken or content accessed within your environment. You will also […]

Read More

Measuring Percona Server Docker CPU/network overhead

 | February 5, 2016 |  Posted In: MySQL, Percona Server

Docker

Now that we have our Percona Server Docker images, I wanted to measure the performance overhead when we run the database in the container. Since Docker promises to use a lightweight container, in theory there should be very light overhead. We need to verify that claim, however. In this post I will show the numbers for CPU and network intensive workloads, […]

Read More

MySQL password expiration features to help you comply with PCI-DSS

 | February 4, 2016 |  Posted In: MySQL 5.7, Security

database security

PCI Compliance (section 8.2.4) requires users to change password every 90 days. Until MySQL 5.6.6 there wasn’t a built-in way to comply with this requirement. Since MySQL version 5.6.6 there’s a password_expired feature which allows to set a user’s password as expired. This has been added to the mysql.user table and its default value it’s […]

Read More

Experimental Percona Docker images for Percona Server

 | February 2, 2016 |  Posted In: MySQL, Percona Server

Docker

Docker is incredibly popular tool for deploying software, so we decided to provide a Percona Docker image for both Percona Server MySQL and Percona Server for MongoDB. We want to create an easy way to try our products. There are actually some images available from https://hub.docker.com/_/percona/, but these images are provided by Docker itself, not from Percona. […]

Read More

EXPLAIN FORMAT=JSON has details for subqueries in HAVING, nested selects and subqueries that update values

 | January 25, 2016 |  Posted In: EXPLAIN, EXPLAIN FORMAT=JSON is cool!, MySQL, query tuning

Over several previous blog posts, we’ve already discussed what information the  EXPLAIN FORMAT=JSON output provides for some subqueries. You can review those discussions here, here and here. EXPLAIN FORMAT=JSON shows many details that you can’t get with other commands. Let’s now finish this topic and discuss the output for the rest of the subquery types. First, let’s look at the subquery […]

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.