Percona

JUNE 26, 2023

We have faced different levels of corruption related to databases in PostgreSQL. Though it is not at all recommended to touch the / data / base / directory and go through files under this / var / lib / postgresql / 14 / main / base / , however, sometimes it happens.

Hardware 75

Hardware C++ Database Open Source 75

Percona

SEPTEMBER 25, 2023

PostgreSQL is a powerful and popular open source relational database management system. Ensuring the safety of your PostgreSQL data through regular backups is an important concern for database administrators. The /etc/pgbackrest/pgbackrest.conf file contains crucial information related to our primary database server.

Database 95

Database Open Source Storage Servers 95

Percona

NOVEMBER 30, 2023

This blog describes how to encrypt the pgBackRest repository. pgBackRest is the backup tool used to perform Postgres database backup, restoration, and point-in-time recovery (PITR). The repository is where pgBackRest stores backups and archives WAL segments. The repository is where pgBackRest stores backups and archives WAL segments.

Open Source 79

Open Source Database Processing Performance 79

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 has default settings for all of the database parameters. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload.

Tuning 52

Tuning Efficiency Database Performance 52

Percona

OCTOBER 3, 2023

In database management, job scheduling has always played an important role. However, there is another job scheduler called pg_timetable, which is completely database-driven and provides a couple of advanced concepts. In this blog, we are going to highlight some of the main features, installation, and some use cases of pg_timetable.

Open Source 78

Open Source Database Servers Programming 78

Percona

AUGUST 18, 2023

This blog describes how to configure systemd for multiple instances of MySQL. Why not just create another database on the same instance? We split databases by function/team to give each team full autonomy over their schema, And if someone screws up, it breaks their cluster, not all databases.

Programming 84

Programming Servers Database Hardware 84

Percona

DECEMBER 12, 2023

