Percona

DECEMBER 27, 2023

As we at Percona wind down 2023 and look into what the next year holds, our attention is drawn to the cloud-native landscape and how it is maturing, growing, and evolving. KubeCon NA 2023 recap The theme for KubeCon NA was very clear — AI and Large Language Models (LLMs). We expect that number to rise higher in 2024.

Cloud 78

Cloud Open Source Strategy Best Practices 78

Percona

SEPTEMBER 1, 2023

This post was originally published in June 2020 and was updated in September 2023. MySQL performance tuning offers several significant advantages for effective database management and optimization. Enhanced Database Efficiency By adjusting configuration settings, you can markedly enhance the overall efficiency of your MySQL database.

Tuning 52

Tuning Database Performance Hardware 52

Dynatrace

OCTOBER 17, 2023

Meanwhile, the greatest IT operations challenge for enterprises in 2023 was automating as many operations as possible, cited by 66% of respondents. Each team had its favorite tool—whether for networking, development, or database management—and Odigo needed to centralize. “We Odigo instituted a schedule for decommissioning tools.

Innovation 186

Innovation Monitoring Network Strategy 186

Percona

NOVEMBER 8, 2023

According to the official PostgreSQL versioning policy page , the final PostgreSQL 11 release is expected by November 9, 2023. We encourage our users and customers to adopt upgrade strategies in line with the PostgreSQL Community timelines. This version brings some very welcome improvements to replication, monitoring, and more.

Strategy 74

Strategy Database Availability Monitoring 74

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

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

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 79

Servers Database C++ Airlines 79

Percona

AUGUST 18, 2023

2023-05-12T08:10:38.946611Z 1 [ERROR] [MY-013894] [InnoDB] Found redo log file./ib_logfile0 2023-05-12T08:10:38.946683Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2023-05-12T08:10:39.374389Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine. and MySQL 8.0.

Open Source 66

Open Source Database Storage Engineering 66

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

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 88

Best Practices Tuning Database Testing 88

Dynatrace

AUGUST 9, 2023

1 config: # as of 2023-08-02, this feature is still a pre-release so we # have to manually override the environment variables for now extraEnv: - name: DYNATRACE_APITOKEN value: dt0c01.EXAMPLE_TOKEN_REPLACE_THE_ENTIRE_STRING htaccess", "/.ssh", Indeed, it did find some reconnaissance attempts!

Analytics 201

Analytics AWS Strategy Infrastructure 201

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 88

Monitoring Database Open Source Java 88

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,

Availability 75

Availability Open Source Strategy Storage 75

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 78

Best Practices Storage Strategy Database 78

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 67

Storage Strategy Network Efficiency 67

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 76

Database Traffic C++ Servers 76

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables but still gets treated as a single table by the SQL layer. These benefits collectively contribute to a more efficient database environment.

Strategy 40

Strategy Storage Database Best Practices 40

Dynatrace

DECEMBER 18, 2023

According to the 2023 Kubernetes in the Wild report , 65% of organizations use Prometheus. An essential observability engineering tool Prometheus is an open-source telemetry database service that records and stores custom software metrics and provides a standardized interface to pull (in Prometheus terms, “scrape”) data using HTTP requests.

Metrics 183

Metrics Engineering Energy Tuning 183

Percona

FEBRUARY 24, 2023

As a result, it becomes increasingly important to protect the confidentiality of information to prevent data leaks and facilitate easy access to relevant data sources and tools for the related teams without having to sift through unrelated databases or environmental data. As a first task, Vanessa plans an access control roll-out strategy.

Metrics 105

Metrics Monitoring Database Engineering 105

Percona

SEPTEMBER 1, 2023

This blog was originally published in February 2019 and was updated in September 2023. Web applications rely on databases to run the internet, powering everything from e-commerce platforms to social media networks to streaming services. This affects the type and range of characters that can be inserted into the column.

Performance 52

Performance Storage Social Media Database 52

Smashing Magazine

OCTOBER 2, 2023

for the web app, Sanity CMS, Firebase Auth, and Firestore database. Definitely read up on the strategy and reasoning behind this stack in the first article if you missed it. We used an eager loading strategy paired with a high fetchpriority on the images. After scrolling the video category page, a bunch more images are loaded.

Cache 72

Cache Strategy Best Practices Design 72

Percona

AUGUST 15, 2023

This blog was originally published in February 2017 and was updated in August 2023. MySQL replication is a process in which data from a primary MySQL database is copied and sent to one or more secondary databases, known as replicas. It also enables geographically distributed databases for disaster recovery.

Servers 52

Servers Database Availability Traffic 52

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. If we asked whether their companies were using databases or web servers, no doubt 100% of the respondents would have said “yes.” of users and 3.9%

Open Source 106

Open Source Artificial Intelligence Google Infrastructure 106

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 101

Efficiency Database Open Source Performance 101

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. To address this, we adopted a strategy known as stale-while-revalidate. SEO is key to our success.

Performance 74

Performance Cache Traffic Metrics 74

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. Database architects working with MongoDB encounter specific challenges related to database systems and system growth. In a sharded cluster, each shard acts as an independent database responsible for storing and managing specific data.

Best Practices 71

Best Practices Traffic Database Servers 71

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 60

Cache Database Games Healthcare 60

Percona

AUGUST 1, 2023

If you plan to migrate your database from on-prem servers to RDS (either Aurora or MySQL RDS), you usually don’t have much choice but to do so using logical backups such as mysqldump, mysqlpump, mydumper , or similar. which we don’t recommend as the EOL is October 31, 2023!!) Hello friends! or MariaDB 10.X or MariaDB 10.X

AWS 70

AWS Servers Engineering Strategy 70