DZone

MARCH 24, 2021

We typically understand software testing by the everyday definition of the word: making sure a piece of software performs the way it is supposed to in a production-like environment. For a complex distributed application with several external dependencies there is nothing that can beat a full end-to-end test. Or is there?

Design 193

Design Testing Software Performance Database 193

Percona

NOVEMBER 3, 2023

Rather than listing the concepts, function calls, etc, available in Citus, which frankly is a bit boring, I’m going to explore scaling out a database system starting with a single host. Download Percona Distribution for PostgreSQL Today! Rebalancing the shards across the two nodes.

Database 105

Database Benchmarking Latency C++ 105

Percona

OCTOBER 16, 2023

In the spirit of open and transparent communication, we would appreciate your feedback and invite PostgreSQL users to test the extension and provide feedback either via the GitHub repository or in the forum. This is something that is available in other databases but not provided in upstream, vanilla Postgres. What is TDE? Debian 16.0-1.pgdg120+1))

Open Source 112

Open Source Testing Database Design 112

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 86

Scalability Database Open Source Traffic 86

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 83

Database Monitoring C++ Speed 83

Percona

JANUARY 25, 2023

Database administrators often need to identify inactive databases and users to save resources. This can be done using various methods to determine which databases and users are frequently accessed. We can save disk space and other resources by purging inactive databases and users.

Database 97

Database C++ Servers Open Source 97

Scalegrid

JULY 29, 2019

MySQL is a free open source relational database management system that is leveraged across a majority of WordPress sites, and allows you to query your data such as posts, pages, images, user profiles, and more. Managing a database is hard, as it needs continuous updating, tuning, and monitoring to ensure the performance of your website.

Database 166

Database Cloud Website Azure 166

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 76

Open Source Database Storage Scalability 76

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.

Benchmarking 308

Benchmarking Latency C++ Database 308

DZone

JANUARY 29, 2020

One day I faced the problem with downloading a relatively large binary data file from PostgreSQL. The choice affected the project's unit test base. It's still not possible to continue using light-weighted databases such as HSQL or H2 to implement tests. It is a key problem which we will try to resolve in this article.

Storage 124

Storage Efficiency Testing Database 124

HammerDB

JULY 17, 2019

As noted in the previous post to add a database to HammerDB you will need to change the source code. This can be done with Clone or download. in this example we will use the command line to do this using the web URL shown in the Clone or download link. Firstly make a fork of the latest HammerDB source on GitHub to your account.

Database 40

Database Code Systems Testing 40

Scalegrid

SEPTEMBER 18, 2020

If your application connects to the production database over a public network, do reach out to support@scalegrid.io Note: All the code samples have been tested using MongoDB Driver v2.8.1 For example: <path-to-downloaded-CA-Cert.cer> = C:UsersUserFoldercaCert.cer. <host1> to learn more about this.

C++ 244

C++ Programming Servers Database 244

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 87

Innovation Open Source Scalability Database 87

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 87

Monitoring Open Source Servers Scalability 87

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 79

Monitoring Open Source Scalability Database 79

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

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

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. So we decided to try parallel (concurrent) download. So every minute matters. But can we do better?

Speed 80

Speed Storage AWS Azure 80

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 115

Cache Open Source Benchmarking Database 115

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 80

Open Source Azure Servers Programming 80

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 84

Open Source AWS Servers Database 84

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 75

Servers Monitoring Open Source Scalability 75

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 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 80

Open Source Servers Database Scalability 80

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 78

Open Source Scalability Database Software 78

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. It can perform ETL transforms from one database to another and, under certain special circumstances, can even be implemented as a poor man’s replication solution. MYSQL: OS: Ubuntu 16.04 MySQL version 5.7

Open Source 122

Open Source Database Architecture Design 122

Percona

JULY 10, 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 Take a look! was released on June 28, 2023.

Monitoring 78

Monitoring Open Source Scalability Database 78

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 78

Monitoring Open Source Database Servers 78

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 84

Open Source Servers Database Scalability 84

Percona

OCTOBER 11, 2023

I created a test account (replica set) and loaded sample data with one click in Atlas: Create an account in Atlas. Atlas atlas-mhnnqy-shard-0 [primary] test> show dbs sample_airbnb 52.69 GiB Atlas atlas-mhnnqy-shard-0 [primary] test> An EC2 instance with PSMDB installed. Prerequisites: A MongoDB Atlas account.

Database 87

Database Open Source Testing Servers 87

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 78

Open Source Servers Scalability Database 78

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 84

Open Source Database Servers Scalability 84

HammerDB

MAY 26, 2022

HammerDB already provides pre-compiled packages from the download page so if you want to run HammerDB without building it then these packages are all you need. All of the source code and dependencies in HammerDB are open source right down to the layer above any 3rd party commercial database drivers for Oracle, SQL Server and Db2.

C++ 113

C++ Database Open Source Servers 113

Percona

MARCH 27, 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. It offers highlights, critical information, links to the full release notes, and direct links to the software or service itself to download.

Open Source 79

Open Source Servers Scalability Cache 79

Scalegrid

JULY 13, 2020

Oracle Database is a commercial, proprietary multi-model database management system produced by Oracle Corporation, and the largest relational database management system (RDBMS) in the world. While Oracle remains the #1 database on the market, its popularity has steadily declined by over 18% since 2013. Oracle Costs.

Open Source 244

Open Source Tuning C++ Database 244

Percona

JUNE 26, 2023

We have faced different levels of corruption related to databases in PostgreSQL. In case of hardware failure, first, we need to fix the hardware issue or migrate our database to new hardware and then perform a restore, as mentioned below. So we need to check whether this base / 16384 / 16391 file is available in / base location.

Hardware 76

Hardware C++ Database Open Source 76

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 78

Open Source Database Servers Programming 78