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

Scalegrid

MAY 13, 2020

It can scale towards a multi-petabyte level data workload without a single issue, and it allows access to a cluster of powerful servers that will work together within a single SQL interface where you can view all of the data. At a glance – TLDR. The Greenplum Architecture. Greenplum Advantages. Major Use Cases.

Big Data 321

Big Data Database Artificial Intelligence Open Source 321

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 107

Availability Database Open Source Hardware 107

Dynatrace

NOVEMBER 3, 2023

While Python code can address most data acquisition and ingest requirements, it comes at the cost of complexity in implementation and use-case modeling. address these limitations and brings new monitoring and analytical capabilities that weren’t available to Extensions 1.0: available, and more are in the pipeline. Extensions 2.0

Technology 240

Technology Technology Scalability Availability 240

SQL Shack

OCTOBER 12, 2020

It is the 30th article in the SQL Server Always On Availability Groups series and explores column-level SQL Server encryption with AG groups. Introduction We might have sensitive data in our SQL database such as customers’ credit card details, bank account details, social security numbers, and medical history.

Servers 105

Servers Availability Database 105

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

SQL Shack

SEPTEMBER 29, 2020

In this 28th article for SQL Server Always On Availability Group series, we explore the high-availability for the SQL Server PolyBase(SSB) external tables using AG groups. Previously, to access data from […].

Servers 99

Servers Availability Virtualization Database 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 99

Availability Monitoring Open Source Traffic 99

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 98

Open Source Servers Database Strategy 98

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 83

Availability Open Source Architecture Database 83

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

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. We plan to make Percona images for PostgreSQL available on Docker Hub shortly. What’s next in store?

Availability 108

Availability Open Source Database Servers 108

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

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 96

Architecture Availability Open Source Healthcare 96

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

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

SQL Shack

SEPTEMBER 22, 2020

This is the 25th article in SQL Server Always On Availability Groups series. In this article, we will explore the high availability configuration for reporting services databases. Data […].

Servers 65

Servers Availability Database Mobile 65

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 78

Availability Hardware Open Source Database 78

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 166

Metrics Monitoring Database Network 166

SQL Shack

MAY 9, 2019

In my previous article Data Synchronization in SQL Server Always On Availability Group, we described a scenario where if a secondary replica goes down in synchronous data commit mode, SQL Server Always on Availability group changes to asynchronous data commit mode.

Availability 44

Availability Servers 44

Dynatrace

JULY 31, 2020

We’re happy to announce the General Availability of cross-environment dashboarding capabilities (having released this functionality in an Early Adopter release with Dynatrace version 1.172 back in June 2019). Visualize data from multiple environments on a single dashboard.

Availability 174

Availability Best Practices Monitoring Network 174

Scalegrid

MAY 13, 2019

MySQL Server generates several logs that can help you monitor the activities of the server. Setting Up MySQL Server Logging. Managing MySQL Server Logs: Rotate, Compress, Retain & Delete Click To Tweet. MySQL Tutorial – Configuring and Managing SSL On Your MySQL Server.

Servers 247

Servers Best Practices Efficiency Availability 247

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

SQL Shack

MAY 3, 2019

This article describes the data synchronization process on SQL Server Always On Availability Groups in both Synchronous, and Asynchronous data commit mode. High data availability is an important aspect of every DBA’s life. We need to minimize and mitigate the issues related to database unavailability.

Availability 45

Availability Servers Database Processing 45

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 96

Servers Database Cache C++ 96

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

DZone

AUGUST 16, 2023

Caching is the process of storing frequently accessed data or resources in a temporary storage location, such as memory or disk, to improve retrieval speed and reduce the need for repetitive processing. Bandwidth optimization: Caching reduces the amount of data transferred over the network, minimizing bandwidth usage and improving efficiency.

Cache 246

Cache Scalability Performance Latency 246

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

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

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. But before going with the MySQL Community Edition, you should look at Percona Server for MySQL. Why Percona Server for MySQL?

Servers 118

Servers Open Source Tuning C++ 118

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

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

Percona

FEBRUARY 2, 2023

Database Administrators (DBAs) must implement robust authentication mechanisms to ensure that only authorized users can access the database and its data. PostgreSQL server authentication refers to verifying the identity of a user trying to connect to the PostgreSQL server.

Database 123

Database Servers Testing Programming 123

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

Percona

JANUARY 5, 2024

The AWS KMS component is now available in Percona Server for MySQL starting from version 8.0.30. This addition enables data-at-rest encryption by utilizing the AWS KMS component, providing the functionality to create and manage cryptographic keys across AWS services.How do we set up encryption using AWS KMS?You

AWS 87

AWS Servers Availability Cloud 87