Percona

NOVEMBER 1, 2023

Without going further into the reasons for such a need, I wanted to refresh this subject in terms of overhead related to running the command on production systems. A lot has changed since then, but many production systems alive today still run with affected versions. Let’s recap how the situation has evolved over the years.

Servers 101

Servers Database Cache C++ 101

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 101

Database C++ Servers Open Source 101

Dynatrace

AUGUST 3, 2020

These services are responsible for core components of the Windows operating system and third-party applications. For example: To provide support, you need a remote desktop service to be available. You also require part of your infrastructure to serve an MS SQL database with MS Distributed Transaction Coordinator.

Infrastructure 155

Infrastructure Availability Monitoring Operating System 155

Dynatrace

MARCH 6, 2024

IBM i, formerly known as iSeries, is an operating system developed by IBM for its line of IBM i Power Systems servers. It is based on the IBM AS/400 system and is known for its reliability, scalability, and security features. Some tools demand the installation of agents on those systems and provide complex, disconnected views.

Monitoring 234

Monitoring Infrastructure Metrics Analytics 234

High Scalability

APRIL 16, 2019

In this three-part blog series, we introduced a High Availability (HA) Framework for MySQL hosting in Part I, and discussed the details of MySQL semisynchronous replication in Part II. Now in Part III, we review how the framework handles some of the important MySQL failure scenarios and recovers to ensure high availability.

Availability 149

Availability Network Azure AWS 149

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 78

Database Open Source Servers Code 78

SQL Shack

OCTOBER 20, 2020

In this 33rd article of SQL Server Always On Availability Group series, we will use extended events to monitor the availability group. Introduction Database professionals’ primary role is to do proactive monitoring for ensuring system availability. You can use […].

Availability 107

Availability Monitoring Servers Database 107

Scalegrid

OCTOBER 2, 2019

October 2, 2019 – ScaleGrid, a rapidly growing leader in the Database-as-a-Service (DBaaS) space, has just launched their new fully managed Hosting on Azure for Redis™ service. Redis™, the #1 key-value store and top 10 database in the world, has grown by over 300% in popularity over that past 5 years, per the DB-Engines knowledge base.

Azure 100

Azure Availability Open Source Virtualization 100

High Scalability

APRIL 3, 2019

PostgreSQL is an open source object-relational database system that has soared in popularity over the past 30 years from its active, loyal, and growing community. For the 2nd year in a row, PostgreSQL has kept the title of #1 fastest growing database in the world according to the DBMS of the Year report by the experts at DB-Engines.

Database 177

Database Cloud Open Source Systems 177

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

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 343

Open Source Java Operating System Programming 343

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 204

Cache Azure Infrastructure Monitoring 204

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

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

Dynatrace

MARCH 20, 2024

External dependencies Many applications rely on external services, such as databases, APIs, or third-party services. Infrastructure health The underlying infrastructure’s health directly impacts application availability and performance. Consider a scenario where a web application depends on an external payment gateway.

Open Source 267

Open Source Hardware DevOps Infrastructure 267

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

The Netflix TechBlog

APRIL 27, 2023

Ruchir Jha , Brian Harrington , Yingwu Zhao TL;DR Streaming alert evaluation scales much better than the traditional approach of polling time-series databases. It allows us to overcome high dimensionality/cardinality limitations of the time-series database. Engineers want their alerting system to be realtime, reliable, and actionable.

Storage 288

Storage Cache Metrics Database 288

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. It may be challenging to anticipate erroneous actions of users, but luckily, several tools are available to help in destructive testing.

Systems 81

Systems Testing Software Software 81

Dynatrace

MARCH 27, 2024

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. Keeping ownership teams and their properties up to date is essential, as is having the right contact information available when needed. Contact us to schedule a demo.

Best Practices 199

Best Practices Azure Database Code 199

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

Percona

OCTOBER 10, 2023

Assuming that there is already a Secrets object holding all system user passwords, the concept is really simple. mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02 One convenient way that I’ve found working well is the use of an external POD running the percona-toolkit. We are going to create a Job.

Database 100

Database Performance C++ Engineering 100

Scalegrid

JANUARY 8, 2024

