by Borys Belinsky | Oct 31, 2018 | MySQL, Open Source, Percona Software
Following the alpha release announced earlier, Percona announces the release candidate of Percona Server for MySQL 8.0.12-2rc1 on October 31, 2018. Download the latest version from the Percona website or from the Percona Software Repositories. This release is based on...
by Peter Zaitsev | Oct 30, 2018 | MariaDB, MongoDB, MySQL, Open Source, Percona Software, PostgreSQL
As MongoDB® has changed their license from AGPL to SSPL many are concerned by this change, and by how sudden it has been. Will SSPL be protective enough for MongoDB, or will the next change be to go to an altogether proprietary license? According to our poll, many are...
by Nickolay Ihalainen | Oct 30, 2018 | Insight for DBAs, PostgreSQL
PostgreSQL lightweight locks, or LWLocks, control memory access. PostgreSQL uses multi-process architecture and should allow only consistent reads and writes to shared memory structures. LWLocks have two levels of locking: shared and exclusive. It’s also possible to...
by Bronwyn Campbell | Oct 29, 2018 | Cloud, MariaDB, MongoDB, MySQL, Percona Live, PostgreSQL
It’s almost here! One week until the Percona Live Europe Open Source Database Conference 2018 in Frankfurt, Germany! Are you ready? This year’s theme is “Connect. Accelerate. Innovate.” We want to live these words by making sure that the conference allows you to...
by Bronwyn Campbell | Oct 26, 2018 | MariaDB, MongoDB, MySQL, Open Source, Percona Events, Percona Live, PostgreSQL
There’s just over one week to go so it’s time to announce the keynote addresses for Percona Live Europe 2018! We’re excited to share our lineup of conference keynotes, featuring talks from Paddy Power Betfair, Amazon Web Services, Facebook, PingCap...
by Bronwyn Campbell | Oct 25, 2018 | Cloud, MariaDB, MongoDB, MySQL, Open Source, Percona Events, Percona Live, PostgreSQL
Without our sponsors, it would be almost out of reach to deliver a conference of the size and format that everyone has come to expect from Percona Live. As well as financial support, our sponsors contribute massively by supporting their teams in presenting at the...
by Vadim Tkachenko | Oct 24, 2018 | MongoDB
As you may have heard, MongoDB recently changed the license for MongoDB Community version from AGPL to SSPL. In order to better serve our users and customers, we’d like to ask about your plans. Please select the answer that best describes your current thinking...
by Nickolay Ihalainen | Oct 24, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL
PostgreSQL locking visibility for application developers and DBAs is in most cases related to heavyweight locks. Complex database locking operations require full instrumentation using views from the system catalog. It should be clear which object is locked by a...
by Agustín | Oct 23, 2018 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Recently we had a customer that had issues with a filled disk on the server hosting their Docker pmm-server environment. They were not able to access the web UI, or even stop the pmm-server container because they had filled the /var/ mount point. Setting correct...
by Tim Vaillancourt | Oct 22, 2018 | Insight for Developers, MongoDB, Webinars
Please join Percona’s Sr. Technical Operations Architect Tim Vaillancourt as he presents Why Do Developers Prefer MongoDB? on Thursday, October 25th, 2018, at 10:00 AM PDT (UTC-7) / 1:00 PM EDT (UTC-4). Register Now As the fastest growing database technology today,...
by Alexander Rubin | Oct 22, 2018 | Insight for DBAs, MySQL
The short version I created > one billion InnoDB tables in MySQL 8.0 (tables, not rows) just for fun. Here is the proof: MySQL $ mysql -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1425329 Server version: 8.0.12 MySQL...
by Lorraine Pocklington, Community Manager | Oct 22, 2018 | MariaDB, MySQL, Open Source, Percona Events, Percona Live
For those who are looking forward to Percona Live Europe in just two weeks time—and for those yet to make up their minds—some of our presenters have shared some insight into their talks and what they’re most looking forward to themselves. Make no mistake, this...
by Jobin Augustine | Oct 19, 2018 | PostgreSQL, Webinars
Hello everyone, and thank you to those that attended our webinar on Building an Enterprise-grade PostgreSQL setup using open source tools last Wednesday. You’ll find the recordings of such as well as the slides we have used during our presentation here. We had...
by Borys Belinsky | Oct 18, 2018 | MySQL, Percona Software, ProxySQL
ProxySQL 1.4.11, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Percona’s proxysql-admin tool. ProxySQL is a high-performance proxy, currently for MySQL and its forks (like Percona Server for MySQL...
by Peter Zaitsev | Oct 18, 2018 | MongoDB
MongoDB, Inc. announced it has elected to change its license for MongoDB Community Server from AGPLv3 to a new license type they have created called a “Server Side Public License (SSPL)” citing the need to have a license better suited for the age of...
by Jobin Augustine | Oct 18, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL
You may be aware that the new major version of PostgreSQL has been released today. PostgreSQL 11 is going to be one of the most vibrant releases in recent times. It incorporates many features found in proprietary, industry-leading database systems, further qualifying...
by Alexander Rubin | Oct 17, 2018 | Insight for DBAs, Insight for Developers, MongoDB, Webinars
Please join Percona’s Principal Consultant, Alex Rubin, as he presents MongoDB 4.0 Features – Transactions & More on Thursday, October 18th at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Watch Now MongoDB 4.0 adds support for multi-document ACID...
by Tibor Korocz | Oct 17, 2018 | Insight for DBAs, MySQL
Parallel replication has been around for a few years now but is still not that commonly used. I had a customer where the master had a very large write workload. The slave could not keep up so I recommended to use parallel slave threads. But how can I measure if it...
by Nickolay Ihalainen | Oct 16, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL
An understanding of PostgreSQL locking is important to build scalable applications and avoid downtime. Modern computers and servers have many CPU cores and it’s possible to execute multiple queries in parallel. Databases containing many consistent structures with...
by Ibrar Ahmed | Oct 12, 2018 | PostgreSQL, Security
Authorisations and encryption/decryption within a database system establish the basic guidelines in protecting your database by guarding against malicious structural or data changes. What are authorisations? Authorisations are the access privileges that mainly control...
