Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. A basic high availability database system provides failover (preferably automatic) from a primary database node to redundant nodes within a cluster. HA is sometimes confused with “fault tolerance.”

Availability 104

Availability Database Open Source Hardware 104

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

DECEMBER 28, 2023

Managing vast datasets effectively is an essential requirement for modern applications, and MongoDB , a leading NoSQL database, offers robust solutions for this requirement. Offset-based involves utilizing functions such as skip , limit and a query which indicates how many documents should be skipped or returned at maximum.

Best Practices 130

Best Practices Efficiency Strategy Speed 130

Percona

JANUARY 24, 2023

Databases on Kubernetes continue their rising trend. Our Operators provide built-in backup and restore capabilities, but some users are still looking for old-fashioned ways, like storage-level snapshots (i.e., Both your storage and Container Storage Interface (CSI) must support snapshots. AWS EBS Snapshots).

Database 65

Database Storage Open Source AWS 65

Scalegrid

JANUARY 19, 2024

Recovering from a MongoDB rollback involves locating rollback files, using mongorestore to load data into a separate server, cleansing unneeded data, and importing the data back into the primary cluster, coupled with ongoing monitoring and maintenance of replica sets to maintain system health.

Database 130

Database Network Servers Monitoring 130

Dynatrace

JANUARY 16, 2023

The strongest Kubernetes growth areas are security, databases, and CI/CD technologies. On-premises data centers invest in higher capacity servers since they provide more flexibility in the long run, while the procurement price of hardware is only one of many cost factors. Databases : Among databases, Redis is the most used at 60%.

Open Source 346

Open Source Java Operating System Programming 346

Scalegrid

NOVEMBER 23, 2023

Imagine a world where your PostgreSQL® database connections are seamless and secure. Key Takeaways Understanding PostgreSQL hostname is essential for successful database connections. Configure the PostgreSQL hostname by editing configuration files and restarting the server, with secure storage of connection details to enhance security.

Database 130

Database Servers Storage Network 130

Percona

DECEMBER 28, 2023

Starting with Percona Server for MySQL 8.0.34-26 You can filter events based on a user account, audit event class name, audit event subclass name, and audit event fields (database name, table name, operation status, and so on). Compress the audit log files to reduce the storage space occupied with log files.

Open Source 101

Open Source Database Servers Storage 101

Percona

MARCH 29, 2023

Compression in any database is necessary as it has many advantages, like storage reduction, data transmission time, etc. Storage reduction alone results in significant cost savings, and we can save more data in the same space. By default, MongoDB provides a snappy block compression method for storage and network communication.

Storage 105

Storage Network Open Source Latency 105

Percona

APRIL 20, 2023

TDE is a database encryption technique that encrypts data at the column or table level, as opposed to full-disk encryption (FDE), which encrypts the entire database. To enable the encryption of the storage in Kubernetes, you need to modify the StorageClass resource. apiVersion: storage.k8s.io/v1 apiVersion: storage.k8s.io/v1

Storage 118

Storage AWS Cloud Database 118

SQL Performance

JULY 19, 2022

The simplest definition of a log record: it describes a single change to a database. A single operation in the database may cause multiple changes , but each change will usually have its own log record to describe it. out of space on the log drive), the database must be set offline in the SUSPECT state. What Are Log Records?

Servers 94

Servers Database Storage Engineering 94

Dynatrace

FEBRUARY 14, 2022

Among these, you can find essential elements of application and infrastructure stacks, from app gateways (like HAProxy), through app fabric (like RabbitMQ), to databases (like MongoDB) and storage systems (like NetApp, Consul, Memcached, and InfluxDB, just to name a few). documentation. Prometheus Data Source documentation.

Technology 222

Technology Technology Metrics Infrastructure 222

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. Marked in red in Figure 1 is a server with less than 30% of CPU usage. Configuration of the CPU metrics can be changed in the dashboard.

Cloud 116

Cloud Serverless AWS Storage 116

Percona

OCTOBER 18, 2023

Under the hood, we store logical oplogs along with physical backups into the object storage. The trick is to use the oplogOnly flag, which would instruct Percona Backup for MongoDB to upload oplogs to the object storage without waiting for the logical backup. See more details in the documentation. spec: backup: enabled: true.

Best Practices 89

Best Practices Storage AWS Big Data 89

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. Fortunately, there are ways to skip the local storage entirely and stream MongoDB backups directly to the destination.

AWS 118

AWS Storage Database Open Source 118

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 77

Open Source Azure Servers Programming 77

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “.

Servers 90

Servers Media Cache Storage 90

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. In this case, the backups should be stored on some object storage.

