Scalegrid

JANUARY 19, 2024

When a MongoDB rollback happens, it can cause trouble to your data integrity and system consistency. Understanding how to address a rollback is critical for minimizing potential data loss and maintaining seamless operations. The consequences of rollbacks are significant and should not be underestimated.

Database 130

Database Network Servers Monitoring 130

DZone

FEBRUARY 25, 2023

We will show you exactly how to deploy a Nodejs app to the server using Docker containers, RDS Amazon Aurora, Nginx with HTTPS, and access it using the Domain Name. These APIs will be used to check the status of the app, insert data in the database and fetch and display the data from the database.

AWS 274

AWS Servers Internet Internet 274

Scalegrid

DECEMBER 6, 2023

In the digital age, data management has transformed from locally hosted servers to cloud solutions. The choice of self-managed cloud databases vs DBaaS is a common debate among those who are looking for the best option that will cater to their particular needs.

Database 130

Database Cloud Hardware Storage 130

Percona

NOVEMBER 1, 2023

MySQL Server – Community Edition The problem applies to all versions of the upstream MySQL Community up to 8.0.23. Here is an example scenario you may end up here: mysql > select @@version,@@version_comment; + --+ + | @@version | @@version_comment | + --+ + | 5.7.43 | MySQL Community Server (GPL) | + --+ + 1 row in set (0.00

Servers 94

Servers Database Cache C++ 94

Scalegrid

MARCH 4, 2019

Wondering which databases are trending in 2019? We asked hundreds of developers, engineers, software architects, dev teams, and IT leaders at DeveloperWeek to discover the current NoSQL vs. SQL usage, most popular databases, important metrics to track, and their most time-consuming database management tasks. SQL Databases.

Database 255

Database Metrics Systems Strategy 255

Percona

AUGUST 4, 2023

In this blog post, we will look at the lifecycle and release management for MySQL and MariaDB servers — where we are now and relevant historical background. The MariaDB 11 series did not yet have any long-term supported (LTS) releases, which are the releases most would consider for running mission-critical databases in production.

Database 77

Database Servers Innovation Open Source 77

Percona Community

FEBRUARY 22, 2023

In this blog, we will explore databases on containers. We will use Docker as a container engine tool and Percona Server for MySQL as a database administration tool. MySQL is a relational database management system that stores data on disk. Both are open source tools.

Database 89

Database Servers Open Source Engineering 89

Scalegrid

MAY 22, 2020

MySQL does not limit the number of slaves that you can connect to the master server in a replication topology. If the data churn on the master is high, the serving of binary logs alone could saturate the network interface of the master. Ripple is an open source binlog server developed by Pavel Ivanov.

Servers 262

Servers Transportation Database Availability 262

Scalegrid

APRIL 28, 2020

If you’re hosting your databases in the cloud, choosing the right cloud service provider is a significant decision to make for your long-term hosting costs. Over the last few weeks, we have been inundated with requests from SMB customers looking to improve the ROI on their database hosting. MongoDB® Database. EC2 instances.

Azure 344

Azure AWS Database Latency 344

DZone

MARCH 4, 2023

In any organization, it is a best security practice to have an SSL certificate installed on servers, applications, and databases. SSL Certificates and CA make communication secure between client and server or application. We will use a Windows server for it. You can use any number of SSL certificates free of cost.

Servers 130

Servers Database Systems 130

Percona

OCTOBER 17, 2023

This blog post discusses using the CLONE INSTANCE command with the safety option DATA DIRECTORY when you do not have enough disk space to store two datasets. MySQL Clone plugin simplifies new replica provisioning but does not simplify server restore after failure unless you are ready to re-install your MySQL instance from scratch.

Open Source 96

Open Source Servers Database Strategy 96

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. More in the following sub-section.)

Availability 105

Availability Database Open Source Hardware 105

Percona

DECEMBER 14, 2023

I played a bit with ChatGPT in February to see how it would respond to random database-related inquiries, and I found it pretty impressive and annoying at the same time. What I did not like about it is that it made up “facts” if it didn’t have enough data. Improved Data Integrity Checks: MongoDB 7.0

Database 84

Database Artificial Intelligence Servers Operating System 84

Dynatrace

JULY 11, 2023

But observability data (traces) can fill in the blanks to reveal useful evidence of possible exploitation, as proved by our analysis of the MoveIT vulnerability using Dynatrace. 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 158

Database Government Games Servers 158

DZone

JANUARY 2, 2024

Sharding, a database architecture pattern, involves partitioning a database into smaller, faster, more manageable parts called shards. Each shard is a distinct database, and collectively, these shards make up the entire database. What Is Sharding?

Architecture 260

Architecture Database Scalability Servers 260

Dynatrace

DECEMBER 9, 2020

If you’re running SAP, you’re likely already familiar with the HANA relational database management system. HANA maintains all the business and analytics data that your business runs on. Today we’re proud to announce that we’ve extended our SAP monitoring capabilities to support SAP HANA databases.

Infrastructure 199

Infrastructure Database Monitoring Metrics 199

Dynatrace

MAY 17, 2023

OpenTelemetry , the open source observability tool, has become the go-to standard for instrumenting custom applications to collect observability telemetry data. For this third and final part of our series, we saved the best for last: How you can enhance telemetry data even more and with less effort on your end with Dynatrace OneAgent.

Metrics 171

Metrics Database Monitoring Network 171

DZone

JULY 3, 2023

Data engineering projects often require the setup and management of complex infrastructures that support data processing, storage, and analysis. In this article, we will explore the benefits of leveraging IaC for data engineering projects and provide detailed implementation steps to get started.

Data Engineering 141