AI-driven cloud solutions like ScaleGrid offer a diverse range of database hosting options, robust infrastructure optimized for scalability and security, and enable significant cost reductions, supporting businesses in efficient growth and improved ROI. These services are tailored to meet various business requirements.

Artificial Intelligence 147

Artificial Intelligence Cloud Scalability Analytics 147

Dynatrace

OCTOBER 23, 2023

Microsoft Hyper-V is a virtualization platform that manages virtual machines (VMs) on Windows-based systems. It enables multiple operating systems to run simultaneously on the same physical hardware and integrates closely with Windows-hosted services. This leads to a more efficient and streamlined experience for users.

Efficiency 214

Efficiency Virtualization Hardware Performance 214

Dynatrace

FEBRUARY 1, 2024

But organizations must also be aware of the pitfalls of AI: security and compliance risks, biases, misinformation, and lack of insight into critical metrics (including availability, code development, infrastructure, databases, and more). AI implementations are no exception.

Artificial Intelligence 186

Artificial Intelligence Analytics Efficiency Database 186

Scalegrid

APRIL 16, 2020

Where you decide to host your cloud databases is a huge decision. But, if you’re considering leveraging a managed databases provider, you have another decision to make – are you able to host in your own cloud account or are you required to host through your managed service provider? Where to host your cloud database?

Cloud 242

Cloud Azure AWS Database 242

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 181

Infrastructure Metrics Network Monitoring 181

Scalegrid

MARCH 22, 2024

This process thoroughly assesses factors like cost-effectiveness, security measures, control levels, scalability options, customization possibilities, performance standards, and availability expectations. Ready to take your database management to the next level with ScaleGrid’s cutting-edge solutions?

Strategy 130

Strategy Cloud Government Innovation 130

The Netflix TechBlog

JUNE 12, 2023

To be a client systems engineer is to take joy in small endpoint automations that make your fellow employees’ day a little better. They can also facilitate automations that require information available only in the “login window” context, such as the provided username and password. We call this new tool Escrow Buddy.

Open Source 194

Open Source Database Servers Storage 194

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

MAY 19, 2022

Every organization’s goal is to keep its systems available and resilient to support business demands. Lastly, error budgets, as the difference between a current state and the target, represent the maximum amount of time a system can fail per the contractual agreement without repercussions. Dynatrace news. Saturation.

Automotive 270

Automotive Latency Architecture Azure 270

Scalegrid

JANUARY 11, 2024

Read also – Enterprise Cloud Security Strategy For 2024 Cloud Security Monitoring Tools and Techniques When it comes to monitoring cloud security, we have a wide range of tools and techniques available. These include real-time alerting features and a specialized dashboard that provides crucial database and OS metrics.

Best Practices 130

Best Practices Cloud Monitoring Strategy 130

Scalegrid

JANUARY 19, 2024

When a MongoDB rollback happens, it can cause trouble to your data integrity and system consistency. For example, memory-resident databases without persistent disks, such as Redis cluster setups or Apache Spark installations, rely on stand-alone machines.

Database 130

Database Network Servers Monitoring 130

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for effectively monitoring MySQL performance.

Performance 108

Performance Monitoring Traffic Database 108

Scalegrid

JUNE 6, 2019

June 6, 2019 – ScaleGrid , the Database-as-a-Service (DBaaS) leader in the SQL and NoSQL space, has announced the expansion of their fully managed MySQL Hosting services to support Amazon Web Services (AWS) cloud. PALO ALTO, Calif.,

AWS 191

AWS Cloud Open Source Virtualization 191

Scalegrid

JANUARY 20, 2020

Follower clusters are a ScaleGrid feature that allows you to keep two independent database systems (of the same type) in sync. Here are a few critical ways in which it differs from replication: You can control how frequently the destination system syncs from source – once a week, once a day, or even less frequently.

Analytics 185

Analytics Storage Database Systems 185

Scalegrid

JULY 17, 2019

July 17, 2019 – ScaleGrid, a leader in the Database-as-a-Service (DBaaS) space, has just announced support for PostgreSQL hosting in the cloud. The database is also widely loved for PostgreSQL extensions which enable users to extend the functionality of their database. PALO ALTO, Calif.,

Azure 182

Azure AWS Open Source Database 182

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 81

Open Source Healthcare Social Media Database 81