DZone

FEBRUARY 19, 2024

Almost every software development process involves secrets: credentials for your developers to access your version control system (VCS) like GitHub, credentials for a microservice to access a database, and credentials for your CI/CD system to push new artifacts to production.

Database 254

Database Code Software Software 254

Percona

MAY 2, 2023

The common use cases involve sharing pt-mysql-summary, pt-stalk, and other OS-related details to assist Support Engineers or any other third-party team troubleshoot database-related issues. Sometimes crucial data sharing is avoided because of compliance rules, organizational policies, or numerous security concerns.

Database 89

Database Systems Open Source Engineering 89

DZone

OCTOBER 23, 2023

In most financial firms, online transaction processing (OLTP) often relies on static or infrequently updated data, also called reference data. NoSQL databases emerge as ideal candidates to meet these requirements, and cloud platforms such as AWS offer managed and highly resilient data ecosystems.

AWS 266

AWS Performance Database Architecture 266

Percona

APRIL 14, 2023

Below, we outline some proactive steps for achieving cost efficiency and maintaining performant database environments amid a turbulent economy: 1. Here are a few ways you can scale down and save: Audit your systems: Auditing your system for unused servers and eliminating those servers can reduce your cloud spend.

Database 79

Database Serverless Tuning Cloud 79

Scalegrid

JANUARY 5, 2024

If you’re considering a database management system, understanding these benefits is crucial. DBMS enhances data security with encryption, implements various access controls, and enables improved data sharing and concurrent access, thus facilitating quick response to changes and maintaining consistent database accuracy.

Efficiency 147

Efficiency Storage Database Scalability 147

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

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 93

Database C++ Servers Open Source 93

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

JANUARY 23, 2021

If you need to dynamically trace Linux process system calls, you might first consider strace. According to a performance test conducted by Arnaldo Carvalho de Melo, a senior software engineer at Red Hat, the process traced using strace ran 173 times slower, which is disastrous for a production environment. The answer is YES.

Systems 166

Systems Performance Software Engineering Performance Testing 166

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

Dynatrace

FEBRUARY 1, 2024

The complex interconnections in cloud-based systems make it crucial to always have a topological overview to understand dependencies. Any problem, such as a simple software update overburdening a critical database, can cause a ripple effect that degrades the performance of dependent services or applications.

Infrastructure 183

Infrastructure Metrics Network Monitoring 183

HammerDB

OCTOBER 23, 2023

HammerDB uses stored procedures to achieve maximum throughput when benchmarking your database. However, there can be a lack of understanding of the benefits that stored procedures bring or if you have a benchmarking tool or database that doesn’t support stored procedures, then you have nothing to compare against.

Benchmarking 62

Benchmarking Database Network C++ 62

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

Highly Scalable

AUGUST 20, 2013

The shortcomings and drawbacks of batch-oriented data processing were widely recognized by the Big Data community quite a long time ago. It became clear that real-time query processing and in-stream processing is the immediate need in many practical applications.

Big Data 154

Big Data Processing Lambda Database 154

Dynatrace

JANUARY 31, 2024

GenAI is prone to erratic behavior due to unforeseen data scenarios or underlying system issues. The RAG process begins by summarizing and converting user prompts into queries that are sent to a search platform that uses semantic similarities to find relevant data in vector databases, semantic caches, or other online data sources.

Cache 206

Cache Azure Infrastructure Monitoring 206

Dynatrace

JANUARY 16, 2023

As Kubernetes adoption increases and it continues to advance technologically, Kubernetes has emerged as the “operating system” of the cloud. Kubernetes is emerging as the “operating system” of the cloud. The strongest Kubernetes growth areas are security, databases, and CI/CD technologies. Kubernetes moved to the cloud in 2022.

Open Source 344

Open Source Java Operating System Programming 344

Percona

JULY 31, 2023

Open source database architects usually do not implement business logic in their databases. This is in stark contrast to many commercial databases where this is a common practice. In the first case, all the heuristics are kept at the application layer, and the database has little or no effect on the data quality.

Database 73

Database Open Source Servers Code 73

Scalegrid

NOVEMBER 29, 2023

In today’s rapidly evolving digital landscape, the way we manage databases is undergoing a transformative shift. The rise of Database-as-a-Service (DBaaS) is not just a trend but a strategic response to the growing complexities of data management. However, using a database as a service is not without its set of challenges.

Healthcare 130

Healthcare Hardware Database Scalability 130

Dynatrace

MARCH 20, 2024

Deploying software in Kubernetes is often viewed as a straightforward process—just use kubectl or a GitOps solution like ArgoCD to deploy a YAML file, and you’re all set, right? External dependencies Many applications rely on external services, such as databases, APIs, or third-party services.

Open Source 269

Open Source Hardware DevOps Infrastructure 269

DZone

APRIL 11, 2023

Data processing in the cloud has become increasingly popular due to its scalability, flexibility, and cost-effectiveness. This article will explore how these technologies can be used together to create an optimized data pipeline for data processing in the cloud.

Azure 246

Azure Analytics Storage Cloud 246

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

Scalegrid

JANUARY 8, 2024

