Percona

OCTOBER 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. Today, we’ll be taking a deep dive into the intricacies of database migration, along with specific solutions to help make the process easier.

Open Source 89

Open Source Database Hardware Strategy 89

Percona

FEBRUARY 2, 2023

Database security is crucial to protecting sensitive information stored in a database. A critical aspect is authentication, which refers to verifying the identity of a user trying to access the database. PostgreSQL server authentication refers to verifying the identity of a user trying to connect to the PostgreSQL server.

Database 121

Database Servers Testing Programming 121

Percona

MARCH 30, 2023

The use of open source databases has increased steadily in recent years. Past trepidation — about perceived vulnerabilities and performance issues — has faded as decision makers realize what an “open source database” really is and what it offers. What is an open source database?

Open Source 73

Open Source Database Storage Scalability 73

Percona

OCTOBER 19, 2023

In this guide, we will demonstrate how to establish a Citus database spanning multiple nodes by using Percona Distribution for PostgreSQL. This setup empowers your database to efficiently manage increased data volumes, enhance performance, and maintain availability. Use the following procedure for all the three nodes. 1ubuntu1~20.04.1)

Scalability 82

Scalability Database Open Source Traffic 82

Percona

AUGUST 2, 2023

Restoring a MySQL database backup is a crucial task that can sometimes be time-consuming, especially for large databases. Linux native Input/Output (I/O) statistics Pipe viewer utility By following these approaches, we can effectively monitor the restoration process and manage your MySQL database restoration efficiently.

Database 80

Database Monitoring C++ Speed 80

Percona

NOVEMBER 13, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Download the Updated Release of Percona Distribution for PostgreSQL 16.0 Take a look.

Innovation 83

Innovation Open Source Scalability Database 83

Percona

APRIL 17, 2023

Note that the intent of tuning the settings is not exclusively about improving performance but also enhancing the high availability and resilience of the MongoDB database. The Linux default is usually 60 , which is not ideal for database usage. Spoiler alert: This post focuses on MongoDB 3.6.X

Best Practices 52

Best Practices Design Tuning Database 52

Percona

OCTOBER 31, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Download Percona Monitoring and Management 2.40.1 Take a look. was released.

Monitoring 76

Monitoring Open Source Scalability Database 76

Percona

DECEMBER 18, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Download Percona Monitoring and Management 2.41.0 Take a look.

Monitoring 84

Monitoring Open Source Servers Scalability 84

Dynatrace

OCTOBER 7, 2021

This means you no longer have to provision, scale, and maintain servers to run your applications, databases, and storage systems. Instead of worrying about infrastructure management functions, such as capacity provisioning and hardware maintenance, teams can focus on application design, deployment, and delivery. Compute services.

Serverless 286

Serverless AWS Lambda Storage 286

Percona

AUGUST 21, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Download Percona Monitoring and Management 2.39.0 Download Percona Server for MySQL 5.7.43-47

Open Source 81

Open Source AWS Servers Database 81

High Scalability

FEBRUARY 17, 2021

This article is to simply report the YCSB bench test results in detail for five NoSQL databases namely Redis, MongoDB, Couchbase, Yugabyte and BangDB and compare the result side by side. I have used latest versions for each NoSQL DB and have followed the recommendations to run all the databases in optimized conditions. Load and 2.

Benchmarking 308

Benchmarking Latency C++ Database 308

Percona

JULY 1, 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 we should really compare is the MySQL and Aurora database engines provided by Amazon RDS. How do I choose which one to use?

AWS 52

AWS Database Serverless Storage 52

Percona

OCTOBER 2, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Download Percona Distribution for MySQL (PS-based variation) 8.0.34 Take a look.

Open Source 77

Open Source Scalability Database Servers 77

Percona

OCTOBER 16, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. you can now use an external VictoriaMetrics database for monitoring in PMM. Take a look.

Servers 73

Servers Monitoring Open Source Scalability 73

Percona

SEPTEMBER 1, 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. Experiencing database performance issues?

Tuning 52

Tuning Database Performance Hardware 52

Percona

DECEMBER 18, 2023

These days, there’s been a lot of talk in the industry about setting up one’s database system on PostgreSQL. Most times, these are Greenfield projects where the bulk of the effort is on its design and architecture. Database migration, a POC in action Objective Perform a database migration from MySQL to PostgreSQL.

Open Source 118

Open Source Database Architecture Design 118

Percona

SEPTEMBER 18, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Download Percona Distribution for MongoDB 6.0.9 Take a look. Percona Backup for MongoDB 2.2.1

Open Source 77

Open Source Servers Database Scalability 77

Percona

APRIL 6, 2023

