Percona

MARCH 28, 2023

Repository means the location/path on the server or the cloud where the actual copy of the backup will reside. This attribute helps take the redundant copies of the databases at multiple locations remotely on different servers or locally on the same server. Let’s discuss a few scenarios one by one. Scenarios: 1.

Servers 82

Servers Azure AWS Cloud 82

Dynatrace

JULY 11, 2023

The MOVEit vulnerability is a critical SQL injection flaw in the web application MOVEit Transfer , which MITRE published as CVE-2023-34362 on May 31, 2023. When exploiting the vulnerability, attackers can gain remote code injection capabilities in the MOVEit server and modify or steal sensitive data from its database.

Database 155

Database Government Games Servers 155

Dynatrace

MAY 8, 2023

In fact, the Dynatrace 2023 CIO Report found that 78% of respondents deploy software updates every 12 hours or less. But when and how does DevOps monitoring fit into the process? The process involves monitoring various components of the software delivery pipeline, including applications, infrastructure, networks, and databases.

DevOps 216

DevOps Efficiency Monitoring Infrastructure 216

Percona

AUGUST 18, 2023

Why do you need multiple instances on the same server? You can have a host with two or three instances configured as a delayed replica of the source server with SQL Delay of, let’s say, 24hr, 12hr, and 6/3hrs. You can run multiple instances on a server to test your backups with the correct version and configs.

Programming 84

Programming Servers Database Hardware 84

Percona

OCTOBER 17, 2023

Dynamic WiredTiger tickets As a brief recap, WiredTiger tickets in MongoDB serve as the concurrency control mechanism within the WiredTiger storage engine. That’s very welcome after upgrade/downgrade processes when metadata is touched after FCV change. Without further ado, let’s get started.

Metrics 100

Metrics C++ Storage Database 100

Percona

JUNE 23, 2023

It is a good practice to compress the backups to save costs on storage and to encrypt the backups so those can’t be used if the files are compromised as long as you keep your encryption keys safe! In order to speed up the backup process along with the compression and encryption, we can use multiple threads.

Servers 80

Servers Processing Speed Open Source 80

Dynatrace

SEPTEMBER 8, 2023

SQL Username: Username of the user who has permission to login on the SQL server remotely and access the database. In the below query, we’re specifically searching for pending deposit transactions greater than $8,000 that occurred between 10:00:04 AM and 12:00:00 AM on August 21, 2023. This is used for identification purposes.

Database 266

Database Artificial Intelligence Metrics Monitoring 266

Percona

SEPTEMBER 14, 2023

Once we configured the setup, the ClickHouse server will act as a replica. sec) From the ClickHouse end Make sure you have MySQL port access from the ClickHouse server to the MySQL server. file: /etc/clickhouse-server/users.xml) #vi /etc/clickhouse-server/users.xml <profiles> <default> <!--

Engineering 87

Engineering Database Servers Analytics 87

Percona

NOVEMBER 1, 2023

This blog was originally published in January 2021 and updated in November of 2023. The Recovery Point Objective (RPO) is the duration of time and service level within which a business process must be stored after a disaster in order to avoid unacceptable consequences associated with a break in continuity. From MySQL 5.6

Best Practices 79

Best Practices Storage Strategy Database 79

Brendan Gregg

FEBRUARY 28, 2023

My personal opinion is that I don't see a widespread need for more capacity given horizontal scaling and servers that can already exceed 1 Tbyte of DRAM; bandwidth is also helpful, but I'd be concerned about the increased latency for adding a hop to more memory. The call for participation ends on March 2nd 23:59 SGT!

Performance 110

Performance Latency Cache Virtualization 110

Percona

AUGUST 18, 2023

This blog will explore the hurdles encountered during the upgrade process and the innovative solution that saved the day. 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.

Open Source 66

Open Source Database Storage Engineering 66

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 79

Cloud Open Source Strategy Best Practices 79

Percona

APRIL 7, 2023

If we were to select the most important MySQL setting, if we were given a freshly installed MySQL or Percona Server for MySQL and could only tune a single MySQL variable, which one would it be? Sysbench ran on a third server, which I’ll refer to as the application server (APP).

Tuning 135

Tuning Cache Servers Benchmarking 135

Percona

AUGUST 29, 2023

A single command to deploy the operator would be: kubectl apply -f [link] --server-side Init SQL script Init SQL allows the creation of the database cluster with some initial data in it. In this case, the backups should be stored on some object storage. Please follow our installation instructions and use your favorite way.

Storage 94

Storage Database Media Open Source 94

Percona

JULY 24, 2023

PBM) introduced a GA version of incremental physical backups , which can greatly impact both the recovery time and the cost of backup (considering storage and data transfer cost). Snapshot backup/restore Technical Preview As already promised during Percona Live 2023, it’s my pleasure to deliver on that promise.

Availability 75

Availability Open Source Strategy Storage 75

Percona

MAY 15, 2023

In both cases, when using virtually-synchronous replication, the process will require certification from each node and local (by node) write; as such, the number of writes is NOT distributed across multiple nodes but duplicated. Because the solutions still rely on writing in one single node that works as Primary. The POC Why this POC?

Traffic 123

Traffic Scalability Database Servers 123

Percona

AUGUST 17, 2023

In another survey, using multiple metrics for overall popularity, PostgreSQL ranks as the fourth most popular database management system ( DB-Engines, March 2023 ). Craig Kerstiens, crunchydata, August 2023 ) That evolution has created lots of reasons for its expanding popularity. Again, more on extensions and configurations later.)

Open Source 78

Open Source Healthcare Social Media Database 78

