High Scalability

MAY 11, 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. Comparing Cloud Instance Costs.

Azure 290

Azure AWS Database Cloud 290

Scalegrid

JUNE 4, 2020

ScaleGrid is a fully managed DBaaS that supports MySQL, PostgreSQL and Redis™, along with additional support for MongoDB® database and Greenplum® database. Along with many popular cloud providers, DigitalOcean also provides a Managed Databases service. So, which database service is right for your application? Single Node.

Database 230

Database Latency Benchmarking Performance 230

InfoQ

MAY 15, 2023

A horizontally scalable exabyte-scale blob storage system which operates out of multiple regions, Magic Pocket is used to store all of Dropbox’s data. Adopting SMR technology and erasure codes, the system has extremely high durability guarantees but is cheaper than operating in the cloud. By Facundo Agriel

Storage 108

Storage Systems Scalability Cloud 108

Scalegrid

NOVEMBER 25, 2019

ScyllaDB is an open-source distributed NoSQL data store, reimplemented from the popular Apache Cassandra database. We’ve heard a lot about this rising database from the DBA community and our users, and decided to become a sponsor for this years Scylla Summit to learn more about the deployment trends from its users.

Big Data 187

Big Data Database Open Source Azure 187

SQL Shack

OCTOBER 26, 2021

This article will explore automatic index advisor (CREATE_INDEX, DROP_INDEX) for Azure SQL Database. Introduction Azure SQL Database enables its users to focus on database objects, tuning queries without managing the underlying infrastructure resources. These indexes help the query […].

Azure 103

Azure Database Tuning Infrastructure 103

DZone

OCTOBER 23, 2023

NoSQL databases emerge as ideal candidates to meet these requirements, and cloud platforms such as AWS offer managed and highly resilient data ecosystems. In this article, I am not going to determine which AWS NoSQL database is better: the concept of a better database only exists within a specific purposeful context.

AWS 266

AWS Performance Database Architecture 266

SQL Shack

OCTOBER 4, 2021

This article explores the MSDB SQL Database maintenance and cleanup process essential for every DBA. Introduction SQL Server system database – MSDB stores SQL Server agent jobs, History, schedules, database mail, service broker, backup, and restore History.

Database 97

Database Servers Systems Processing 97

SQL Shack

JUNE 14, 2023

This article explains what database monitoring is and why it is essential. Then, it illustrates the different methods for monitoring MongoDB NoSQL databases. What is database monitoring? Monitoring tools collect information related […]

Database 52

Database Monitoring Systems Performance 52

DZone

SEPTEMBER 26, 2023

This is an article from DZone's 2023 Database Systems Trend Report. In this article, we will dive into clouds and discuss their optimal suitability based on different types of organizational or individual needs.

Social Media 259

Social Media Artificial Intelligence Media Internet 259

InfoQ

MAY 13, 2022

In this article, I want to present a simple cloud architecture that can allow an organization to take monolithic applications to the cloud incrementally without a dramatic change in the architecture. We will discuss the minimal requirements and basic components to take advantage of the scalability of the cloud. By Luciano Mammino.

Cloud 64

Cloud Architecture Scalability Network 64

DZone

OCTOBER 16, 2023

Choosing the right data types in PostgreSQL can significantly impact your database's performance and efficiency. In this article, we'll explore best practices for selecting data types that align with PostgreSQL's recommendations.

Best Practices 272

Best Practices Speed Database Efficiency 272

DZone

SEPTEMBER 25, 2023

This is an article from DZone's 2023 Database Systems Trend Report. At the heart of this digital transformation lies the critical role of cloud databases — the backbone of modern data management.

Education 256

Education Innovation Scalability Cloud 256

DZone

FEBRUARY 12, 2024

Optimizing complex MySQL queries is crucial when dealing with large datasets, such as fetching data from a database containing one million records or more. Poorly optimized queries can lead to slow response times and increased load on the database server, negatively impacting user experience and system performance.

Performance 161

Performance Database Strategy Efficiency 161

DZone

MARCH 24, 2023

This article compares QuestDB with one of the most popular databases on the market, MongoDB. We look at the two databases in terms of benchmark performance and user experience. It is used in a wide variety of industries and use cases (if you are new to this space, read our article 'What is Time-Series Data' ).

Benchmarking 234

Benchmarking Database Processing Performance 234

DZone

OCTOBER 3, 2023

This is an article from DZone's 2023 Data Pipelines Trend Report. For more: Read the Report We live in an era of rapid data generation from countless sources, including sensors, databases, cloud, devices, and more.

Analytics 286

Analytics Database Cloud Processing 286

DZone

FEBRUARY 15, 2023

In this article, I’m going to demonstrate how you can migrate a comprehensive web application from MySQL to YugabyteDB using the open-source data migration engine YugabyteDB Voyager. Nowadays, many people migrate their applications from traditional, single-server relational databases to distributed database clusters.

Open Source 286

Open Source Scalability Database Servers 286

DZone

JANUARY 30, 2024

The Configuration Management Database (CMDB) has emerged as a powerful solution, revolutionizing the way businesses manage and optimize their IT environments. This article explores the role of CMDB in empowering IT infrastructure management, enhancing operational efficiency, and fostering strategic decision-making.

Infrastructure 196

Infrastructure Hardware Database Network 196

Percona

