how to enable auditing in PostgreSQL
Tracking any changes made at the database level is crucial for holding accountable any users with access to PostgreSQL. During […]
Health check using pgmetrics
One of the key tasks for any PostgreSQL DBA is conducting daily health checks to ensure the database remains healthy.
Uncategorized
PostgreSql logical replication
logical replication deterrent than stream replication , where the master will send wall log , there we send the actual
Uncategorized
PostgreSql how to sperate data directory for data dir
When installing PostgreSQL, it defaults to creating its data directory in /var/lib/postgresql. For better performance, reliability, and management, it is
Mysql replication troublshooting
${toc} to achieve the best result in troubleshooting it is highly recommended to install percona toolkit it contains tool that
mysql
MONITORING MYSQL
Getting MySQL Report from pt-mysql-summary This tool will generate report what is configuration for MySQL instance , how many replica
Uncategorized
Using percona xtrabackup for backup
taking backup percona xtrabackup is consider a hot backup that backup the whole data directory with its redo logs and