by Manjot Singh | Jul 20, 2017 | Insight for DBAs, ProxySQL
In this blog post, we’ll look at how to deploy ProxySQL. ProxySQL is a high-performance proxy, currently for MySQL and its forks (like Percona Server for MySQL and MariaDB). It acts as an intermediary for client requests seeking resources from the database. It...
by Dave Avery | Jul 19, 2017 | MariaDB, MongoDB, MySQL
In this post, we’ll use a blog poll to find out what operating system you use to run your development database servers. In our last blog poll, we looked at what OS you use for your production database. Now we would like to see what you use for your development...
by Juan Arruti | Jul 19, 2017 | Insight for DBAs, MySQL
In this blog post, I’ll talk about multi-threaded slave statistics printed in MySQL error log file. MySQL version 5.6 and later allows you to execute replicated events using parallel threads. This feature is called Multi-Threaded Slave (MTS), and to enable it...
by Manjot Singh | Jul 18, 2017 | Insight for DBAs, MySQL, Percona Services
In this post, we’ll look at strategies for backups and disaster recovery. Note: I am giving a talk on Backups and Disaster Recovery Best Practices on July 27th. Register Now When discussing disaster recovery, it’s important to take your business’...
by Dave Avery | Jul 17, 2017 | MariaDB, MongoDB, MySQL, Percona Events, Percona Live
We are extending the Percona Live Open Source Database Conference Europe 2017 call for papers deadline to Monday, July 24, 2017. Get your submissions in now! Between our Conference Committee working hard to review all the outstanding talk ideas, and the many community...
by Alexey Zhebel | Jul 14, 2017 | Insight for DBAs, MariaDB, MongoDB, Monitoring, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona Monitoring and Management 1.2.0 on July 14, 2017. For installation instructions, see the Deployment Guide. Changes in PMM Server PMM Server 1.2.0 introduced the following changes: Updated Components Consul 0.8.5 Grafana 4.3.2...
by Jervin Real | Jul 14, 2017 | Insight for DBAs, MySQL
In this blog post, I’ll look at a trick we use at Percona when upgrading to MySQL 5.7. I covered this subject (and others) in my webinar Learning MySQL 5.7 on Wednesday, July 19, 2017. On Upgrading to MySQL 5.7 We’ve been doing upgrades for quite a while...
by Peter Zaitsev | Jul 12, 2017 | Benchmarks, Insight for DBAs, MySQL
In this blog post, I will run a gh-ost benchmark against the performance of pt-online-schema-change. When gh-ost came out, I was very excited. As MySQL ROW replication became commonplace, you could use it to track changes instead of triggers. This practice is cleaner...
by Alex Poritskiy | Jul 11, 2017 | MySQL, Open Source, Percona Software
In this blog post, we’ll look at how using thread_statistics can cause high memory usage. I was recently working on a high memory usage issue for one of our clients, and made some interesting discoveries: high memory usage with no bounds. It was really tricky to...
by Emily Ikuta | Jul 10, 2017 | Insight for DBAs, MariaDB, MySQL, Security, Webinars
Join Percona’s Chief Evangelist, Colin Charles as he presents Securing Your MySQL/MariaDB Data on Tuesday, July 11, 2017 at 7:00 am PDT / 10:00 am EDT (UTC-7). Register Now This webinar will discuss the features of MySQL/MariaDB that when enabled and used improve the...
by Krunal Bauskar | Jul 5, 2017 | Insight for DBAs, MySQL, Percona Software
In this blog, we’ll look at the differences in how a PREPARE statement handles errors in binary and text protocols. Introduction Since Percona XtraDB Cluster is a multi-master solution, when an application executes conflicting workloads one of the workloads gets...
by Emily Ikuta | Jul 5, 2017 | MySQL
Join Percona’s Solutions Engineer, Dimitri Vanoverbeke as he presents Security and Encryption in the MySQL World on Thursday, July 6, 2017, at 7:00 am PDT / 10:00 am EDT (UTC-7). Register Now MySQL and MariaDB Server provide many new features that help with...
by Emily Ikuta | Jul 3, 2017 | MySQL, Webinars
Join Percona’s Senior Architect, Matthew Boehm, as he presents Indexes – What You Need to Know to Get the Most Out of Them on Wednesday, July 5, 2017 at 8:00 am PDT / 11:00 am EDT (UTC-7). Register Now Proper indexing is key to database performance. Find out how MySQL...
by Manjot Singh | Jun 28, 2017 | MySQL, Security
Welcome to Part 2 in a series of blog posts on MySQL encryption at rest. This post covers InnoDB tablespace encryption. At Percona, we work with a number of clients that require strong security measures for PCI, HIPAA and PHI compliance, where data managed by MySQL...
by Tibor Korocz | Jun 27, 2017 | Insight for DBAs, MySQL, Security
This blog post looks at SSL connections and how they work in MySQL 5.7. Recently I was working on an SSL implementation with MySQL 5.7, and I made some interesting discoveries. I realized I could connect to the MySQL server without specifying the SSL keys on the...
by Emily Ikuta | Jun 26, 2017 | MariaDB, MySQL, Webinars
Join Percona’s Chief Evangelist, Colin Charles as he presents MariaDB Server 10.2: The Complete Guide on Tuesday, June 27, 2017, at 7:00 am PDT / 10:00 am EDT (UTC-7). Register Now The new MariaDB Server 10.2 release is out. It has some interesting new features, but...
by Kenny Gryp | Jun 23, 2017 | Insight for DBAs, Percona Software
Thank you for attending the Wednesday, June 21, 2017 high availability webinar titled Percona XtraDB Cluster, Galera Cluster, MySQL Group Replication. In this blog, I will provide answers to the Q & A for that webinar. You can find the slides and a recording of...
by Vadim Tkachenko | Jun 22, 2017 | Benchmarks, Insight for DBAs, MySQL
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test. We have mentioned ClickHouse in some recent posts (ClickHouse: New Open Source Columnar Database, Column Store Database Benchmarks:...
by Alexey Zhebel | Jun 21, 2017 | Insight for DBAs, MariaDB, MongoDB, Monitoring, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona Monitoring and Management 1.1.5 on June 21, 2017. For installation instructions, see the Deployment Guide. Changes in PMM Server PMM-667: Fixed the Latency graph in the ProxySQL Overview dashboard to plot microsecond values...
by Dave Avery | Jun 20, 2017 | Insight for DBAs, MySQL, Webinars
Join Percona’s Senior Operations Engineer, Daniel Kowalewski as he presents Deploying MySQL in Production on Thursday, June 22, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7). Register Now MySQL is famous for being something you can install and get going in less than...
