Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. This guide provides an overview of what high availability means, the components involved, how to measure high availability, and how to achieve it. More in the following sub-section.)

Availability 109

Availability Database Open Source Hardware 109

DZone

JANUARY 3, 2022

An access log is generated by the web server to log the details about the request that it has processed. While doing any performance analysis, these logs play an important role. Most people are aware of the application server log but many of them are not aware of the web server/load balancer access log.

Performance 246

Performance Servers Code Availability 246

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

FEBRUARY 17, 2020

In a MySQL master-slave high availability (HA) setup, it is important to continuously monitor the health of the master and slave servers so you can detect potential issues and take corrective actions. MySQL Master Server Health Checks. Important Health Checks for your MySQL Master-Slave Servers Click To Tweet.

Servers 273

Servers Monitoring Availability Programming 273

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 99

Open Source Servers Database Strategy 99

Percona

DECEMBER 21, 2023

Being software composed of different, multiple technologies can add complexity to a well-known concept: High Availability (HA). As you can see, stats are available via the port 8404. And here is the not-so-easy part: One has to deploy at least two PMM instances on at least two different servers AND set up replicas. How to do it?

Availability 101

Availability Monitoring Open Source Traffic 101

Percona

JULY 7, 2023

With the average cost of unplanned downtime running from $300,000 to $500,000 per hour , businesses are increasingly using high availability (HA) technologies to maximize application uptime. Where a high availability design once worked well, it can no longer keep up with more complex requirements.

Availability 85

Availability Open Source Architecture Database 85

Dynatrace

JULY 11, 2023

IBM Power servers enable customers to respond faster to business demands, protect data from core to cloud, and streamline insights and automation. Captures metrics, traces, logs, and other telemetry data in context. Having all data in context tremendously simplifies analytics and problem detection.

Architecture 164

Architecture Availability Infrastructure Metrics 164

Dynatrace

OCTOBER 23, 2023

Hyper-V plays a vital role in ensuring the reliable operations of data centers that are based on Microsoft platforms. Secondly, determining the correct allocation of resources (CPU, memory, storage) to each virtual machine to ensure optimal performance without over-provisioning can be difficult. What is Microsoft Hyper-V?

Efficiency 206

Efficiency Virtualization Hardware Performance 206

Percona

SEPTEMBER 19, 2023

It looks like we succeeded, and I’m happy to announce that Percona Distribution for PostgreSQL 16 is now available! To highlight some: Logical replication from standby servers is now supported natively by PostgreSQL. Improved vacuum freezing performance. PostgreSQL 16 comes packed with features. What’s next in store?

Availability 110

Availability Open Source Database Servers 110

Dynatrace

MAY 17, 2023

Making applications observable—relying on metrics, logs, and traces to understand what software is doing and how it’s performing—has become increasingly important as workloads are shifting to multicloud environments. However, this method limited us to instrumenting the code manually and collecting specific sets of data we defined upfront.

Metrics 166

Metrics Monitoring Database Network 166

Scalegrid

MARCH 12, 2019

Are you deploying PostgreSQL in the cloud and want to understand your options for achieving high availability? In our previous blog post, Managing High Availability in PostgreSQL – Part I , we discussed the capabilities and functioning of PostgreSQL Automatic Failover (PAF) by ClusterLabs. How it Works.

Availability 147

Availability Servers Open Source Database 147

Dynatrace

MARCH 18, 2024

Following FinOps practices, engineering, finance, and business teams take responsibility for their cloud usage, making data-driven spending decisions in a scalable and sustainable manner. Empowering teams to manage their FinOps practices, however, requires teams to have access to reliable multicloud monitoring and analysis data.

Best Practices 225

Best Practices Strategy Cloud AWS 225

Percona

JUNE 12, 2023

When it comes to access to their applications, users demand instant, reliable, and secure interactions — and that means databases must be highly available. With database high availability (HA), services are largely uninterrupted, and end users are largely satisfied. The obvious answer is this: To achieve high availability.

Architecture 97

Architecture Availability Open Source Healthcare 97

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 153

Database Government Games Servers 153

Percona

MARCH 23, 2023

This blog is in reference to our previous ones for ‘Innodb Performance Optimizations Basics’ 2007 and 2013. Although there have been many blogs about adjusting MySQL variables for better performance since then, I think this topic deserves a blog update since the last update was a decade ago, and MySQL 5.7

Performance 127

Performance Hardware Tuning Storage 127

Percona

AUGUST 22, 2023

With so much at stake, database high availability and fault tolerance have become must-have items, but many companies just aren’t certain which one they must have. This blog article will examine shared attributes of high availability (HA) and fault tolerance (FT). What does high availability mean?

Availability 80

Availability Hardware Open Source Database 80

Dynatrace

AUGUST 16, 2022

The data locked in your log files can be a goldmine for your application developers, operations teams, and your enterprise as a whole. However, it can be complicated , expensive , or even impossible to set up robust observability that makes use of this data. Log format inconsistency makes it a challenge to access critical data.

Processing 181

Processing Metrics Monitoring Java 181

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 105

Performance Monitoring Traffic Database 105

Percona

MARCH 1, 2023

