by Dimitri Vanoverbeke | Dec 29, 2016 | MySQL
This blog provides a query language type overview. The idea for this blog originated from some customers asking me questions. When working in a particular field, you often a dedicated vocabulary that makes sense to your peers. It often includes phrases and...
by Dave Avery | Dec 29, 2016 | Insight for DBAs, MySQL, Percona Live
Welcome to another post in the series of Percona Live featured tutorial speakers blogs! In these blogs, we’ll highlight some of the tutorial speakers that will be at this year’s Percona Live conference. We’ll also discuss how these tutorials can help you improve your...
by Jaime Sicam | Dec 28, 2016 | Insight for DBAs, MySQL
In a previous article, Ovais demonstrated how a DDL can render a table blocked from new queries. In another article, Valerii introduced performance_schema.metadata_locks, which is available in MySQL 5.7 and exposes metadata lock details. Given this information,...
by Peter Zaitsev | Dec 28, 2016 | Insight for DBAs, MySQL, Percona Software
In this blog post, we’ll find out how to use Percona XtraBackup on a MySQL instance with a large number of tables. As of Percona Xtrabackup 2.4.5, you are required to have enough open files to open every single InnoDB tablespace in the instance you’re trying to...
by Dave Avery | Dec 27, 2016 | MySQL, Webinars
Please join Percona’s Consultant David Ducos on Thursday, December 29, 2016 at 10 am PST/ 1:00 pm EST (UTC-8) as he presents JSON in MySQL 5.7. Since it was implemented in MySQL 5.7, we can use JSON as a data type. In this webinar, we will review some of the...
by Przemysław Malkowski | Dec 27, 2016 | Insight for DBAs, Insight for Developers, MongoDB, MySQL
This blog discusses how to prepare your database for the new leap second coming in the new year. At the end of this year, on December 31, 2016, a new leap second gets added. Many of us remember the huge problems this caused back in 2012. Some of our customers asked...
by Alexey Zhebel | Dec 23, 2016 | MongoDB, Percona Events, Percona Software
Percona is pleased to announce the release of Percona Server for MongoDB 3.4.0-1.0beta on December 23, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. NOTE: Beta packages are available from testing repository. Percona...
by Dave Avery | Dec 21, 2016 | MongoDB, MySQL
Take Percona’s blog poll on what programming languages you’re using for backend development. While customers and users focus and interact with applications and websites, these are really just the tip of the iceberg for the whole end-to-end system that allows...
by Peter Zaitsev | Dec 21, 2016 | MongoDB, MySQL
This blog shows the results from Percona’s poll on what database technologies our readers use in their environment. We design different databases for different scenarios. Using one database technology for every situation doesn’t make sense, and can lead to...
by Manjot Singh | Dec 21, 2016 | Cloud, Percona Software
by Adamo Tonete | Dec 19, 2016 | MongoDB
In this blog post we’ll look at how to go about securing MongoDB instances. Authentication is one of the most important features of a database, and MongoDB supports it in different ways. Although it allows you to work without any authentication, the best...
by Jon Tobin | Dec 16, 2016 | Cloud, Insight for DBAs, Insight for Developers, MongoDB, Open Source, Percona Software
In this blog is an in-depth discussion of MongoDB PIT backups. Note: INTIMIDATION FREE ZONE!! This post is meant to give the reader most of the knowledge that is needed to understand the material. This includes basic MongoDB knowledge and other core concepts. I have...
by Dave Avery | Dec 16, 2016 | Cloud, Insight for DBAs, MariaDB, MongoDB, Monitoring, MySQL, Percona Events, Percona Live
We are excited to announce that the sneak peek schedule for the Percona Live 2017 Open Source Database Conference is up! The Percona Live Open Source Database Conference 2017 is April 24th – 27th, at the Hyatt Regency Santa Clara & The Santa Clara Convention...
by Alexey Zhebel | Dec 15, 2016 | MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona XtraDB Cluster 5.7.16-27.19 on December 15, 2016. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.7.16-27.19 is now the current release, based on the following: Percona...
by Dave Avery | Dec 15, 2016 | MongoDB, MySQL, Percona Live
Welcome to a new series of blogs: Percona Live featured tutorial speakers! In these blogs, we’ll highlight some of the tutorial speakers that will be at this year’s Percona Live conference. We’ll also discuss how these tutorials can help you improve your database...
by Rick Golba | Dec 14, 2016 | Insight for DBAs, MongoDB, MySQL
In this blog post, we’ll discuss the differences between row store and column store databases. Clients often ask us if they should or could be using columnar databases. For some applications, a columnar database is a great choice; for others, you should stick...
by Alexey Zhebel | Dec 14, 2016 | MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona XtraDB Cluster 5.6.34-26.19 on December 14, 2016. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.6.34-26.19 is now the current release, based on the following: Percona...
by Dave Avery | Dec 13, 2016 | MongoDB, Webinars
Please join Percona Senior Technical Operations Architect Tim Vaillancourt on Wednesday December 14, at 10:00 am PST/ 1:00pm EST (UTC-8) as he presents MongoDB System Tuning Best Practices. People give much love to optimizing document design, provisioning, and even...
by Tim Vaillancourt | Dec 13, 2016 | MongoDB
This blog discusses MongoDB 3.4 GA facet aggregation features and the SERVER-27395 mongod crash bug. As you may have heard, in late November MongoDB 3.4 GA was released. One feature that stuck out for me, a Lucene enthusiast, was the addition of powerful grouping and...
by Barrett Chambers | Dec 12, 2016 | Cloud, Insight for DBAs, Monitoring, MySQL, Percona Services, Percona Software
In this blog series, I will discuss common questions I receive as a database Solutions Engineer at Percona. In this role, I speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller single-server...
