Archive for November 2021

Access MySql database from PostgreSQL using MySQL Foreign Data Wrapper (MYSQL_FDW) 0 (0)

November 23, 2021

Access MySQL database from PostgreSQL using MySql Foreign Data Wrapper (MYSQL_FDW) The MySQL Foreign Data Wrapper (mysql_fdw) is a Postgres extension that allows you to access data that resides on…

Loading

📌
0💬 read more

Perform Mysql Physical Backup using Percona Xtrabackup 0 (0)

November 18, 2021

Perform Mysql Physical Backup using Percona Xtrabackup The Percona XtraBackup tools provide a method of performing a hot backup of your MySQL data while the system is running. Percona XtraBackup is a free, online, open…

Loading

📌
0💬 read more

Steps to enable HugePages in PostgreSQL 0 (0)

Steps to enable HugePages in PostgreSQL By default, the page size on Linux is 4kb. A typical PostgreSQL instance may allocate many GBs of memory, which will end up with…

Loading

📌
0💬 read more

Steps to Install Percona XtraBackup for MySQL 0 (0)

November 15, 2021

Steps to Install Percona XtraBackup for MySQL The Percona XtraBackup tools provide a method of performing a hot backup of your MySQL data while the system is running. Percona XtraBackup…

Loading

📌
0💬 read more

Configure and monitor using pg_profile in PostgreSQL 0 (0)

November 9, 2021

Configure and monitor using pg_profile in PostgreSQL This extension for PostgreSQL helps you to find out the most resource-consuming activities in your PostgreSQL databases. Extension is based on statistic views…

Loading

📌
0💬 read more