SQL Server Always On availability group cluster in the AWS Cloud
Microsoft gives HA features like a charm . Lower to higher deployment costs its giving many features as per business requirements . Replicat...
Read Full Database GuideDatabase, Cloud and Migration Guides
Practical database guides, cloud migration notes and data engineering fixes for Oracle, SQL Server, MySQL, PostgreSQL, MongoDB, Percona, AWS, Azure, GCP, DigitalOcean and on-premises platforms.
Database OpsBackup, restore, HA/DR, security, monitoring, tuning and troubleshooting for production systems.
Cloud PlatformsHands-on notes for RDS, DMS, Glue, Azure SQL, Synapse, Data Factory and managed data services.
Migration GuidesPlanning, validation, replication, zero-downtime cutovers and post-migration checks.
Showing posts with label Database Administration. Show all posts
Redis to ElastiCache Migration in AWS
Comparing Redis , AWS ElastiCache giving multiple options to cache the data in cloud . Its enhanced with two ways of Access control opt...
Read Full Database GuideExport/Import Data on Amazon Oracle RDS using Data Pump utility
Its easy to refresh the schemas in Oracle RDS , We can do one time for Testing or Development Purpose But if its needs to run on daily basi...
Read Full Database Guide
Monitoring Data Growth With Query Exporter + Prometheus + Grafana
In this experimental scenario , gathering the table growth statistics using query exporter and loading the data into time series Prometheus...
Read Full Database Guide
MySQL GTID Replication and lower_case_table_names
Error 'Table 'EMPLOYEES.POSITION' doesn't exist' on query. Default database: 'employees'. Query: 'ALTER TABL...
Read Full Database Guide
Docker with Percona Backup for MongoDB
Sounds interesting from Percona Backup tool for MongoDB !!! I just wants to try and explore the tool with docker on today !!! Docker is firs...
Read Full Database Guide
Repair GTID Based Slave on Percona Cluster
Problem : We are running 5 node percona cluster on Ubuntu 16.04, and its configured with master-slave replication. Suddenly we got an alert...
Read Full Database Guide