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 18, 2017 | MySQL
Join Percona’s, Technical Services Manager, Jervin Real as he presents Learning MySQL 5.7 on Wednesday, July 19, 2017 at 10:00 am PDT / 1:00 pm EDT (UTC-7). Register Now MySQL 5.7 has a lot of new features. If you’ve dabbled with an older version of MySQL, it is...
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 17, 2017 | MongoDB, Percona Events, Percona Software
Percona announces the release of Percona Server for MongoDB 3.2.14-3.4 on July 17, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB is an enhanced, open-source, fully compatible, highly...
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 Jaime Sicam | Jul 13, 2017 | Insight for DBAs, MySQL, Percona Software, Security
In this blog post, we’ll look at how to set up Percona PAM with Active Directory for external authentication. In my previous article on Percona PAM, I demonstrated how to use Samba as a domain, and how easy it is to create domain users and groups via the...
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 11, 2017 | Insight for DBAs, MongoDB, Webinars
Join Percona’s Senior Technical Services Engineer, Adamo Tonete as he presents MongoDB Index Types: How, When and Where Should They Be Used? on Wednesday, July 12, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7). Register Now MongoDB has 12 index types. Do you know how...
by Alexey Zhebel | Jul 10, 2017 | MongoDB, Percona Events, Percona Software
Percona announces the release of Percona Server for MongoDB 3.4.5-1.5 on July 10, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB is an enhanced, open source, fully compatible,...
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 Adamo Tonete | Jul 8, 2017 | Insight for DBAs, MongoDB, Webinars
In this blog post, we will talk about MongoDB indexing, and the different types of indexes that are available in MongoDB. Note: We are hosting a webinar on July 12, 2017, where I will talk about MongoDB indexes and how to choose a good indexing plan. MongoDB is a...
by Adamo Tonete | Jul 7, 2017 | Insight for DBAs, MongoDB
In this blog post, I’ll look at how you can use a backup to start a secondary instance for MongoDB. Although the documentation says it is not possible to use a backup to start a secondary, sometimes this is the only possible way to start a new instance. In this...
by Vadim Tkachenko | Jul 6, 2017 | Benchmarks, Insight for DBAs, MySQL
In this blog, we’ll look at ClickHouse on its one year anniversary. It’s been a year already since the Yandex team released ClickHouse as open source software. I’ve had an interest in this project from the very start, as I didn’t think there was an...
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...