So you get the Umaluts, Cedils, and C-J-K Language support in your data, plus emojis. EXPLAIN without the ANALYSE gives you the server’s estimated analysis of the performance of your query. Adding ANALYSE causes the query to execute, and the numbers returned to report the real numbers of the query’s performance.

Servers 119

Servers Open Source Tuning C++ 119

Scalegrid

MARCH 28, 2024

In this comparison of Redis vs Memcached, we strip away the complexity, focusing on each in-memory data store’s performance, scalability, and unique features. Redis and Memcached both provide high performance with sub-millisecond response times. Managed DBaaS solutions like ScaleGrid.io

Cache 130

Cache Storage Scalability Architecture 130

Dynatrace

APRIL 13, 2023

The massive volumes of log data associated with a breach have made cybersecurity forensics a complicated, costly problem to solve. As organizations adopt more cloud-native technologies, observability data—telemetry from applications and infrastructure, including logs, metrics, and traces—and security data are converging.

Analytics 178

Analytics Java Infrastructure Cloud 178

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. Disk-level encryption is a security measure that encrypts all data stored on a disk or storage device.

Database 93

Database Storage Servers Strategy 93

SQL Performance

AUGUST 1, 2022

Recently I covered some of the T-SQL improvements in SQL Server 2022 here , and Aaron Bertrand covered additional improvements here. Microsoft just announced the release of SQL Server 2022 CTP 2.1. For example, suppose that prior to SQL Server 2022 you had the following query: SELECT. So far so good. FROM T1 INNER JOIN T2 ON T1.

Servers 142

Servers Testing C++ Code 142

Scalegrid

FEBRUARY 8, 2024

A distributed storage system is foundational in today’s data-driven landscape, ensuring data spread over multiple servers is reliable, accessible, and manageable. Understanding distributed storage is imperative as data volumes and the need for robust storage solutions rise.

Storage 130

Storage Systems Big Data Azure 130

Dynatrace

JANUARY 11, 2023

To stay competitive in an increasingly digital landscape, organizations seek easier access to business analytics data from IT to make better business decisions faster. As organizations add more tools, it creates a demand for common tooling, shared data, and democratized access. These technologies generate a crush of observability data.

Analytics 182

Analytics Strategy Storage Technology 182

Dynatrace

APRIL 17, 2024

Mainframe is a strong choice for hybrid cloud, but it brings observability challenges IBM Z is a mainframe computing platform chosen by many organizations with a hybrid cloud strategy because of its security, resiliency, performance, scalability, and sustainability. You can take your Dynatrace Grail™ analysis of log data further in Notebooks.

Operating System 197

Operating System Energy Infrastructure Architecture 197

DZone

MARCH 31, 2020

The true power of cloud computing lies in the way it can be optimized for maximum performance and efficiency. While it wasn’t always possible to run an efficient environment while maximizing performance with on-premise servers and data centers, cloud clusters are particularly flexible in this respect.

AWS 170

AWS Performance Efficiency Scalability 170

Dynatrace

JULY 29, 2021

Using existing storage resources optimally is key to being able to capture the right data over time. In this blog post, we announce: Compression of transaction data that’s older than three days. Improvements to Adaptive Data Retention. Transaction-data compression for Dynatrace Managed environments.

Storage 190

Storage Virtualization Infrastructure Availability 190

Dynatrace

SEPTEMBER 5, 2023

Running Databases efficiently is crucial for business success Monitoring databases is essential in large IT environments to prevent potential issues from becoming major problems that result in data loss or downtime. This makes them ideal for managing structured data. What’s next?

Database 194

Database Metrics Monitoring Servers 194

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

Dynatrace

FEBRUARY 27, 2024

As business goals and technology efforts continue to converge, organizations need to ensure teams are performing to their full potential. When users encounter issues with applications or services, performance and productivity drop. Business considerations are now part of the security, operations, and development framework.

Best Practices 227

Best Practices Metrics AWS Innovation 227

Scalegrid

DECEMBER 9, 2019

However, discarding a server like this is expensive and inefficient. In this blog post, we will explain an approach to detect and fix transactions on the crashed MySQL master server in a semisynchronous replication setup, and how to re-slave it back into your master-slave setup. As a result, the data inconsistency may go undetected.

Servers 160

Servers Database Processing Availability 160

SQL Performance

SEPTEMBER 21, 2022

The need to manipulate data at the bit level with bitwise operations isn’t common in T-SQL, but you might stumble into such a need in some specialized scenarios. Even SQL Server stores some flag-based data using bitwise representation. Setting the server configuration option “ user options” using bitwise representation.

Servers 122

Servers C++ Code Cache 122

Percona

JANUARY 4, 2024

Managing storage and performance efficiently in your MySQL database is crucial, and general tablespaces offer flexibility in achieving this. They provide flexibility in data organization and performance optimization compared to the default setup. What are MySQL general tablespaces?

Storage 89

Storage Engineering Database Hardware 89

Speed Curve

FEBRUARY 5, 2024

That performance golden rule still holds true today. Server-timing headers are a key tool in understanding what's happening within that black box of Time to First Byte (TTFB). Cue server-timing headers Historically, when looking at page speed, we've had the tendency to ignore TTFB when trying to optimize the user experience.

Servers 57

Servers Cache Retail Benchmarking 57

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 85

Servers Database Open Source Scalability 85