Export/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 MoreShowing posts with label Database Administration. Show all posts
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 More
MySQL GTID Replication and lower_case_table_names
Error 'Table 'EMPLOYEES.POSITION' doesn't exist' on query. Default database: 'employees'. Query: 'ALTER TABL...
Read More
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 More
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 More
Database Clusters with MongoDB Sharding
MongoDB supports horizontal scaling of the data with the help of the shared key. Shared key selection should be good and poor shared key spl...
Read More