Percona

DECEMBER 29, 2023

Not everything can be addressed on the database side. Human factor: In an ideal case, there must be stringent restrictions and enforcement on what load and number of connections can be onboarded to the Database. App-Dev often demands unrestricted, uncontrolled access to the database. However, gatekeeping is not an easy job.

Servers 82

Servers Database C++ Airlines 82

Percona

MAY 2, 2023

This blog was originally published in September 2020 and was updated in May 2023. That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. That’s why it’s essential to implement the best practices and strategies for MongoDB database backups.

Best Practices 52

Best Practices Database Storage Servers 52

Percona

JULY 24, 2023

While AWS EBS snapshots were mentioned the most, the likes of persistent disk snapshots on GCP, Azure-managed disk snapshots, or local storage, as well as k8s snapshot capabilities, were also playing a crucial part in the backup strategies. I am happy to announce that with PBM 2.2.0, Now why Technical Preview, you may ask?

Availability 77

Availability Open Source Strategy Storage 77

Percona

DECEMBER 19, 2023

Setting up Percona Monitoring and Management (PMM) alerts for multiple channels can significantly enhance your monitoring strategy. Percona Monitoring and Management is a best-of-breed open source database monitoring solution. Please note that I am not covering the basic alerting and configuration setup.

Monitoring 92

Monitoring Database Open Source Java 92

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. It has default settings for all of the database parameters. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. What is PostgreSQL performance tuning?

Tuning 52

Tuning Efficiency Database Performance 52

Dynatrace

DECEMBER 18, 2023

According to the 2023 Kubernetes in the Wild report , 65% of organizations use Prometheus. Another source reported a 43% overall increase in Prometheus adoption for the last six months of 2021. As part of our observability engineering strategy, we want that data as well and to make sure it gets sent to Dynatrace.

Metrics 175

Metrics Engineering Energy Tuning 175

Dynatrace

AUGUST 9, 2023

Falco is an open-source, cloud-native security tool that utilizes the Linux kernel technology  eBPF , to generate fine-grained networking, security, and observability events. With a conventional database, a query that scans millions of records would take many seconds to complete and require that we structure our queries up front.

Analytics 192

Analytics AWS Strategy Infrastructure 192

Percona

JULY 6, 2023

Performance is one of the essential aspects of a database management system. One way to verify a column’s number of distinct values is by querying the pg_stats view in our database. One of the most effective ways to tackle performance improvement is having the proper indexes for the table columns. Next is the table definition.

Best Practices 92

Best Practices Tuning Database Testing 92

Percona

DECEMBER 5, 2023

Inspired by David’s insights, I embarked on a journey to explore logical replication from a different perspective – within the realm of on-premises server databases. Also, it is a helpful method for version upgrades since the target database can run on a different (minor or major) PostgreSQL version. to PostgreSQL v15.4.

Database 78

Database Traffic C++ Servers 78

Percona

JULY 1, 2023

This post was originally published in July 2018 and was updated in July 2023. Now that Database-as-a-service (DBaaS) is in high demand, there are multiple questions regarding AWS services that cannot always be answered easily: When should I use Aurora and when should I use RDS MySQL ? What are the differences between Aurora and RDS?

AWS 52

AWS Database Serverless Storage 52

Percona

JUNE 6, 2023

This blog was originally published in January 2012 and was updated in June 2023. Therefore, establishing a strong backup strategy is essential to ensure data security and minimize potential disruptions. In order to implement effective full backups of your database, you must follow some best practices. What is a full backup?

Storage 69

Storage Strategy Network Efficiency 69

Percona

NOVEMBER 1, 2023

This blog was originally published in January 2021 and updated in November of 2023. As businesses and applications increasingly rely on MySQL databases to manage their critical data, ensuring data reliability and availability becomes paramount. What is the Recovery Time Objective?

Best Practices 80

Best Practices Storage Strategy Database 80

Percona

DECEMBER 21, 2023

The efficiency of database queries in MySQL can make all the difference in the performance and responsiveness of applications. A Query Execution Plan is the way a database chooses to run a specific query. Before looking at the problematic query, I will walk you through a little detail about the optimizer.

Efficiency 106

Efficiency Database Open Source Performance 106

Smashing Magazine

AUGUST 3, 2023

How We Optimized Performance To Serve A Global Audience How We Optimized Performance To Serve A Global Audience Liran Cohen 2023-08-03T10:00:00+00:00 2023-08-03T13:06:00+00:00 I work for Bookaway , a digital travel brand. A cornerstone of our business model lies in the development of effective landing pages. SEO is key to our success.

Performance 74

Performance Cache Traffic Metrics 74

Percona

SEPTEMBER 1, 2023

This blog was originally published in November 2021 and was updated in September 2023. MySQL triggers are a powerful tool for database administrators and developers, enabling them to automate tasks, enforce data consistency, and respond to events within the database seamlessly. What is a Trigger in MySQL?

Cache 62

Cache Database Games Healthcare 62

O'Reilly

NOVEMBER 28, 2023

Generative AI has been the biggest technology story of 2023. As of November 2023: Two-thirds (67%) of our survey respondents report that their companies are using generative AI. 16% of respondents working with AI are using open source models. A few have even tried out Bard or Claude, or run LLaMA 1 on their laptop.

Open Source 108

Open Source Artificial Intelligence Google Infrastructure 108