Key Takeaways AI integration in cloud computing increases operational efficiency by automating processes, optimizing resource allocation, and improving scalability, leading to cost savings and allowing IT teams to concentrate on strategic initiatives. Discover how AI is reshaping the cloud and what this means for the future of technology.

Artificial Intelligence 147

Artificial Intelligence Cloud Scalability Analytics 147

DZone

JANUARY 20, 2023

Having a distributed and scalable graph database system is highly sought after in many enterprise scenarios. Do Not Be Misled Designing and implementing a scalable graph database system has never been a trivial task.

Scalability 201

Scalability Big Data Hardware Internet 201

Scalegrid

JANUARY 19, 2024

When a MongoDB rollback happens, it can cause trouble to your data integrity and system consistency. Key Takeaways Rollbacks in MongoDB are triggered by disruptions in the replication process due to primary node crashes, network partitions, or other failures, which can lead to substantial data loss and inconsistencies.

Database 130

Database Network Servers Monitoring 130

Dynatrace

DECEMBER 12, 2021

The National Vulnerability Database describes the exploit here. In summary, the Log4Shell exploit allows an attacker to instruct the vulnerable system to download, and subsequently execute, a malicious command. Sensitive Data Access – Do the vulnerable Java processes access critical databases or file systems in the environment?

Java 241

Java Internet Internet Database 241

Percona

JANUARY 24, 2023

Databases on Kubernetes continue their rising trend. readyToUse: true – indicates that the snapshot is ready Restore The restoration process, in a nutshell, looks as follows: Create persistent volumes using the snapshots. But snapshots cannot provide you with the same RPO as native database mechanisms. AWS EBS Snapshots).

Database 65

Database Storage Open Source AWS 65

High Scalability

JANUARY 11, 2022

The streaming data store makes the system extensible to support other use-cases (e.g. System Components. The system will comprise of several micro-services each performing a separate task. The system will comprise of several micro-services each performing a separate task. Component Design. Posting on Instagram.

Design 334

Design Media Storage Logistics 334

Dynatrace

AUGUST 28, 2023

Let’s shift our focus to the backend systems and business processes, the behind-the-scenes heroes of end-to-end customer experience. These retail-business processes must work together efficiently to orchestrate customer satisfaction: Inventory management ensures you can anticipate and meet dynamic customer demand.

Retail 204

Retail Logistics Innovation Analytics 204

Testlodge

NOVEMBER 1, 2021

” Destructive testing is a method that uses the system in a way other than intended to make the software program deliberately fail. How the system responds is then analyzed. Other tools are automated that let the tester fuzz test the system using fault injection techniques. Data-Driven Tools. Automated Tools.

Systems 81

Systems Testing Software Software 81

The Morning Paper

MARCH 15, 2020

Understanding, detecting and localizing partial failures in large system software , Lou et al., Partial failures ( gray failures ) occur when some but not all of the functionalities of a system are broken. Here are the key findings: Partial failures appear throughout the release history of each system, 54% within the last three years.

Systems 98

Systems Software Software Programming 98

Scalegrid

JANUARY 25, 2024

Redis® is an in-memory database that provides blazingly fast performance. This makes it a compelling alternative to disk-based databases when performance is a concern. Redis returns a big list of database metrics when you run the info command on the Redis shell. This blog post lists the important database metrics to monitor.

Metrics 130

Metrics Monitoring Latency Cache 130

Dynatrace

MARCH 27, 2024

Secondly, knowing who is responsible is essential but not sufficient, especially if you want to automate your triage process. As teams and their structure and metadata are often maintained in a dedicated database, such as Microsoft Entra ID (formerly Azure Active Directory) or ServiceNow.

Best Practices 201

Best Practices Azure Database Code 201

Dynatrace

MARCH 20, 2024

With the pace of digital transformation continuing to accelerate, organizations are realizing the growing imperative to have a robust application security monitoring process in place. This approach can determine malicious activity and block it by monitoring the flow of data within the application, all the way from the user to the database.

Monitoring 213

Monitoring Analytics Traffic Best Practices 213

SQL Performance

APRIL 15, 2020

SQL Server has always provided the ability to capture actual queries in an easily-consumable rowset format – first with legacy SQL Server Profiler, later via Extended Events, and now with a combination of those two concepts in Azure SQL Database. Unfortunately, my excitement was short lived for a couple of reasons.

Azure 96

Azure Database Tuning Network 96

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. Understanding the PostgreSQL Hostname Hostname is a key factor for the effective management of PostgreSQL databases and providing secure access.

Database 130

Database Servers Storage Network 130

The Morning Paper

DECEMBER 5, 2019

Benchmarking spreadsheet systems Rahman et al., They often freeze during computation, and are unable to import datasets well below the size limits posed by current spreadsheet systems. While a database is barely getting started at 20,000 rows, a spreadsheet could be hanging. count) and lookups (VLOOKUP).

Benchmarking 56

Benchmarking Systems Google Scalability 56

Dynatrace

DECEMBER 12, 2021

The National Vulnerability Database describes the vulnerability here. In summary, the Log4Shell vulnerability allows an attacker to instruct the vulnerable system to download, and subsequently execute, a malicious command. Java processes with public-facing internet exposures are an easy target for this type of abuse.

Java 187

Java Internet Internet Database 187