Replication enables the data from one MySQL database server (master)to be copied to one or more servers ( slaves ). MySQL Replication is Async by default; slaves do not need to be connected permanently to receive updates from a source.…
Backing up the database and having a recovery plan to recover from any disaster or human error is one of the most important task of the administrators You can have a replication cluster, high availability setup on multiple data centers…
Most of the time the default location differs based on the operating system and sometimes depends on the version also the location may change, and also maybe depend on how you install the server. To get the location of postgresql.conf…
Sometimes, we need to change the default database data directory to some other path in the system. There could be many scenarios you may need to change the data directory, Your operating system will run on medium performance disk and…
In the earlier blogs we see about installing the other relational databases in the AWS EC2 instances, now I started exploring the options to integrate the NoSQL database with our Backup and DR application In this blog lets see on…
PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. It is a popular choice for many small and large projects and has the advantage of being standards-compliant and having many advanced…
Fat Jar is also know as uber jar which consists of all the classes along with the dependencies required to the run the application. Setup build.gradle Override the default JAR task By default jar task build jar without any dependencies,…
Creating the snapshot of our EBS volume of the EC2 Instance is one of the great strategies for backing up the data stored in EBS What is snapshot You can back up the data on your Amazon EBS volumes to…
I have been building the data protection software for the datacenter and public cloud and i have explored multiple backup products. I am adding my thoughts based on the challenges i faced, based on my interaction with my customers, based…
Information managed by the MySQL server is stored under a directory known as the data directory. Data directory subdirectories. Each subdirectory of the data directory is a database directory and corresponds to a database managed by the server. All MySQL…
