DBA expertise: PostgreSQL, SQL Server & MySQL
Welcome back to the Deadlock Buster series. Today we’re looking at PSBlitz, a PowerShell tool by Vlad Drumea. PSBlitz runs Brent Ozar’s SQL Server First Responder Kit under the hood to generate a comprehensive SQL Server health report. It’s fast, practical, and built for DBAs who want signal over noise. You can export the results to HTML or Excel for easy review and sharing….
pgEdge delivers multi-primary (aka master-master) Postgres replication, so every node is read/write. Unlike Patroni or traditional streaming replication—where one primary handles writes and the rest are read-only—pgEdge lets all nodes accept writes. That enables true geo-distribution for lower latency and better performance, and it simplifies operations: fewer failovers, less downtime, and no single leader to…
Deadlocks are one of the worst scenarios a DBA will face. They happen when two sessions are fighting for resources and each one is holding a lock the other needs. At that point, the SQL Server engine will choose one session to kill — this is called the deadlock victim. The reality is you cannot eliminate…
As a database grows in size due to frequent insertions, deletions, and updates, even straightforward SELECT queries can become slower. When a table grows to a point where it’s unwieldy, the overall size of the database increases significantly. This is where table partitioning can be incredibly beneficial. Partitioning involves dividing a large table into smaller,…
SQL Server log shipping is one of the DR solutions which involves two or more SQL Server instances; the source server is called the Primary Server and the destination is called Secondary server(s). Log shipping involves the transferring of the transaction log file from the primary server to the secondary server. Log Shipping is a…
Contained Availability Groups (CAGs) in SQL Server 2022 allow you to create an availability group that is independent of the instance, separating logins, jobs, and database mail from the main SQL Server instance. This is particularly useful when you want to create an availability group for a specific application while keeping its authentication and configurations…
enable auditing can be done on both community and enterprise edition and its strait forward option for best approach we will use enable auditing permanently enabling auditing navigate to the below directory cd /usr/share/mysql-8.0/ run the below command to run script to install audit plugin mysql -u root -p -D mysql < audit_log_filter_linux_install.sql verify that…
Getting MySQL Report from pt-mysql-summary This tool will generate report what is configuration for MySQL instance , how many replica MySQL has Or if the MySQL itself is replica , how many uses are connected What are the users doing How many databases How bug us innodb buffer pool size What is the version of…
to achieve the best result in troubleshooting it is highly recommended to install percona toolkit it contains tool that will help resolve replication error Coordinator stopped because there were error(s) in the worker(s). when we use the command show replica status\G we found The error message you received indicates that there was a failure in…
installing MySQL Enterprise db1 & db2 we already downloaded the MySQL enterprise iso and added it on vm we have added three spread disk on the vm that we use to create separate directory for the following MySQL data dir MySQL bin-log MySQL backup also make sure to disable selinuix once we have setup the…