Scalegrid

MARCH 8, 2024

Data loss or corruption can be daunting. 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.

Database 162

Database Strategy Servers Best Practices 162

Scalegrid

DECEMBER 9, 2019

However, when the crashed master comes back, you may find that it has transactions that are not present in the current master (which was previously a slave). However, discarding a server like this is expensive and inefficient. Why Is It Important to Detect Extra Transactions on the Recovered Master? In a MySQL 5.7

Servers 160

Servers Database Processing Availability 160

Percona

SEPTEMBER 19, 2023

In the world of data backup and security, physical backups play an extremely important role. This type of backup is suitable for large, important databases that need to be recovered quickly when problems occur. In addition to databases, the backup can include any related files, such as log or configuration files.

C++ 107

C++ Servers Storage Speed 107

SQL Performance

JANUARY 20, 2022

All through my career as a data professional, both inside Microsoft and as a consultant, I’ve found one of the most misunderstood parts of a SQL Server database is the transaction log. Performance issues from repeated shrinking of the transaction log. Basic Terminology Around Logging.

Servers 54

Servers Database Architecture Performance 54

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). Set the server-id to a unique value.

Servers 52

Servers Database Availability Traffic 52

Percona

AUGUST 30, 2023

These days, “Data is king,” and a lot more. Data powers everything, and unlike coal and coal combustion, data and databases aren’t going away. Any organization that uses personal and other sensitive data must have a firm, proven plan for business continuity in the event of a disaster or cyberattack.

Database 90

Database Hardware Open Source Strategy 90

Percona

JULY 2, 2023

It is very important to understand how we can ensure minimalistic or no data loss at the time of disasters using our preferred backup tools. PostgreSQL backups are essential for safeguarding critical data and mitigating potential risks. This blog was originally written in September 2018 and was updated in June 2023.

Strategy 52

Strategy Database Storage Open Source 52