Percona

AUGUST 30, 2023

Data powers everything, and unlike coal and coal combustion, data and databases aren’t going away. In this blog, we’ll focus on the elements of database backup and disaster recovery, and we’ll introduce proven solutions for maintaining business continuity, even amid otherwise dire circumstances.

Database 87

Database Hardware Open Source Strategy 87

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 121

Open Source Database Architecture Design 121

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. Find more information in the Telemetry on Percona XtraDB Cluster document.

Innovation 86

Innovation Open Source Scalability Database 86

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. Take a look. Percona Monitoring and Management 2.41.0 48 Percona XtraBackup 8.2.0-1

Monitoring 86

Monitoring Open Source Servers Scalability 86

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

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. The popularity of MongoDB MongoDB has emerged as a popular database platform. 5 among all database management systems and No. It ranks No.

Open Source 75

Open Source Database Scalability Software 75

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. Find more information in the Telemetry on Percona Server for MySQL document.

Open Source 79

Open Source Azure Servers Programming 79

Percona

OCTOBER 11, 2023

KiB config 240.00 KiB local 468.00 KiB mongoshake 56.00 KiB sample_airbnb 52.20 MiB sample_analytics 9.21 MiB sample_geospatial 984.00 KiB sample_guides 40.00 KiB sample_mflix 108.17 MiB sample_restaurants 5.57 MiB sample_supplies 980.00 KiB sample_training 40.50 MiB sample_weatherdata 2.39 KiB config 240.00 KiB local 468.00 KiB mongoshake 56.00

Database 86

Database Open Source Testing Servers 86

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

JANUARY 11, 2023

MongoDB is a great database that provides outstanding high availability solutions out of the box. For most Database Administrators (DBAs) we talk with, though, the awesome safety features we came to appreciate MongoDB for, like automatic failover or data redundancy, are not enough. Physical backups. the physical backups went GA!

Open Source 80

Open Source Database Strategy Storage 80

Percona

MARCH 29, 2023

Compression in any database is necessary as it has many advantages, like storage reduction, data transmission time, etc. Snappy compression is designed to be fast and efficient regarding memory usage, making it a good fit for MongoDB workloads. OS: CentOS Linux 7 I’ve used mgenerate command to insert a sample document.

Storage 108

Storage Network Open Source Latency 108

Percona

OCTOBER 4, 2023

We discussed how roles can inherit permissions from other roles, simplifying access control in your database. Documentation: Document your role hierarchy in reverse for reference, compliance, and auditing purposes. But what if you need to discover which roles inherit from a specific role?

C++ 99

C++ Open Source Tuning Database 99

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. Take a look. Percona Monitoring and Management 2.38.1 The upgrade to Grafana 9.2.20

Open Source 73

Open Source Scalability Database Monitoring 73

Percona

AUGUST 17, 2023

PostgreSQL is open source relational database management software. Most recently, in StackOverflow’s 2022 Stack Developer Survey , PostgreSQL took a slight lead over MySQL (46.48% to 45.68%) as the most popular database platform among professional developers. How-to documentation is readily available.

Open Source 78

Open Source Healthcare Social Media Database 78

Percona

FEBRUARY 20, 2023

Recently, one of our customers approached us with a unique challenge: they needed to migrate their entire PostgreSQL cluster from DigitalOcean’s Database as a Service (DBaaS) to a DigitalOcean Droplet. ” In short, we have to migrate the database as per the client’s request, and we gave them two options: 1.

Database 94

Database Open Source Servers Internet 94

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. Therefore, DBAs must take a piecemeal approach to achieve HA with PostgreSQL, bringing together open source extensions and tools from multiple sources.

Availability 83

Availability Open Source Architecture Database 83

Official Blog - World Web Technology

AUGUST 27, 2023

For example, website design is very crucial to impress your website visitors. It is a server-side scripting language that is highly secure, open-source, and versatile. PHP is Open Source Language The most important thing for a business is to optimize costs to make operations more cost-effective and improve profit margins.

Development 98

Development Ecommerce Open Source Website 98

Percona

FEBRUARY 23, 2023

If you ever had to make a quick ad-hoc backup of your MongoDB databases, but there was not enough disk space on the local disk to do so, this blog post may provide some handy tips to save you from headaches. while not overloading the CPU capacity on the production database. 0 document(s) failed to restore. %H-%M)/db2.zst

AWS 120

AWS Storage Database Open Source 120

Percona

DECEMBER 22, 2023

​​MongoDB is a schemaless database that is extremely flexible. Just start inserting JSON documents, and MongoDB will store them, no matter which fields and data types you provide. As a consequence, a collection can store completely different documents. Start inserting new JSON documents with the additional fields.

Database 88

Database Open Source Testing Monitoring 88

Percona

DECEMBER 2, 2022

Many community members joined Hacktoberfest this year and contributed to various open source projects, and we would like to highlight the most active contributors to Percona software during this fantastic event. Each of them will receive a T-shirt and a mug with a unique design. daniel-shuy fixed the database migration test.

