Percona Resources

Software
Downloads

All of Percona’s open source software products, in one place, to download as much or as little as you need.

Valkey Contribution

Product Documentation

Why Percona for MongoDB?

Why Percona for PostgreSQL?

Percona Blog

Percona Blog

Our popular knowledge center for all Percona products and all related topics.

Community

Percona Community Hub

A place to stay in touch with the open-source community

Events

Percona Events Hub

See all of Percona’s upcoming events and view materials like webinars and forums from past events

About

About Percona

Percona is an open source database software, support, and services company that helps make databases and applications run better.

Percona in the News

See Percona’s recent news coverage, press releases and industry recognition for our open source software and support.

Our Customers

Our Partners

Careers

Contact Us

David Stokes
David Stokes is a Technology Evangelist for Percona Corporation, is the author of MySQL & JSON - A Practical Programming Guide, and resides in Texas.

Percona Toolkit – A Quick Introduction to Summary

Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL, MariaDB, MongoDB, and PostgreSQL server and system tasks that are too difficult or complex to perform manually. You can get summaries of your database servers, or you […]

Putting the Fun in MySQL Functional Indexes

Functional indexes are found in both of Percona’s relational databases, MySQL and PostgreSQL, but they are probably the least used and most understood index type, aside from geospatial. You may also hear this type of index being called Index on expression. So, what is a functional index? Definitions The examples below use MySQL, but it […]

PostgreSQL for MySQL DBAs Episode 13: Inheritance

MySQL users can easily be confused by the seemingly infinite differences between MySQL and PostgreSQL. The good news is that for someone familiar with MySQL, they have the basics of databases covered and can explore some of the treasures to be discovered in the new PostgreSQL environment. One of the interesting facets that you need […]

A Quick Peek at MySQL 8.0.34 and MySQL 8.1.0

This is a Quick Peek at what Oracle delivered with MySQL 8.0.34 and 8.1.0 on July 17th, 2023. MySQL previously released software quarterly as part of a continuous delivery system where new features were made available. Many people loved access to the new features even if they could be risky, but others wanted stability and […]

MySQL 8.0.33 – A Quick Peek

MySQL released version 8.0.33 on April 18th, featuring some attention-catching features.  This blog post is a quick review of the release notes looking for the exciting items, and comments in italics are solely my own. User-defined collations are now deprecated and will be removed in a future version.  This is probably not a show-stopper for […]

Percona Live 2023 Tutorials

Percona Live will be held May 22nd through the 24th in Denver, Colorado. The first day, May 22nd, is devoted to tutorials. These tutorials are intense, high-quality sessions where you can learn new skills.  The list below is incomplete and may be re-arranged as schedules change. The instructors are well-known professionals in the open source […]

PostgreSQL for MySQL DBAs Episode 12: Transactions

Yes, MySQL DBAs can learn PostgreSQL! This series is for those who know MySQL and want to expand their knowledge, see how another database works, or are looking to expand their career horizons. In this episode we will look at transactions. Yes, MySQL with InnoDB does have the ability to perform transactions and this is […]

Database Housekeeping in the New Year

Welcome to 2023! Now it is time to get your databases ready for the rest of the year. First, how are your backups? You need to ensure that you are backing up all the data. Did someone ‘toss a project over the wall’ that needs to be added to the backup procedure? Or did you […]

Why You Need To Keep Track of Bugs

Most of us are lucky that software bugs are a small part of our lives. The ‘things just work’ attitude works for most situations, but occasionally something appears that may seem trivial at first glance may be catastrophic. A bug appeared in MySQL’s recently released 8.0.32 that really caught my attention. This is a prime […]

A Quick Peek at MySQL 8.0.32

Recently Oracle released new versions of their software and there are some things of note. MySQL 8.032 is not a major change but you do need to be aware of some changes just in case they have the potential to send you into the court of Murphy’s Law. So let’s look through the release notes […]

JSON and Relational Databases – Part One

JSON data and relational databases have traditionally been diametric opposites. One is very free form with minimal rules on the formatting and the other is very strict and formal. So many folks were surprised when relational databases started adding a JSON data type to their products. In this multi-part blog series, we will start with […]

PostgreSQL 14 Internals Book

There is an interesting project by the folks at PostgresPro that is translating Egor Rogov’s PostgreSQL 14 Internals into English. This an ongoing project being released as they make progress in providing a great resource to the PostgreSQL Community. Parts I – IV are published and Part V on indexes is on the way. It […]