This blog gives you some ideas on using pt-table-sync for replica tables with triggers. sec) mysql> select * from test_tab; select * from test_tab_log; + -+ --+ + | id | test_data | op_time | + -+ --+ + | 1 | lt1 | 2023-11-26 09:59:19 | + -+ --+ + 1 row in set (0.00 We have two tables: test_tab and test_tab_log.

Servers 91

Servers Database Testing Open Source 91

Percona

SEPTEMBER 19, 2023

This type of backup is suitable for large, important databases that need to be recovered quickly when problems occur. Physical backups are the backups that consist of raw copies of the directories and files that store database contents. Copyright (c) 2016, 2023, Oracle and/or its affiliates. Type 'help' or '?'

C++ 105

C++ Servers Storage Speed 105

Official Blog - World Web Technology

JUNE 13, 2023

It is the most popular CMS that was earlier used to create personal blogs. However, dedicated WordPress theme developers have made the platform so advanced that businesses look up to WordPress when they want to develop a wide range of web applications such as ecommerce websites, business websites, personal blogs, web applications, etc.

Development 52

Development Website Ecommerce Code 52

Official Blog - World Web Technology

APRIL 12, 2023

Because WordPress is one of the most preferred content management systems to develop highly user-friendly, competitive, and dynamic websites. WordPress is a comprehensive content management system with thousands of free and paid themes and plugins to develop a full-fledged website or web app. Why WordPress?

Development 52

Development Website Ecommerce Programming 52

Percona

MAY 2, 2023

This blog was originally published in September 2020 and was updated in May 2023. As a MongoDB user, it’s crucial to ensure that your data is safe and secure in the event of a disaster or system failure. 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 20, 2023

In this blog post, we will go through the process of InnoDB buffer pool resizing online, covering why it is important to monitor its progress and how to monitor it. 2023-12-05T16:51:29.610886Z 65 [Note] [MY-012398] [InnoDB] Requested to resize buffer pool. Importance of monitoring the InnoDB buffer pool resize Since MySQL 5.7.5,

Monitoring 88

Monitoring Code Open Source Cache 88

Percona

JUNE 2, 2023

WordPress, the ubiquitous publishing platform that launched millions of blogs and websites, turned 20 on May 27th. While not the first open source content management system (CMS), WordPress caught on like nothing before and helped spread open source to millions. MySQL was the database for phpWebLog, for example, way back in 2000.

Open Source 96

Open Source Traffic Tuning Database 96

Percona

JULY 17, 2023

MongoDB Community Edition software might set the stage for achieving your high-volume database goals, but you quickly learn that its features fall short of your enterprise needs. First, some stage-setting for this blog article. The popularity of MongoDB MongoDB has emerged as a popular database platform. It ranks No.

Open Source 75

Open Source Database Scalability Software 75

Percona

AUGUST 30, 2023

In this blog, I am trying to list the options available for users and list them in increasing order of priority. This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. cat /usr/lib/systemd/system/postgresql-14.service. And there could be conflicts.

Database 103

Database Servers Open Source Tuning 103

Dynatrace

JUNE 8, 2022

Added deeper insight into IBM DB2 database calls by fetching the full SQL statements from the DB2 catalog. Operating systems. Future Dynatrace OneAgent operating systems support changes. The following operating systems will no longer be supported starting 01 July 2022. Added AWS Lambda Functions tracing for.NET.

Java 154

Java Operating System Lambda Serverless 154

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

OCTOBER 31, 2023

Percona has a mission to provide the best open source database software, support, and services so our users can innovate freely. The feedback from users was that “backup management is a must ” and “we need something that allows us to manage all of our database backups in one place, not server by server.”

Open Source 90

Open Source Database Operating System Programming 90

Percona

APRIL 6, 2023

In this blog post, we’ll check how to integrate Percona Monitoring and Management (PMM) with Loki to be able to get not only metrics and queries from our database servers but also text-based information like logs. Mar 15 19:02:59 ps promtail[2318]: level=info ts=2023-03-15T19:02:59.437567482Z caller=filetargetmanager.go:352

Monitoring 86

Monitoring Servers Metrics Database 86

Percona

MARCH 28, 2023

Our previous blogs discussed configuring and setting up backups using the pgBackRest solution. To briefly explain pgBackRest, it is an open source backup tool that takes FULL Backup, Incremental Backup, and Differential Backup for PostgreSQL databases. >pgBackRest is installed and configured on a dedicated backup and database host.

Servers 82

Servers Azure AWS Cloud 82

Percona

AUGUST 29, 2023

Data redundancy, a database version of a RAID Pondering the case of high availability and redundancy, one replicates data by creating a replica via streaming replication. Extension citus has been created in database db01. Now let’s stretch our imagination and consider a second method of high availability, ala Citus.

C++ 79

C++ Database Storage Testing 79

Percona

SEPTEMBER 27, 2023

First, we will need to install the OS with the necessary control files for the appropriate PostgreSQL version for installing pg_partman on the database. Installation of pg_partman on the database I recommend creating the schema before creating the extension to install the extension’s objects.

Storage 101

Storage Open Source Database Efficiency 101

Percona

APRIL 13, 2023

PostgreSQL is a popular open source relational database management system that is widely used for storing and managing data. In this blog, we will discuss what replication lag is, why it occurs, and how to mitigate it in PostgreSQL. Various factors, such as the distance between the databases, network congestion, etc.,

Latency 81

Latency Tuning Open Source Network 81

Percona

AUGUST 18, 2023

This blog will explore the hurdles encountered during the upgrade process and the innovative solution that saved the day. uses the Aria engine for system tables. 2023-05-12T08:10:38.946611Z 1 [ERROR] [MY-013894] [InnoDB] Found redo log file./ib_logfile0 The incompatibility roadblock MariaDB 10.4 and MySQL 8.0.

Open Source 66

Open Source Database Storage Engineering 66

Percona

JUNE 23, 2023

In Percona Managed Services , one key aspect of managing the databases is configuring backups. Percona XtraBackup is one of the best tools for performing physical database backups. From the processlist: | 2495984 | system user | | percona | Connect | 240221 | Waiting for backup lock | CREATE TABLE IF NOT EXISTS `percona`.`heartbeat`

Servers 80

Servers Processing Speed Open Source 80

Percona

DECEMBER 19, 2023

In this blog post, we will talk about the steps to configure alerts for some well-known communication platforms like Telegram , Slack , and WebHook. They are widely used in web development, APIs, and cloud services to create more dynamic and responsive systems. Webhooks are commonly employed for sending notifications.

Monitoring 90

Monitoring Database Open Source Java 90

Dynatrace

DECEMBER 18, 2023

For busy site reliability engineers, ensuring system reliability, scalability, and overall health is an imperative that’s getting harder to achieve in ever-expanding, cloud-native, container-based environments. According to the 2023 Kubernetes in the Wild report , 65% of organizations use Prometheus. What is Prometheus?

Metrics 175

Metrics Engineering Energy Tuning 175

Percona

MAY 16, 2023

As a database administrator, have you ever been in a situation when your database confronted a brute force attack? This plugin also exposes system variables that enable its operation to be configured and a status variable that provides rudimentary monitoring information. sec) # Now you can see the values are reset!