Open Source 55

Open Source Azure Database Speed 55

Percona

APRIL 3, 2023

This can happen, for example, when all documents in the chunk contain the same shard key. The idea is to go through each document on the config.chunks collection with the { jumbo:true } property, and run the dataSize command to check the actual chunk size. In certain use cases, the document size varies greatly across documents.

Open Source 87

Open Source Processing Database Design 87

Percona

DECEMBER 11, 2023

Here, we will discuss a notable new feature in Amazon RDS, the Dedicated Log Volume (DLV), that has been introduced to boost database performance. A Dedicated Log Volume (DLV) is a specialized storage volume designed to house database transaction logs separately from the volume containing the database tables.

AWS 96

AWS Benchmarking Performance Traffic 96

Percona

DECEMBER 7, 2023

Ensuring the security and resilience of your data hinges on having a robust backup strategy, and Percona XtraBackup (PXB), our open source backup solution for all versions of MySQL, is designed to make backups a seamless procedure without disrupting the performance of your server in a production environment. respectively.

C++ 93

C++ Open Source Servers Database 93

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. You can change this; please see users documentation. Please use our documentation to configure backups.

Storage 94

Storage Database Media Open Source 94

Dynatrace

NOVEMBER 29, 2021

See our documentation for more details on getting started or sign up for a free 15-day trial. According to the official AWS announcement, Graviton2-based Lambda functions offer up to 34% better price-performance improvement. For more information on AWS Lambda and Dynatrace click here.

Lambda 212

Lambda AWS Serverless Metrics 212

HammerDB

JUNE 27, 2022

HammerDB is a software application for database benchmarking. It enables the user to measure database performance and make comparative judgements about database hardware and software. Databases are highly sophisticated software, and to design and run a fair benchmark workload is a complex undertaking.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Scalegrid

DECEMBER 16, 2019

MongoDB is the #3 open source database and the #1 NoSQL database in the world. It’s a cross-platform document-oriented database that uses JSON-like documents with schema, and is leveraged broadly across startup apps up to enterprise-level businesses developing modern apps. MongoDB Replica Sets.

Azure 187

Azure AWS Latency Database 187

Percona

FEBRUARY 24, 2023

In the Home Dashboard of PMM, a low CPU utilization on any of the database services that are being monitored could mean that the server is inactive or over-provisioned. From AWS documentation , Amazon EBS is an easy-to-use, scalable, high-performance block-storage service designed for Amazon EC2.

Cloud 118

Cloud Serverless AWS Storage 118

Percona

SEPTEMBER 26, 2023

As MySQL database administrators, we are well aware of the significance of implementing a primary key within a table. Primary keys play an indispensable role in sound database design by uniquely identifying individual rows and significantly enhancing data retrieval, manipulation, and overall system performance.

Database 100

Database Engineering Best Practices Open Source 100

Percona

JULY 5, 2023

Fragmentation is a common concern in some database systems. In databases, we can experiment with different types of fragmentation: Segment Fragmentation : segments are fragmented; they are stored not following the order of data, or there are empty pages gaps between the data pages. What is fragmentation?

Open Source 125

Open Source Database Efficiency Testing 125

Percona

MARCH 27, 2023

You might wonder why this error will come during PITR as the operations in the Oplog are idempotent, meaning they always result in the same change to the database no matter how many times they’re performed. I created a collection book with four documents with a unique compound index. sort({$natural:-1}).limit(1)

Games 94

Games Database Open Source C++ 94

Percona

DECEMBER 12, 2022

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. Database page content is not written to the buffer. It’s time for the release roundup! DETECT_AND_RECOVER.

Open Source 62

Open Source Azure Database Servers 62

Percona

AUGUST 18, 2023

Why not just create another database on the same instance? 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. So you put multiple MySQL servers on a single machine instead of multiple databases inside one MySQL instance.

Programming 84

Programming Servers Database Hardware 84

Percona

OCTOBER 12, 2023

Read concern vs. write concern vs. flow control While investigating the real customer case manifesting this problem, I found it challenging to understand some of the documentation on how flow control relates to read concern. The required majority to avoid flow control is: mongo> rs.status().writeMajorityCount

Open Source 89

Open Source Traffic Availability Database 89

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 80

Servers Database C++ Airlines 80

Scalegrid

JULY 17, 2020

It is an open standard format which organizes data into key/value pairs and arrays detailed in RFC 7159. JSON is the most common format used by web services to exchange data, store documents, unstructured data, etc. Why should a relational database even care about unstructured data? JSON database in 9.2 JSONB Indexes.

Storage 321

Storage Database Efficiency Processing 321

Percona

JUNE 4, 2023

Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). While originally designed to be a drop-in replacement for MySQL, it evolved into its own distinct database management system and is now maintained and supported by the MariaDB Foundation.

Open Source 52

Open Source Servers Storage Scalability 52