Storage 91

Storage Database Media Open Source 91

Percona

NOVEMBER 1, 2023

As businesses and applications increasingly rely on MySQL databases to manage their critical data, ensuring data reliability and availability becomes paramount. Learn more: Discover six of the most common causes of poor database performance in our free eBook. on, you can use mysqlbinlog to stream binary logs from a remote server.

Best Practices 78

Best Practices Storage Strategy Database 78

The Morning Paper

MARCH 3, 2020

Millions of tiny databases , Brooker et al., It takes you through the thinking processes and engineering practices behind the design of a key part of the control plane for AWS Elastic Block Storage (EBS): the Physalia database that stores configuration information. NSDI’20. This paper is a real joy to read.

Database 106

Database AWS Network Design 106

Percona

AUGUST 18, 2023

Why do you need multiple instances on the same server? 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. ln -s /usr/local/Percona-Server-8.0.19-10-Linux.x86_64.ssl101/

Programming 82

Programming Servers Database Hardware 82

Percona

JULY 26, 2023

MongoDB is a non-relational document database that provides support for JSON-like storage. First released in 2009, it is the most used NoSQL database and has been downloaded more than 325 million times. The bigger the database, the bigger the damage from a leak.

Database 78

Database Servers Storage Strategy 78

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 74

Open Source Database Scalability Software 74

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. minutes of downtime in one year.

Azure 187

Azure AWS Latency Database 187

Percona

MAY 9, 2023

Many MongoDB clusters use storage-level snapshots to provide fast and reliable backups. Background story I recently worked with a company running a large four-shard MongoDB Enterprise Server database cluster on VMs on premises that decided to migrate to the Google Cloud Platform. Set spec.image to a specific image version.

Storage 102

Storage Cloud Servers Google 102

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. This blog highlights considerations for keeping your own PostgreSQL databases highly available and healthy. The same changes made in the primary database are made in the replicas.

Availability 81

Availability Open Source Architecture Database 81

Percona

DECEMBER 28, 2022

Aurora replicas connect to the same storage volume as the primary DB instance and support only read operations. Connection id: 22 Current database: db + --+ | connection_id() | + --+ | 22 | + --+ 1 row in set (3.19 Lost connection to MySQL server during query So what is the issue? Trying to reconnect.

Storage 93

Storage Servers AWS Database 93

SQL Performance

OCTOBER 7, 2020

The documentation says only the following operators can rewind: Table Spool. If you’re interested in table-valued function rewinds, please see my Q & A on Database Administrators Stack Exchange. Sorts use storage (memory and perhaps disk if they spill) so they do have a facility capable of storing rows between loop iterations.

Servers 106

Servers Cache Azure Performance 106

Dynatrace

APRIL 21, 2022

Log Monitoring documentation. Starting with Dynatrace version 1.239, we have restructured and enhanced our Log Monitoring documentation to better focus on concepts and information that you, the user, look for and need. Legacy Log Monitoring v1 Documentation. Improved error handling for unexpected storage issues. (APM-360014).

Azure 221

Azure Metrics AWS Monitoring 221

SQL Performance

APRIL 17, 2020

When we ask SQL Server to change some aspect of a column's definition, it needs to check that the existing data is compatible with the new definition. Depending on the type of change and the configuration of the database, an ALTER COLUMN command will need to perform one of the following actions: Change metadata in system tables only.

Servers 63

Servers Database Testing Efficiency 63

Percona

JULY 2, 2023

The size of the database and your database environment—if it is on colo or cloud—matters. 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

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 76

Open Source Healthcare Social Media Database 76

SQL Performance

SEPTEMBER 6, 2022

This article isn’t about the act of lock escalation itself, which is already well documented and generally well understood. Much of the documentation is incorrect or at least imprecise about this and I’ve been unable to find a correct description in other writings. Let’s look at some examples using a fresh database. Explanation.

Database 98

Database Storage Testing Servers 98

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

Percona

JUNE 6, 2023

A full backup is a comprehensive data backup strategy that involves creating a complete, exact copy of all data and files in a database. In order to implement effective full backups of your database, you must follow some best practices. Get started today with Percona Backup for MongoDB. What is a full backup?

Storage 67

Storage Strategy Network Efficiency 67

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. Red Hat recommends lower ratios of 10 and 3 for high-performance/large-memory servers. )

Best Practices 52

Best Practices Design Tuning Database 52

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. Stricter downgrade policy The upstream documentation highlights the following: Starting in MongoDB 7.0, These tickets are categorized into Read tickets and Write tickets.

Metrics 98

Metrics C++ Storage Database 98