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...
by Sveta Smirnova | Jan 25, 2016 | Insight for DBAs, MySQL
by Dave Avery | Jan 22, 2016 | MySQL, Percona Events
Percona invites you to attend a webinar Wednesday, January 27th, with CEO Peter Zaitsev: Compression In Open Source Databases. Register now! Data growth has been tremendous in the last decade and shows no signs of stopping. To deal with this trend database...
by Kortney Runyan | Jan 22, 2016 | MariaDB, MongoDB, MySQL, Percona Events
The Percona Live Data Performance Conference 2016 is rapidly approaching, and we’re looking forward to providing an outstanding experience April 18-21 for all whom attend. Percona Live is the premier event for the rich and diverse open source community and businesses...
by Alexander Rubin | Jan 21, 2016 | MySQL
We’d like to thank everybody for joining us on January 7th for our “Tired of MySQL Making You Wait?” webinar with Percona’s Alexander Rubin, Principal Consultant and SolarWinds’ Janis Griffin, Database Evangelist. Too often developers and DBAs struggle to pinpoint the...
by Miguel Angel Nieto | Jan 19, 2016 | MySQL
Data corruption! It can happen. Maybe because of a bug or storage problem that you didn’t expect, or MySQL crashes when a page checksum’s result is different from what is expected. Either way, corrupted InnoDB data can and does occur. What do you do then?...
by Vadim Tkachenko | Jan 15, 2016 | Insight for DBAs, MySQL
This is a followup to my previous post Apache Spark with Air ontime performance data. To recap an interesting point in that post: when using 48 cores with the server, the result was worse than with 12 cores. I wanted to understand the reason is was true, so I started...
by David Busby | Jan 14, 2016 | MySQL, Security
Earlier today advisories were sent out regarding OpenSSH versions 5.4 through 7.1., informing users about a security bug in the software. In essence, the advisory instructed people to add the UseRoaming no option to their ssh_config file, with a promise for further...
by Peter Zaitsev | Jan 14, 2016 | MySQL
When I first discovered Graphite years ago, I was very impressed with its monitoring capabilities. Compared to many RRD-based tools that were popular at the time (like Cacti), Graphite separated the captured data and graphs, allowing you to do all kinds of math and...
by Dave Avery | Jan 11, 2016 | Cloud, MySQL
Enterprises’ demand flexibility, scalability and efficiency to keep up with the demands of their customers — while maintaining the bottom line. To solve this, they’re running to cloud infrastructure services to both cut costs and take advantage of...
by Vadim Tkachenko | Jan 7, 2016 | Benchmarks, Insight for DBAs, MySQL
There is a growing interest in Apache Spark, so I wanted to play with it (especially after Alexander Rubin’s Using Apache Spark post). To start, I used the recently released Apache Spark 1.6.0 for this experiment, and I will play with “Airlines On-Time...
by Emily Ikuta | Dec 30, 2015 | MySQL, Webinars
Too often developers and DBAs struggle to pinpoint the root cause of MySQL database performance issues, and then spend too much time in trying to fix them. Wouldn’t it be great to bypass wasted guesswork and get right to the issue? In our upcoming webinar Tired of...