by Corrado Pandiani | Dec 4, 2018 | Insight for DBAs, Insight for Developers, MongoDB, Open Source
MongoDB 4.0 is around, and there are a lot of new features and improvements. In this article we’re going to focus on the major feature which is, undoubtedly, the support for multi-document ACID transactions. This novelty for a NoSQL database could be seen as a...
by Bronwyn Campbell | Dec 3, 2018 | Cloud, MariaDB, MongoDB, MySQL, Percona Live, Percona Software, PostgreSQL
Announcing the opening of the Percona Live 2019 Open Source Database Conference call for papers. It will be open from now until January 20, 2019. The Percona Live Open Source Database Conference 2019 takes place May 28-30 in Austin, Texas. Our theme this year...
by Nickolay Ihalainen | Nov 30, 2018 | Insight for DBAs, PostgreSQL
PostgreSQL streaming physical replication with slots simplifies setup and maintenance procedures. Usually, you should estimate disk usage for the Write Ahead Log (WAL) and provide appropriate limitation to the number of segments and setup of the WAL archive procedure....
by Borys Belinsky | Nov 29, 2018 | MySQL, Percona Software
Percona announces the release of Percona Server 5.6.42-84.2 on November 29, 2018 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.6.42, including all the bug fixes in it, Percona Server 5.6.42-84.2 is the current GA release...
by Marcelo Altmann | Nov 29, 2018 | Insight for DBAs, Insight for Developers, MySQL
Continuing on the series of blog posts about MySQL High Availability, today we will talk about stale reads and how to overcome this issue. The Problem Stale reads is a read operation that fetches an incorrect value from a source that has not synchronized an update...
by James Lawrie | Nov 28, 2018 | Insight for DBAs, MySQL
The settings of MySQL configuration variables have a fundamental impact on the performance of your database system. Sometimes it can be a little tricky to predict how changing one variable can affect others, and especially when dealing with cases like the one...
by Jervin Real | Nov 27, 2018 | MongoDB, MySQL
By the end of this article, you should be able to have a Percona Server for MongoDB and Percona Server for MySQL instance able to authenticate on an OpenLDAP backend. While this is mostly aimed at testing scenarios, it can be easily extended for production by...
by Tim Vaillancourt | Nov 26, 2018 | Insight for DBAs, MongoDB, Webinars
Please join Percona’s Sr. Technical Operations Architect, Tim Vaillancourt, as he presents Improve MongoDB Performance with Proper Queries on Thursday, November 29th, 2018, at 12:30 PM PST (UTC-8) / 3:30 PM EST (UTC-5). Register Now There are many different ways you...
by Dave Avery | Nov 26, 2018 | Cloud
Come see Percona at AWS re:Invent from November 26-30, 2018 in booth 1605 in The Venetian Hotel Expo Hall. Percona is a Bronze sponsor of AWS re:Invent in 2018 and will be there for the whole show! Drop by booth 1605 in The Venetian Expo Hall to discuss how...
by Rick Golba | Nov 25, 2018 | Cloud, Insight for DBAs, MySQL
Join Percona CEO Peter Zaitsev at AWS re:Invent as he presents MySQL High Availability and Disaster Recovery on Tuesday, November 27, 2018, in the Bellagio Resort, Level 1, Gaugin 2 at 1:45 PM. In this hour-long session, Peter describes the differences between high...
by Borys Belinsky | Nov 23, 2018 | Percona Software
Percona announces the release of Percona Server for MongoDB 3.4.18-2.16 on November 23, 2018. Download the latest version from the Percona website or the Percona Software Repositories. Percona Server for MongoDB 3.4 is an enhanced, open source, and highly-scalable...
by Yves Trudeau | Nov 23, 2018 | Insight for DBAs, MySQL
Over the last year, I have been pursuing a part time hobby project exploring ways to squeeze as much data as possible in MySQL. As you will see, there are quite a few different ways. Of course things like compression ratio matters a lot but, other items like...
by James Lawrie | Nov 22, 2018 | Insight for DBAs, MySQL, Percona Software
As per the documentation, pt-table-checksum is a tool to perform online replication consistency checks by executing checksum queries on the master, which produces different results on replicas that are inconsistent with the master. The master and each slave insert...
by Borys Belinsky | Nov 21, 2018 | MySQL, Percona Software
Percona announces the release of Percona Server for MySQL 5.7.23-25 on November 21, 2018 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.7.23, including all the bug fixes in it. Percona Server for MySQL...
by Borys Belinsky | Nov 21, 2018 | MySQL, Percona Software
Percona announces the release of Percona Server for MySQL 5.5.62-38.14 on November 21, 2018 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.5.62, including all the bug fixes in it. Percona Server for...
by Jervin Real | Nov 21, 2018 | Insight for DBAs, Insight for Developers, MongoDB
Like MySQL, having too many indexes on a MongoDB collection not only affects overall write performance, but disk and memory resources as well. While MongoDB holds predictably well in scaling both reads and writes options, maintaining a heathly schema design should...
by Dmitriy Kostiuk | Nov 20, 2018 | Percona Software, Security
Grafana Labs has released an important security update, and as you’re aware PMM uses Grafana internally. You’re probably curious whether this issue affects you. CVE-2018-19039 “File Exfiltration vulnerability Security fix” covers a recently...
by Dmitriy Kostiuk | Nov 20, 2018 | MongoDB, Monitoring, MySQL, Percona Software
Percona Monitoring and Management 1.17.0 (PMM) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance. You can run Percona Monitoring and Management 1.17.0 in your own environment for maximum security and reliability....
by Jobin Augustine | Nov 19, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL
Just-in-time (JIT in PostgreSQL) compilation of SQL statements is one of the highlighted features in PostgreSQL 11. There is great excitement in the community because of the many claims of up to a 30% jump in performance. Not all queries and workloads get the benefit...
by Jervin Real | Nov 19, 2018 | Cloud, MySQL
In this Checklist for Success series, we will discuss reducing unknowns when hosting in the cloud using and migrating to Amazon Aurora. These tips might also apply to other database as a service (DBaaS) offerings. Previous blogs in the migrating to Amazon Aurora...
