Featured
Percona Products
Percona Services
Use Cases
Matt YonkovitAwesome news, pg_stat_monitor has reached a GA STATUS! Percona has long been associated with pushing the limits and understanding the nuances involved in running database systems at scale, so building a tool that helps get us there brings a bit more insight and details around query performance and scale on PostgreSQL systems fits with our […]
Percona Live 2022 is comin’ in hot as May 16-18 draws near. This year, we will be supercharging open source conversations, community, and expertise by welcoming the best and brightest open source database users to Austin, Texas for three days of knowledge sharing. Have a unique perspective on open source database tech? Percona Live attendees […]
I have had a lot of conversations with people interested in participating in Percona Live this year, but are looking for ideas on what talks or tutorials to submit. I decided to put together a list of topics I think would make great sessions and topics I have heard you in the community ask about. […]
Hello everyone! The new year is upon us and we are looking at planning some awesome new features, enhancements, and ideas in 2022. One of the things we could really use your help on, however, is providing us with feedback on how we are doing and what we can do to improve our database products. […]
With modern application design, systems are becoming more diverse, varied and have more components than ever before. Developers are often forced to become master chefs adding the ingredients from dozens of different technologies and blending them together to create something tasty and amazing. But with so many different ingredients, it is often difficult to understand […]
A few weeks ago we did a live stream talking about Percona Monitoring and Management (PMM) and showcased some of the fun things we were doing at the OSS Summit. During the live stream, we tried to enable some custom queries to track the number of comments being added to our movie database example. We […]
Don’t miss the great overview of PostgreSQL 14 that Umair Shahid recently put together, PostgreSQL 14 – Performance, Security, Usability, and Observability! Range data types have been in Postgresql for some time now, however, as of PostgreSQL 14, we have seen the introduction of multi-range data types. Before we cover that, let’s cover the basics […]
As previously mentioned here on the blog, PostgreSQL 14 was just released. Need a primer? Umair Shahid recently put together a great overview, PostgreSQL 14 – Performance, Security, Usability, and Observability. I recently did a deep-dive into using JSON from within PostgreSQL in a two blog post series titled Storing and using JSON within PostgreSQL, […]
We explored the basic functionality of JSON within PostgreSQL in Part One of this series. Now we will look a little deeper into some things we may want to use regularly. Most of the functionality we talked about in part one works well when you have a simple JSON format. However, in real life, our […]
Continuing our series on storing JSON directly within your database, we are now looking at the JSON functionality built into PostgreSQL. You can see the first two posts in this series exploring MySQL’s JSON functionality with Storing JSON in Your Databases: Tips and Tricks For MySQL Part One and Storing JSON in Your Databases: Tips […]
JSON Structure, The Next Generation (Performance, Scale, and Fun) Now you know the basic JSON functionality available to you, as covered in part one of this series. Let’s look deeper into performance, scale, and oddities that may occur. You can do almost anything you could do in SQL with standard data types and objects, but […]
Database architecture and design are becoming an increasingly lost art. With new technologies and the push towards faster development cycles, people continue to take shortcuts, often to the detriment of long-term performance, scalability, and security. Designing how your application stores, accesses, and processes data is so fundamentally important, it can not be overlooked. I want […]
Lessons Learned – Learning from those who blazed the trail! Another cool thing I like about attending conferences is learning from how other companies and people overcame problems, how they run their systems, and figure out problems that I may run into in the future. Secretly I also want to validate how I have done […]
I love learning from others and exploring the implementation details other database engines provide. Percona Live has no shortage of new databases, tools, and discussions on interesting new features or ways of tackling old problems. I went through the agenda and wanted to highlight a few new databases and tools (new to me or new […]
We are in the “home stretch” for Percona Live and I am continuing to highlight some of the great content out there! Today I would like to focus on content I think will be very interesting to the developers and contributors who are working on the core elements of open source database projects. We have […]
Great news! Percona’s Community-focused podcast, hosted by none other than the HOSS (Head of Open Source Software) himself (yeah, that is me), is now available on almost all podcast platforms. What? You didn’t know we had a podcast? We do, and we’ve had some great episodes since we started in January. In fact, we just […]
I have talked extensively about the DBA’s evolving role and how many DBA’s and operations professionals are now becoming SRE’s (site reliability engineers) or DBRE’s (database reliability engineers). Often, databases get blamed as the bottleneck for application slowdowns and issues, so DBAs have had to develop the skills needed to chase problems up and down […]
A few weeks ago I sat down and talked about tuning MongoDB memory settings with Mike Grayson, one of our MongoDB Database Engineers here at Percona. If you have not seen the video I would recommend it. Since then I have heard from people in the community about other topics they would like to see. […]
If you have not heard, this weekend is FOSDEM. FOSDEM this year is virtual (and open to all), and it looks like it is going to be an absolutely stellar lineup of open source content. The details: February 6-7th, 2021, with over 600 speakers, over 700 sessions, and 113 tracks! So much to see. […]
Something new and exciting this year for Percona Live ONLINE is the inclusion of “Community Rooms”. Every year we struggle with fitting in as many sessions as we can into Percona Live. As the largest open-source database conference, we want to be inclusive of as many different projects and database technologies as possible. We recognize […]