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. The restoration capability is primarily dependent on binary log files.

Database 162

Database Strategy Servers Best Practices 162

Percona

JULY 2, 2023

The DBA’s Role in Database Management The Database Administrator (DBA) is important in backup management, maintaining data integrity, and ensuring business continuity. It generates output as a text file containing the SQL commands that can be used to reconstruct the database and restore data or to make database migrations easier.

Strategy 52

Strategy Database Storage Open Source 52

Percona

AUGUST 30, 2023

Depending on what is needed, here are some common database backup types, strategies, and considerations: Full backup vs. incremental backup: Best suited for smaller databases or those that don’t incur a lot of changes, a full backup includes a complete restore point. This includes both data and log backups.

Database 85

Database Hardware Open Source Strategy 85

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

Percona

SEPTEMBER 1, 2023

MySQL server performance can sometimes be perplexing, and if you’ve ever wondered about the role of triggers in influencing your MySQL server’s memory allocation, this post is for you. This code can include SQL statements, procedures, or other actions defined within the trigger. What is a Trigger in MySQL?

Cache 59

Cache Database Games Healthcare 59

Percona

MAY 15, 2023

Also, in the case of multi-Primary, the writes will be distributed by transaction. If I have a node that manages only the items, another one the orders, and another one the payments, I will need to have my solution able to deal with distributed transactions, each of which needs to certify and verify other nodes’ data.

Traffic 121

Traffic Scalability Database Servers 121

SQL Server According to Bob

JANUARY 11, 2020

Microsoft, ​​ Windows, ​​ Windows NT, ​​ and Windows Server ​​ are registered trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Servers 40

Servers Cache Database Media 40