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,…
Recently i posted on Installing MariaDB on AWS EC2 instance and securing the installation. After securing the installation, the root user login is failing with error Access denied for user ‘root’@’localhost’ (using password: YES) The problem is the root user…
Recently I have posted on installing MySQL in Amazon Linux, Now I am trying to Integrate and test Maria Backup and Recovery integration. In our product we support the Backup and recovery of MySQL instance in EC2, you can read…
The SPOOL is a command causes SQLPlus to write the results to a file on the operating system. Once spool is set, SQLPlus will continue to spool the output until the command SPOOL OFF. Note that the file cannot be…