MARCH 16, 2023

Let’s look at how you can run Percona databases on Kubernetes, the easy way. Chances are that if you are using the latest Percona Monitoring and Management (PMM) version, you have seen the availability of the new Percona Database as a Service (DBaaS).

Infrastructure 96

Infrastructure Database AWS Monitoring 96

SQL Shack

AUGUST 21, 2020

In this article, we will learn how we can write Perfmon counter data to a SQL database through the ODBC connection. Performance Monitor is an oldie but goldie tool to analyze performance problems.

Database 113

Database Monitoring Performance Metrics 113

DZone

NOVEMBER 16, 2023

In this article, we will explore one of the most common and useful resilience patterns in distributed systems: the circuit breaker. A circuit breaker is a component that monitors the health of a dependency, such as a remote service, an external API, or a database. What Is a Circuit Breaker?

Latency 258

Latency Network Database Monitoring 258

DZone

FEBRUARY 27, 2023

This article showcases optimization techniques that had great results at GitGuardian. You’ll find basic and advanced optimization techniques using Django and PostgreSQL, yet most of the principles we discuss are general enough to be applied to other frameworks or relational databases. But don’t believe me, test them yourself!

Database 226

Database Testing 226

SQL Shack

OCTOBER 6, 2021

This article explains the internals of the Ghost cleanup task for SQL Server Databases. Introduction Each relational database consists of the background process and user processes.Similarly, SQL Server has many internal processes such as Checkpoint, Lazy Writer, Lock Monitor, System_Health_Monitor, Trace Queue Task and Ghost CleanUp.

Database 83

Database Servers Monitoring Processing 83

DZone

FEBRUARY 9, 2024

This article delves into the pivotal role of PAM in modern cybersecurity, exploring its principles, implementation strategies, and the evolving landscape of privileged access. What Is a Privileged User and a Privileged Account?

Strategy 183

Strategy Architecture Network Database 183

DZone

DECEMBER 24, 2023

Do they involve disk I/O, such as file read/write operations, network I/O, which includes data transmission over a network, or database I/O, comprising database interactions? I have taken up the I/O bottlenecks related to Network and file read/write operations for this article.

Network 177

Network Strategy Database Code 177

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

SQL Shack

NOVEMBER 9, 2021

This is the second article in the series of Migrating SQL Server Objects using SSDT 2017. In this article, we will learn how to copy user stored procedures created in the SQL Server master database. You can […].

Database 81

Database Servers Monitoring Performance 81

SQL Shack

OCTOBER 6, 2021

This article gives an insight into the configuration of Min and Max memory for SQL Server Database instances. Introduction The server performance depends on various factors such as CPU, Memory, and Storage configurations. SQL Server works on top of the operating system and works closely with these resources.

Database 88

Database Servers Operating System Storage 88

SQL Shack

APRIL 7, 2021

This article will explore the process to capture deadlock XML and deadlock graphs for AWS RDS SQL Server databases. Introduction As a database professional, you confront the performance issues with databases. It is essential to […].

AWS 74

AWS Database Servers Processing 74

Percona

MAY 1, 2023

It has default settings for all of the database parameters. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. The performance of a PostgreSQL database has a significant impact on the overall effectiveness of an application.

Tuning 52

Tuning Efficiency Database Performance 52

SQL Shack

AUGUST 16, 2019

A graph database is a type of NoSQL database that is based on graph theory. Graph databases are ideal for storing data that has complex many to many relationships. In this article, we will study the very basics of graph databases with the help of a simple example.

Database 79

Database Servers Monitoring 79

Percona Community

MARCH 29, 2023

One article was devoted to the Pagila standard DB schema and another to generating test data with Python. I’ve decided to continue this tradition and write an article about generating data using SQL.

Testing 98

Testing Database Efficiency 98

DZone

SEPTEMBER 26, 2023

Since you need to access multiple components (servers, databases, network infrastructure, applications, etc.) In this article, we’re going to take a look at how logging can help you make sense of your log data without much effort. Though it can feel like more trouble than it’s worth, sorting through logs is crucial.

Best Practices 249

Best Practices Analytics Infrastructure Network 249

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

SQL Shack

JANUARY 13, 2020

In this article, we will discuss the best practices that should be followed in order to keep the TempDB database in a healthy state and prevent any unexpected growth of the database, in addition to the procedure that can be followed to detect this unexpected growth once occurred.

Database 83

Database Best Practices Design Performance 83

SQL Shack

JULY 30, 2020

This is the 8th article in the series for SQL Server Always On Availability Groups. Introduction SQL Server Always On Availability Groups create a group of databases that fails over together in case the primary replica is unavailable. By default, SQL Server […].

Availability 88

Availability Database Servers 88

DZone

APRIL 11, 2023

This article will explore how these technologies can be used together to create an optimized data pipeline for data processing in the cloud. It provides built-in connectors for various data sources such as databases, file systems, cloud storage, and more.

Azure 246

Azure Analytics Storage Cloud 246

DZone

DECEMBER 17, 2021

The load testing for the database needs to be conducted usually so that the impact on the system can be monitored in different scenarios, such as query language rule optimization, storage engine parameter adjustment, etc. The operating system in this article is the x86 CentOS 7.8. Why Load Testing Matters in Nebula Graph?

Testing 240

Testing Operating System Storage Performance 240