Percona

APRIL 10, 2023

In March 2023, we discovered an issue with physical backups, which, under certain conditions, can cause the restore to fail ( PBM-1058 ). or earlier, and your dbPath contains a trailing slash (for example dbPath is /var/lib/mongodb/), the backup process fails to correctly trim the dbPath from the file path. With PBM v2.0.0,

Open Source 76

Open Source Storage Availability Processing 76

Percona

JUNE 6, 2023

This blog was originally published in January 2012 and was updated in June 2023. Advantages of full backups Full backups provide several benefits in terms of safeguarding data and facilitating recovery processes, as they encompass thorough data replication and enable complete system restoration during critical situations.

Storage 68

Storage Strategy Network Efficiency 68

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). MariaDB Server, on the other hand, is a fork of MySQL 5.5.

Open Source 52

Open Source Servers Storage Scalability 52

Percona

JULY 7, 2023

In general terms, to achieve HA in PostgreSQL, there must be: Redundancy: To ensure data redundancy and provide continuous performance when a primary server fails, multiple copies of the database reside in replica servers. When the primary server fails, a standby server takes over as the new primary.

Availability 83

Availability Open Source Architecture Database 83

Brendan Gregg

FEBRUARY 28, 2023

My personal opinion is that I don't see a widespread need for more capacity given horizontal scaling and servers that can already exceed 1 Tbyte of DRAM; bandwidth is also helpful, but I'd be concerned about the increased latency for adding a hop to more memory. It was a great privilege.

Performance 52

Performance Latency Cache Virtualization 52

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. Sharding in MongoDB is a technique used to distribute a database horizontally across multiple nodes or servers, known as “shards.” MongoDB distributes data across these shard servers to ensure an even distribution.

Best Practices 71

Best Practices Traffic Database Servers 71

Percona

OCTOBER 18, 2023

It’s a complex process involving various factors and meticulous planning. Today, we’ll be taking a deep dive into the intricacies of database migration, along with specific solutions to help make the process easier. In this section, we’ll outline the essential steps involved in migrating to open source databases.

Open Source 91

Open Source Database Hardware Strategy 91

Percona

JULY 2, 2023

This blog was originally written in September 2018 and was updated in June 2023. Having a backup strategy in place that takes regular backups and has secure storage is essential to protect the database in an enterprise-grade environment to ensure its availability in the event of failures or disasters.

Strategy 52

Strategy Database Storage Open Source 52

Percona

SEPTEMBER 1, 2023

This post was originally published in June 2020 and was updated in September 2023. A finely tuned database processes queries more efficiently, leading to swifter results. Reduced Resource Usage Optimizing resource-intensive queries and configurations can lead to a reduced burden on your server.

Tuning 52

Tuning Database Performance Hardware 52

Percona

JULY 1, 2023

This post was originally published in July 2018 and was updated in July 2023. For those with applications already built on MySQL or PostgreSQL, migrating to Aurora is a straightforward process requiring minimal code changes, as it supports the same protocols, tools, and drivers. What are the differences between Aurora and RDS?

AWS 52

AWS Database Serverless Storage 52

Percona

MAY 2, 2023

This blog was originally published in September 2020 and was updated in May 2023. The speed of backup also depends on allocated IOPS and type of storage since lots of read/writes would be happening during this process. In today’s data-driven world, losing critical data can be catastrophic for any organization.

Best Practices 52

Best Practices Database Storage Servers 52

Speed Curve

FEBRUARY 25, 2024

Guest profiles also start with empty caches, empty cookie stores, empty browser storage, etc. These may get populated during testing, but we can clear them at any time via Application > Storage > Clear Site Data in DevTools. Opening a guest profile in Chrome 2. Does the stylesheet need to be injected?

Analytics 91

Analytics Processing Google Mobile 91

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. Otherwise, the storage engine does a scatter-gather and queries ALL partitions in a UNION that is not concurrent. This method distributes data evenly across partitions to achieve balanced storage and optimal query performance.

Strategy 40

Strategy Storage Database Best Practices 40

Percona

JULY 15, 2023

This blog was originally published in January 2022 and was updated in July 2023. They are a roadmap that speeds up the process of finding specific rows in a large table. The process of crafting indexes involves a trade-off between improved data retrieval speed and impact on data modification operations.

Virtualization 77

Virtualization Speed Database Efficiency 77

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. Hardware optimization : You need to ensure that the CPU, memory, and storage components meet the performance requirements of the database workload. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload.

Tuning 52

Tuning Efficiency Database Performance 52

Enprowess

JANUARY 12, 2022

Convenient Debugging : Debugging process is easy for the developers as single page application SPA offer developers tools. Other benefits: It has other benefits like a Quicker launch to the market, Easier distribution, saving device power and storage, seamless maintenance, and updating. Famous PWA Use Examples. API- First Approach.

Blockchain 59

Blockchain IoT Development Serverless 59

Testsigma

JUNE 5, 2021

billion people are projected (by 2023) to keep this small device in their pockets and use it daily. There are two main reasons why people keep mobile browsers installed in their system even after storage issues. Their maintenance is easier and upgrading, updating, or discarding them from the server is a simple task.

Mobile 52

Mobile Testing Website Testing Tools 52

O'Reilly

JULY 25, 2023

Here’s how I worked on it: I subscribed to ChatGPT Plus and used the GPT-4 model in ChatGPT (first the May 12, 2023 version, then the May 24 version) to help me with design and implementation. And since this setup process was so new to me, I had a hard time thinking about how to phrase my questions.

Programming 98

Programming Code Design Benchmarking 98