by Dave Avery | May 24, 2016 | MySQL
Join Sveta on Thursday, May 26, 2016, at 10 am PDT (UTC-7) for her webinar Troubleshooting MySQL hardware resource usage. MySQL does not just run on its own. It stores data on disk, and stores data and temporarily results in memory. It uses CPU resources to perform...
by Dave Avery | May 18, 2016 | MongoDB, MySQL
Please join Alexander Rubin, Percona Principal Consultant, for his webinar MongoDB administration for MySQL DBA on Thursday, May 19 at 10 am PDT (UTC-7). If you are a MySQL DBA and want to learn MongoDB quickly – this webinar is for you. MySQL and MongoDB share...
by Vadim Tkachenko | May 6, 2016 | MySQL
In this blog, we’ll examine how CPU governor performance affects MySQL. It’s been a while since we looked into CPU governors and with the new Intel CPUs and new Linux distros, I wanted to check how CPU governors affect MySQL performance. Before jumping to...
by Laurynas Biveinis | May 5, 2016 | MySQL
In this blog post, we’ll discuss how to use multi-threaded LRU flushing to prevent bottlenecks in MySQL. In the previous post, we saw that InnoDB 5.7 performs a lot of single-page LRU flushes, which in turn are serialized by the shared doublewrite buffer. Based...
by Tibor Korocz | Apr 27, 2016 | MySQL, Percona Software
In this post, we’ll discuss how MySQL 5.7 handles the old temporal types during an upgrade. MySQL changed the temporal types in MySQL 5.6.4, and it introduced a new feature: microseconds resolution in the TIME, TIMESTAMP and DATETIME types. Now these parameters...
by Dave Avery | Apr 21, 2016 | Percona Live
The second day of Percona Live 2016 is wrapping up, but I still wanted to get to one last lecture. Fortunately, there was a great one available: What’s New in MySQL with Geir Høydalsvik, Senior Software Development Director at Oracle, and Simon Mudd, DBA at...
by Dave Avery | Apr 16, 2016 | Percona Services
The last email introduced two members of the Percona Database Performance Team: The Maven and The Specialist. Now we’re ready to reveal the identity of the final three team members. The Database Performance Team is comprised of our services experts, who work...
by Tibor Korocz | Apr 13, 2016 | Insight for DBAs, MySQL
In our previous post, we showed how Orchestrator can handle complex replication topologies. Today we will discuss how the Orchestrator-agent complements Orchestrator by monitoring our servers, and provides us a snapshot and recovery abilities if there are problems....
by Dave Avery | Apr 5, 2016 | MySQL
Join us for our latest webinar on Thursday, April 7, at 10 am PDT (UTC-7) on Introduction to Troubleshooting Performance: What Affects Query Execution? MySQL installations experience a multitude of issues: server hangs, wrong data stored in the database, slow running...
by Nik Vyzas | Mar 30, 2016 | Cloud, Insight for DBAs, MySQL, Percona Software
In this blog post, we’ll discuss some of the basics regarding Docker MySQL replication. Docker has gained widespread popularity in recent years as a lightweight alternative to virtualization. It is ideal for building virtual development and testing environments....
by Dave Avery | Mar 23, 2016 | Percona Live
Welcome to the next installment of our talks with Percona Live Data Performance Conference 2016 speakers! In this series of blogs, we’ll highlight some of the speakers that will be at this year’s conference, as well as discuss the technologies and outlooks of the...
by Kortney Runyan | Mar 9, 2016 | 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...
by Tibor Korocz | Mar 8, 2016 | Insight for DBAs, MySQL
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...
by Frederic Descamps | Feb 25, 2016 | Insight for DBAs, MariaDB, MySQL
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...
by Frederic Descamps | Feb 23, 2016 | MySQL
In this blog post, we’ll determine a MySQL connection using SSL… or not. 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...
by Dave Avery | Feb 21, 2016 | MySQL
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...
by Manjot Singh | Feb 15, 2016 | MariaDB, MySQL
MariaDB no longer meeting your needs? Migrate to Percona software for MySQL – an open source,production-ready, and enterprise-grade MySQL alternative. Learn More This blog will address how the MariaDB Auditing Plugin can help monitor database activity to help...
by Vadim Tkachenko | Feb 5, 2016 | Cloud, MySQL, Percona Software
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...
by Pablo Padua | Feb 4, 2016 | Security
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 “N.” You can change it to “Y” using the ALTER USER statement. Here’s an quick example on how...
by Vadim Tkachenko | Feb 2, 2016 | Cloud, MySQL, Percona Software
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...