PostgreSQL is a popular open source relational database management system many organizations use to store and manage their data. However, as the size of your database grows, it can become challenging to manage and optimize its performance. This can significantly improve query response times and reduce the load on your database servers.

Cache 111

Cache Open Source Benchmarking Database 111

Percona

DECEMBER 4, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Download Percona Distribution for MySQL (PS- based variant) 8.1.0 Take a look. was released.

Open Source 77

Open Source Azure Servers Programming 77

Percona

AUGUST 7, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Download Percona Distribution for MySQL (PXC-based variant) 8.0.33 Take a look.

Open Source 83

Open Source Scalability Servers Database 83

Dynatrace

MARCH 22, 2023

Insecure design This broad category refers to fundamental design flaws in the application caused by a failure to implement necessary security controls during the design stage. Use a safe development life cycle with secure design patterns and components. Apply threat modeling and plausibility checks.

Open Source 203

Open Source Artificial Intelligence Internet Internet 203

Scalegrid

SEPTEMBER 16, 2019

PostgreSQL graphical user interface (GUI) tools help these open source database users to manage, manipulate, and visualize their data. PostgreSQL is the fourth most popular database management system in the world, and heavily used in all sizes of applications from small to large. pgAdmin can be downloaded from their official website.

Open Source 262

Open Source Database Azure Cloud 262

Percona

SEPTEMBER 4, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Download the update to the release of Percona XtraDB Cluster 8.0.33-2 Take a look.

Open Source 75

Open Source Scalability Database Software 75

Percona

MAY 2, 2023

That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Why are MongoDB database backups important? Regular database backups are essential to protect against data loss caused by system failures, human errors, natural disasters, or cyber-attacks.

Best Practices 52

Best Practices Database Storage Servers 52

Percona

APRIL 26, 2023

When you do a database restore, you want to have it done as soon as possible. And the database is unusable until the restore is done. Our tests showed physical database restores up to 5x faster than the logical ones. The speed of the physical restoration comes down to how fast we can copy (download) data from the remote storage.

Speed 77

Speed Storage AWS Azure 77

Percona

MAY 8, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Download Percona Monitoring and Management 2.37 Download Percona Server for MongoDB 5.0.17-14

Monitoring 75

Monitoring Open Source Database Servers 75

Percona

JUNE 12, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Download Percona Monitoring and Management 2.37.1 Take a look! was released on June 5, 2023.

Open Source 81

Open Source Servers Database Scalability 81

Percona

FEBRUARY 13, 2023

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. PMM installs and manages operators using Operator Lifecycle Manager (OLM) and database clusters using dbaas-operator. Take a look!

Open Source 81

Open Source Database Servers Scalability 81

Percona

JULY 6, 2023

Access Exclusive (CREATE/DROP DATABASE) : Allows exclusive access to a database. Page-Level Locks: Locks are acquired at the page level, which is a group of database blocks. Download Percona Distribution for PostgreSQL Today! Multiple sessions can concurrently hold row-level locks on different rows of the same table.

Open Source 115

Open Source Database Design Efficiency 115

Percona

JULY 24, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Download Percona Monitoring and Management 2.38.1 Download Percona Backup for MongoDB 2.2.0

Open Source 71

Open Source Scalability Database Monitoring 71

Percona

OCTOBER 16, 2023

This software is under active development and at a very early stage of design and implementation. This is something that is available in other databases but not provided in upstream, vanilla Postgres. If you create a new database, you will have to re-create the extension side of it as below. What is TDE?

Open Source 108

Open Source Testing Database Design 108

Percona

MAY 29, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Download Percona Distribution for MongoDB 4.4.21 Take a look! 13.10, 12.14, 11.19

Open Source 75

Open Source Servers Scalability Database 75

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. Download and install GO on your system. Local installation, i.e., build from sources.

Open Source 75

Open Source Database Servers Programming 75

Percona

DECEMBER 15, 2023

A database role can have a number of attributes that define its privileges and interact with the client authentication system.One such attribute is the CREATEROLE attribute, which is important to PostgreSQL database management of users and roles. This poses a security threat to the whole organisation.

C++ 90

C++ Database Open Source Systems 90

Dynatrace

JULY 11, 2023

What the software has been designed to log is what we get. When exploiting the vulnerability, attackers can gain remote code injection capabilities in the MOVEit server and modify or steal sensitive data from its database. For example, if the database name is prepended or the table name has backticks around it.

Database 163

Database Government Games Servers 163

Percona

JUNE 5, 2023

Sooner or later, one must address this issue; otherwise, one can suffer the consequences of handicapping your entire database infrastructure. This SQL statement must be executed against each and every database that is to be accessed by any ROLE connection using PgBouncer. Download Percona Distribution for PostgreSQL Today!

Database 119

Database Open Source Servers C++ 119