Posts

MariaDB Database Multi-instance implementation in single machine

--------------------------------------------------------------------- MariaDB Database Multi-instance implementation in single machine --------------------------------------------------------------------- Step - 1 : Install MaariaDB [ First ] instance by using YUM or Repo installation  Step - 2 : Setup for other port numbers [ 3307 , 3308 and 3309 ] Instances for MariaDB  Step - 3 : Start the MariaDB service with new DB instances [ 3307 , 3308 and 3309 ]  Step - 4 : Stop / Shutdown of MariaDB all Instances [ 3306 , 3307 ,3308 and 3309 ] Step - 5 : Connection for all MariaDB instances [ 3306 , 3307 ,3308 and 3309 ] Step - 6 : Setting the password for DB super user for all MariaDB instances [ 3306 , 3307 ,3308 and 3309 ] Step - 7 : MariaDB services creation for all instances [ 3306 , 3307 ,3308 and 3309 ] Step - 8 : Stop / Start / Status / Restart for all MariaDB instances by uising mariadb instance service files ---------------------------------------------------------------------------