Typical MariaDB Server installations have the MySQL data directory located in /var/lib/mysql. The data directory contains the data of the databases and the size increases depending on the usage. In this post, you will learn how to move the MariaDB Server data directory to a new mounted EBS Volume. This is useful to separate the…
First Launch the EC2 Instance from the AMI Ubuntu Server 16.04 LTS (HVM), SSD Volume Type After Launching the EC2 instance, connect to the instance using the key pair, to know the default username for each operating system in the AWS read here Update your system repo Install the dependencies Before we start with the…
Day 2 activity of the DBA’s, after setting up the database server and configured all the required privileges and applying the patch, we will create a new database Developers and SysAdmins also should know to create database. Creating database from DBCA by using the GUI is very straight forward and simple. But if you don’t…