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 source, complete database backups solution for all […]
918 total views
The AWS Command Line Interface (CLI) is a unified tool to manage your AWS services. With just one tool to download and configure, you can control multiple AWS services from the command line and automate them through […]
812 total views
Create a VPC It will by default create router,securty groups ,NACLS, route tables Create an internet gateway (IG) and associate it with main RT Create 2 subnet in the VPC One public subnet, one private […]
641 total views, 1 views today
Whenever we are doing single block i/o on a table which is having index, the optimizer only has to traverse through the root—-branch—leaf and it will do a random i/o on the block address which […]
652 total views, 1 views today
pgBackRest aims to be a reliable, easy-to-use backup and restore solution that can seamlessly scale up to the largest databases and workloads by utilizing algorithms that are optimized for database-specific requirements . It is used to […]
784 total views, 1 views today
pgAdmin is the leading Open Source management tool for Postgres, the world’s most advanced Open Source database. It provides a powerful graphical interface that simplifies the creation, maintenance and use of database objects. If we […]
621 total views
If we talk about database , at high level all databases are simply data store and stored as a set of files on disk. In PostgreSQL inside the data directory , you will see many […]
615 total views, 2 views today
WAL-G is an archival restoration tool for Postgres(beta for MySQL, MariaDB, MongoDB and SQLServer) It is an continuous arching tool used to easily set up and recover from physical backup in Postgres. It mainly handles the storage […]
1,007 total views, 3 views today
I was trying to sync my standby database with incremental backup from production due to huge archive log gap of more than 500 archive. While trying to catalog the datafile for switching, the switching was […]
902 total views
We were trying to patch out GI home with Oct 2020 PSU, but the patch was not proceeding and every time it failed , when it was trying to bring the CRS down Executing patch […]
1,134 total views, 1 views today
