open source databases

Solve Query Failures Regarding ONLY_FULL_GROUP_BY SQL Mode

Solve Query Failures SQL mode

“Hey, what’s going on with my applications? I installed a newer version of MySQL. I have queries that perfectly run with the older version and now I have a lot of errors.”
This is a question some customers have asked me after upgrading MySQL. In this article, we’ll see what one of the most frequent […]

Read more

Community Update for PL Open Source Database Conference 2019

Percona Live community dinner on the Lone Star River Boat

It’s not long now before we’ll be gathering in Austin TX for this year’s Percona Live event. It’s the only conference of its type dedicated entirely to open source databases – of all marques. From a community perspective, we have a few updates to share.
Community Dinner
We’re happy to say that PlanetScale have stepped up […]

Read more

Announcing Keynotes for Percona Live Open Source Database Performance Conference 2019!

Percona Live 2019

There’s less than a month to go so it’s time to announce the keynote addresses for Percona Live Open Source Database Performance Conference 2019! We’re excited to share our lineup of conference keynotes, featuring talks from Continuent, Vivid Cortex, Amazon Web Services, Facebook, PingCap and more!
The speakers will address the current status of key […]

Read more

A Truly Open Source Database Conference

companies represented by speakers at percona live 2019

Many of our regular attendees already know that the Percona Live Open Source Database Conference is not all about Percona software or, indeed, all about Percona. However, with moving to a new city—Austin, TX— we have realized that it’s something we ought to shout out loud and clear. Our conference really is technology agnostic! […]

Read more

PostgreSQL Updatable Views: Performing Schema Updates With Minimal Downtime

postgres updatable views

Recently, one of our customers asked us how to minimize downtime when upgrading the database structure with changes that are not backwards-compatible. It’s an interesting question and I would like to visit some alternatives here. I will use PostgreSQL for this series of posts and walk through updatable views, INSTEAD OF Triggers, and the […]

Read more

Benchmark PostgreSQL With Linux HugePages

Benchmarking HugePages and PostgreSQL

Linux kernel provides a wide range of configuration options that can affect performance. It’s all about getting the right configuration for your application and workload. Just like any other database, PostgreSQL relies on the Linux kernel to be optimally configured. Poorly configured parameters can result in poor performance. Therefore, it is important that you […]

Read more

Using Partial and Sparse Indexes in MongoDB

MongoDb using partial sparse indexes

In this article I’m going to talk about partial and sparse indexes in MongoDB® and Percona Server for MongoDB®. I’ll show you how to use them, and look at cases where they can be helpful. Prior to discussing these indexes in MongoDB in detail, though, let’s talk about an issue on a relational database like […]

Read more

MongoDB 4.0: Using ACID Multi-Document Transactions

mongodb 4.0 acid compliant transactions

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 way to get closer to the relational world. Well, […]

Read more

Release Candidate for Percona Server 8.0.12-2rc1 Is Available

Percona Server for MySQL 8.0

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 MySQL 8.0.12 and includes all the bug fixes in it. It is a Release Candidate […]

Read more