by James Lawrie | Oct 11, 2018 | Insight for DBAs, Insight for Developers, MySQL, ProxySQL
With the exception of the three configuration variables described here, ProxySQL will only parse the configuration files the first time it is started, or if the proxysql.db file is missing for some other reason. If we want to change any of this data we need to do so...
by Bronwyn Campbell | Oct 11, 2018 | MongoDB, MySQL, Percona Events, Percona Live, PostgreSQL
After much speculation following the announcement in Santa Clara earlier this year, we are delighted to announce Percona Live 2019 will be taking place in Austin, Texas. Save the dates in your diary for May, 28-30 2019! The conference will take place just after...
by Dmitriy Kostiuk | Oct 10, 2018 | Cloud, MongoDB, Monitoring, MySQL, Percona Software
Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL® and MongoDB® performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis...
by Przemysław Malkowski | Oct 10, 2018 | Insight for DBAs, MySQL
Probably not well known but quite an important optimization was introduced in MySQL 5.6 – reduced overhead for “read only transactions”. While usually by a “transaction” we mean a query or a group of queries that change data, with transaction engines like InnoDB,...
by Aayushi Mangal | Oct 10, 2018 | Insight for DBAs, MongoDB, Percona Software
by Fernando Laudares Camargos | Oct 9, 2018 | Monitoring, Percona Software, PostgreSQL, Webinars
This is the last post in our series on building an enterprise-grade PostgreSQL set up using open source tools, and we’ll be covering monitoring. The previous posts in this series discussed aspects such as security, backup strategy, high availability, connection...
by Jeff Sandstrom | Oct 9, 2018 | Insight for Developers, MongoDB, Percona Software, Webinars
Please join Percona’s Product Manager for Percona Server for MongoDB, Jeff Sandstrom; Sr. Tech Ops Architect for MongoDB, Tim Vaillancourt; and Mesosphere’s Senior Director of Community and Evangelism, Matt Jarvis, on Thursday, October 11, 2018 at 10:00 AM PDT (UTC–7)...
by Borys Belinsky | Oct 9, 2018 | Insight for DBAs, MySQL, Percona Software
The second alpha build of Percona XtraBackup 8.0.2 is now available in the Percona experimental software repositories. Note that, due to the new MySQL redo log and data dictionary formats, the Percona XtraBackup 8.0.x versions will only be compatible with MySQL 8.0.x...
by Fernando Laudares Camargos | Oct 8, 2018 | Insight for DBAs, Insight for Developers, MySQL
The release of MySQL 8.0 has brought a lot of bold implementations that touched on things that have been avoided before, such as added support for common table expressions and window functions. Another example is the change in how AUTO_INCREMENT (autoinc) sequences...
by Fernando Laudares Camargos | Oct 8, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL
In this penultimate post from our series on building an enterprise-grade PostgreSQL environment we cover the parameters we have enabled to configure detailed logging in the demo setup we will showcase in our upcoming webinar. Detailed logging in PostgreSQL and log...
by Jobin Augustine | Oct 5, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL
In this current series of blog posts, we have been discussing various relevant aspects when building an enterprise-grade PostgreSQL setup, such as security, back up strategy, high availability, and different methods to scale PostgreSQL. In this blog post, we’ll...
by Aayushi Mangal | Oct 5, 2018 | Insight for DBAs, MongoDB, Percona Software
In this blog post, we will learn what MongoDB chained replication is, why you might choose to disable it, and the steps you need to take to do so. What is chain replication? Chain Replication in MongoDB, as the name suggests, means that a secondary member is able to...
by Ceri Williams | Oct 4, 2018 | Insight for DBAs, MariaDB, MySQL
When deciding on your backup strategy, one of the key components for Point In Time Recovery (PITR) will be the binary logs. Thankfully, the mysqlbinlog command allows you to easily take binary log backups, including those that would otherwise be encrypted on disk...
by Bronwyn Campbell | Oct 4, 2018 | MariaDB, MongoDB, MySQL, Open Source, Percona Events, Percona Live, Percona Software, PostgreSQL
Offering over 110 conference sessions across Tuesday, 6 and Wednesday, 7 November, and a full tutorial day on Monday 5 November, we hope you’ll find that this fantastic line up of talks for Percona Live Europe 2018 to be one of our best yet! Innovation in...
by Lorraine Pocklington, Community Manager | Oct 3, 2018 | Cloud, Percona Events
Percona’s latest blog poll asks how you run your database in the cloud? Join in! Are you using a fully managed service or are you self-managing your databases in the cloud? And what provider are you relying on? Perhaps you’re using more than one....
by David Ducos | Oct 3, 2018 | Insight for DBAs, Insight for Developers, MySQL
Some time ago, a customer had a performance issue with an internal process. He was comparing, finding, and reporting the rows that were different between two tables. This is simple if you use a LEFT JOIN and an IS NULL comparison over the second table in the WHERE...
by Borys Belinsky | Oct 2, 2018 | Insight for DBAs, MySQL, Percona Events, Percona Software, ProxySQL
To resolve a critical regression, Percona announces the release of Percona XtraDB Cluster 5.7.23-31.31.2 on October 2, 2018 Binaries are available from the downloads section or from our software repositories. This release resolves a critical regression in...
by Avinash Vallarapu | Oct 2, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL
In the previous blog posts in this series, we’ve covered some of the essential aspects of an Enterprise-grade solution: security, high availability, and backups. Another important aspect is the scalability of the solution: as our application grows how do we...
by Vadim Tkachenko | Oct 1, 2018 | Insight for DBAs, MySQL
Following my post from a year ago about ClickHouse I wanted to review what happened in ClickHouse since then. There is indeed some interesting news to share. 1. ClickHouse in DB-Engines Ranking. It did not quite get into the top 100, but the gain from position 174 to...
by Jaime Sicam | Oct 1, 2018 | Insight for DBAs, MySQL
MySQL supports replicating to a slave that is one release higher. This allows us to easily upgrade our MySQL setup to a new version, by promoting the slave and pointing the application to it. However, though unsupported, there are times when the MySQL version of slave...