Data Engineering Infrastructure Engineering Code 141

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. We help you configure your MySQL deployment to optimize your performance based on the size of your databases.

Database 166

Database Cloud Website Azure 166

Scalegrid

NOVEMBER 12, 2019

PostgreSQL is an amazing relational database. However, beyond just the features, there are other important aspects of a database that need to be considered. However, beyond just the features, there are other important aspects of a database that need to be considered. Why not have this built it into the server?

Database 184

Database Open Source Storage Servers 184

Scalegrid

MARCH 8, 2024

Data loss or corruption can be daunting. With MySQL point-in-time recovery , you can restore your database to the moment before the problem occurs. Preparation for PITR is crucial and involves enabling binary logging and creating a full database backup. Each caters to specific needs.

Database 162

Database Strategy Servers Best Practices 162

Percona

OCTOBER 10, 2023

Databases are different from a lot of software. This is not a general rule, but as databases are responsible for a core layer of any IT system – data storage and processing — they require reliability. Why choose Percona Server for MongoDB? Why release Percona Server for MongoDB 7 now?

Availability 97

Availability Servers Database Open Source 97

Scalegrid

AUGUST 30, 2019

Redis , short for Remote Dictionary Server, is a BSD-licensed, open-source in-memory key-value data structure store written in C language by Salvatore Sanfillipo and was first released on May 10, 2009. Depending on how it is configured, Redis can act like a database, a cache or a message broker. Data Structures in Redis.

Cache 232

Cache Ecommerce Social Media Database 232

Percona

MARCH 26, 2024

Grafana uses PostgreSQL instead of SQLite database to store users, dashboards, and other persistent data. This aids in getting some useful information related to [configured alerts] directly via querying from the Postgres backend.Sometimes we need to migrate only alert rules from one PMM server to another for some […]

Monitoring 81

Monitoring Servers Database Cloud 81

Percona

AUGUST 30, 2023

These days, “Data is king,” and a lot more. Data powers everything, and unlike coal and coal combustion, data and databases aren’t going away. Any organization that uses personal and other sensitive data must have a firm, proven plan for business continuity in the event of a disaster or cyberattack.

Database 85

Database Hardware Open Source Strategy 85

Percona

JANUARY 2, 2024

Managing database servers involves different aspects, among which security is critical. However, we know having a “runaway” grant is always a possibility, especially in environments with a large number of servers. Fortunately, in Percona Server for MySQL , this feature is free to use. How does it work?

Servers 81

Servers Database Open Source Scalability 81

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 90

Open Source Database Hardware Strategy 90

DZone

OCTOBER 1, 2023

As a distributed database, your data is partitioned into “shards” which are then allocated to one or more servers. Because of this sharding, a read or write request to an Elasticsearch cluster requires coordinating between multiple nodes as there is no “global view” of your data on a single server.

Open Source 247

Open Source Tuning Analytics Scalability 247

Dynatrace

OCTOBER 4, 2022

Software and data are a company’s competitive advantage. But for software to work perfectly, organizations need to use data to optimize every phase of the software lifecycle. The only way to address these challenges is through observability data — logs, metrics, and traces. Teams interact with myriad data types.

Analytics 190

Analytics Software Software Storage 190

Percona

DECEMBER 27, 2022

Encrypting data at rest in a database management system (DBMS) refers to securing data by encrypting it when it is not being used or accessed. This is often done to protect sensitive data from unauthorized access or theft. This is independent of the database, and external tools can be used to achieve this.

Database 93

Database Storage Servers Strategy 93

SQL Shack

SEPTEMBER 16, 2020

In the previous article, Transparent Data Encryption for SQL Server Always On Availability Groups, we discussed enabling TDE for the existing database in AG. In this article, we will explore options for a compressed backup of a TDE database. It uses the […].

Database 104

Database Availability Servers 104

Percona

DECEMBER 15, 2022

JSON data and relational databases have traditionally been diametric opposites. So many folks were surprised when relational databases started adding a JSON data type to their products. In this multi-part blog series, we will start with an overview of using JSON in a relational database. JSON is popular.

Database 91

Database Servers Processing Efficiency 91

Percona

MARCH 23, 2023

When it comes to enterprise-level databases, there are several options available in the market, but PostgreSQL stands out as one of the most popular and reliable choices. PostgreSQL is a free and open source object-relational database management system (ORDBMS) that has existed since the mid-1990s.

Database 114

Database Open Source Traffic Small Business 114

SQL Shack

OCTOBER 14, 2021

Transparent Data Encryption (TDE) encrypts database files to secure your data. It also encrypts the tempdb database to secure your data in a temporary space. The process of encryption and decryption adds additional overhead to the database system.

Servers 79

Servers Performance Database Systems 79

DZone

NOVEMBER 21, 2023

Thanks to its expressive query language (PromQL), scalability, and configurable data format, it remains one of the most popular tools for data collection. With the help of exporters, Prometheus can provide insightful data and effectively monitor a variety of services, including databases, web servers, and custom-made applications.

Best Practices 279

Best Practices Scalability Monitoring Database 279

SQL Shack

AUGUST 28, 2020

In this 15th article of SQL Server Always On Availability Groups series, we will cover Transparent Data Encryption (TDE) for AG databases. Introduction In the previous articles of SQL Server Always On series, we explored the following topics so far.

Availability 94

Availability Servers Virtualization Database 94

Percona

OCTOBER 11, 2023

In this blog post, we will discuss how we can migrate data from MongoDB Atlas to self-hosted MongoDB. There are a couple of third-party tools in the market to migrate data from Atlas to Pecona Server for MongoDB (PSMDB), like MongoPush, Hummingbird, and MongoShake. It will ask for load sample data. only copy the data).

Database 85

Database Open Source Testing Servers 85