SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. These topics apply to both SQL Server Reporting Services as well as Power BI Report Server.

Tuning 67

Tuning Servers Database Best Practices 67

Scalegrid

MARCH 8, 2024

This article delivers a practical roadmap for using backups and binary logs to achieve accurate MySQL recovery, detailed steps for setting up your server, and tips for managing recovery and backups effectively without overwhelming you with complexity. It relies heavily on binary log files to record the incremental changes needed for recovery.

Database 162

Database Strategy Servers Best Practices 162

Percona

AUGUST 15, 2023

In this blog post, I provide an in-depth introduction to MySQL Replication, answering what it is, how it works , its benefits and challenges, as well as reviewing some of the MySQL replication concepts that are part of the MySQL environment (and Percona Server for MySQL specifically). What is MySQL Replication?

Servers 52

Servers Database Availability Traffic 52

Percona

AUGUST 30, 2023

Human mistakes: Incorrect configuration is an all-too-common cause of hardware and software failure. People used to say, “Coal is king,” and for decades, it was. Coal powered just about everything, but mismanagement and a lack of stewardship left some messes. These days, “Data is king,” and a lot more.

Database 85

Database Hardware Open Source Strategy 85

Percona

FEBRUARY 24, 2023

In the Home Dashboard of PMM, a low CPU utilization on any of the database services that are being monitored could mean that the server is inactive or over-provisioned. Marked in red in Figure 1 is a server with less than 30% of CPU usage. Configuration of the CPU metrics can be changed in the dashboard.

Cloud 117

Cloud Serverless AWS Storage 117

The Netflix TechBlog

DECEMBER 17, 2019

CDC is becoming increasingly popular for use cases that require keeping multiple heterogeneous datastores in sync (like MySQL and ElasticSearch) and addresses challenges that exist with traditional techniques like dual-writes and distributed transactions [3][4]. Therefore, dumps are needed to capture the full state of a source.

Database 197

Database Traffic Transportation Open Source 197

The Netflix TechBlog

DECEMBER 17, 2019

CDC is becoming increasingly popular for use cases that require keeping multiple heterogeneous datastores in sync (like MySQL and ElasticSearch) and addresses challenges that exist with traditional techniques like dual-writes and distributed transactions [3][4]. Therefore, dumps are needed to capture the full state of a source.

Database 212

Database Traffic Transportation Open Source 212