Installing Multiple MySQL Instances on Linux | MySQL DBA Tutorial | MySQL 8 DBA Tutorial

[@OptimisticMe]

That helped so much! Thanks! Had to modify few things here in there but that was perfect!

[@SuNiLKuMaR-iq9pz]

Nice Session...Successfully simulated

[@SANDATA764]

This was amazing session please go ahead for boosting us I really want to thank you جزاك الله خيرا

[@Naveen-ef2dg]

Brilliant video and life saver. It really helped thanks a lot

[@teresogarcia269]

It would be nice to add and demonstrate how the linux service for start/stop after server reboots is accomplished. The nohup is nice, but that is manual start /stop. If you can add init.d or systemctl depending on centos version.

[@muhammadimranpervaiz7042]

Very nice explanation. And can you help me about how to change hostname (localhost to static IP) in MySql server database? Please . Thank you

[@hassanumair6967]

Mr. Mughees, great work and very precise tutorial, Please make video about usage of percona tool kit 2.2 and before that version (complete backup & Restore DB consists size of Multiple GBs)

[@mughees52]

Sure will do that

[@mohamedaadhil4645]

thank you really helpful

[@dhaneshbhavsar8864]

Hello sir the video is great. But how can we run multiple mysql version on same machine here you have created multiple instances, beacuse I have to run two mysql 1)mysql4.1 2)mysql8.0. Thanks you

[@summersea_6777]

is this also used for multiple versions on one machine?

[@ragavendran.r]

Hi, why we are not able to login -h localhost instead of 127.0.01

[@jojodiloy4939]

Well this be the same and work in debian 12 using mariadb 11.2?

[@fahdbahoo1]

@Mughees bhai, how to install multiple MySQL using rpm method or yum method ?

[@mughees52]

You cannot you should binaries only

[@fahdbahoo1]

@@mughees52 We have a server with already install MySQL using rpm, can i install the second MySQL server on it ?

[@2626sid]

Can u make video with single cnf file

[@mughees52]

It’s already there check instalation from generic file

[@pandiselvi6161]

Any online classes available?

[@mughees52]

Please connect here on my whatsApp group chat.whatsapp.com/DdRRHnv4rAE89HKmV8KIbk

[@bimithmaramveettill]

can you share the mysql8 configuration file ere

[@mughees52]

www.percona.com/blog/how-to-use-systemd-in-linux-to-configure-and-manage-multiple-mysql-instances/

[@mughees52]

use this link it is a better way

[@kishankumarbk44]

Hi. Does it work on Ubuntu 22.04?

[@mughees52]

I haven;t tested it please do that and lets us know as well

[@kishankumarbk44]

@@mughees52 I tried installing it on Ubuntu 22.04. I can start the server on 3306 port. I am not able to start server on 3307 or any other port until I stop the server running on 3306. I get the error: "Can't start server: Bind on TCP/IP port: Address already in use Do you already have another mysqld server running on port: 3306 ?" Can you help me out?

[@DroisKargva]

@@kishankumarbk44 I read somewhere that you should first stop the first instance if you want to create another one. I am not sure tho. I'm just beginning to learn bout these. Did you figure it out?

[@muhammadarsalan2412]

yashraj mukhatay is that you ?