Servers 119

Servers Database Monitoring Testing 119

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.

Best Practices 90

Best Practices Tuning Database Testing 90

Percona

JUNE 7, 2023

Triggers on Data Definition Language (DDL) events are a powerful feature of PostgreSQL that allows you to perform additional actions in response to changes to the database schema. DDL events include operations such as CREATE, ALTER, and DROP statements on tables, indexes, and other database objects.

Database 76

Database Best Practices Open Source C++ 76

Dynatrace

AUGUST 9, 2023

In this blog post, we’ll use Dynatrace Security Analytics to go threat hunting, bringing together logs, traces, metrics, and, crucially, threat alerts. For the demonstration in this blog post, we want to deploy Unguard in AWS EKS and hunt for attacks within that environment. It also generates  OpenTelemetry  traces.

Analytics 192

Analytics AWS Strategy Infrastructure 192

CSS Wizardry

JULY 23, 2023

Furthermore, they add: Google’s core ranking systems look to reward content that provides a good page experience. Page Experience report There are also URL Groups and larger groupings of URL data: Our core ranking systems generally evaluate content on a page-specific basis […] However, we do have some site-wide assessments.

Engineering 246

Engineering Google Speed Mobile 246

Percona

DECEMBER 5, 2023

Recently, I was reading a brilliant blog by Perconian David Gonzalez titled The 1-2-3 for PostgreSQL Logical Replication Using an RDS Snapshot , exploring the intricacies of setting up logical replication on Amazon RDS using RDS snapshots.

Database 77

Database Traffic C++ Servers 77

Percona

MARCH 28, 2023

In this blog post, we will dive deep into WiredTiger’s Logging and Checkpoint mechanism. Every database system has to ensure durability and reliability. MongoDB uses classic Write-Ahead-Logging (WAL) using Journals and Checkpoints. Starting with the basics, why is WAL needed in the first place?

Hardware 88

Hardware C++ Storage Cache 88

Scalegrid

FEBRUARY 15, 2024

In a world where data security is essential, enabling MongoDB SSL is critical in fortifying your database. Each section is crafted to elevate your database’s security protocol, from acquiring the necessary SSL certificates to configuring server and client connections.

Servers 130

Servers Best Practices Government Network 130

Percona

SEPTEMBER 12, 2023

If the changes are not made considering the necessary precautions, you may face unwanted outages on the database that can cause serious problems to your business. In this blog post, I will delve into the most important things to consider while preparing a schema change. Quickly Troubleshoot Metadata Locks in MySQL 5.7

Database 87

Database Traffic Open Source Monitoring 87

Adrian Cockcroft

FEBRUARY 9, 2023

Picture by Adrian — Ka’anapali sunset 2023 There’s been a lot of discussion about platforms recently, I talked about why I think it’s a current hot meme on the WTF Podcast with Charles Humble recently, and Sam Newman just wrote a blog post “ Don’t call it a platform ”.

Engineering 137

Engineering Serverless Lambda AWS 137