MySQL InnoDB Cluster | Complete Tutorial | Architecture | Single / Multi primary | MySQL Router

In this video, I have explained the complete details about the InnoDB Cluster. It covers the following aspects,
-- Overview
-- Architecture ( Async replication vs Group replication )
-- MySQL, Shell, Router Installation
-- InnoDB Cluster configuration
-- MySQL Router configuration
-- InnoDB Cluster Single (or) Multi primary
-- Promoting any node as a primary member.
Please give your feedback on the comment section. If you did not subscribe my channel, please do for more MySQL and related technology videos. Thanks!

[@alemamangeldinov3880]

you did a great job!

[@oraclehit388]

Great explanation

[@handsomevillian]

The words fall short to appreciate your brilliant work, lets see what we face at the time of hands on . Thank you sir Sri.

[@sudeeptachoudhury]

Good and Clear concept. Almost all are address, More on Router log analysys

[@mallishivam]

Hi Shakti, thanks this is very useful, can you please make one video on innodb clusterset switchover and switchback between dc and dr

[@hercules7sakthi]

thanks for the feedback! sure will plan for it

[@krishnayadavrayappa9656]

​@@hercules7sakthi please let me know how the application will connect to cluster , through which IP application will connect? What is the cluster IP ? How the router will work during the fail over .

[@billmitchell205]

Superbly done! A+

[@prashantgupta8209]

Hi Sri, congrats, and thank you for making this video.

[@hercules7sakthi]

thanks

[@bhupendrapatel6277]

Serously well explained

[@krishnayadavrayappa9656]

It's really very good explanation.

[@sharmilarajendran8692]

Hi Shakthi good explanation keep it up

[@hercules7sakthi]

thanks!

[@sharmilarajendran8692]

Yen phone panna attend pannamatengra by Sharmila

[@vishusrangolifoodanddailyv8323]

Hi, congrats and thank you for making this video. One question: is it possible to setup 3 node innodb cluster in prod site, 3 node innodb cluster at DR site and keep async replication between any one node..?

[@hercules7sakthi]

Yes, absolutely. please take a look at the following blog blogs.oracle.com/mysql/post/announcing-mysql-innodb-cluster-read-replicas#:~:text=With%20MySQL%20InnoDB%20Cluster%20Read,what%20the%20secondaries%20can%20handle

[@mohanb02]

great Sri! you made it all appear so easy to set up a MySql cluster. Fantastic job. Just a doubt, can this procedure be followed in case of dockerised mysql server instances?

[@sakthisri1084]

Superb 🎉

[@creativeground2245]

Thank you, Sri, for your excellent video. It was very clear and easy to understand. I come from an MSSQL background and am trying to learn MySQL as well. I'm familiar with master-slave replication, but the issue is that it requires manual failover. Once one node is down, it cannot automatically redirect the application to the other node. Is there any way to achieve automatic failover in InnoDB replication? I mean, once innodb1 is down, innodb2 will become the primary node.I followed your instructions and intentionally shutdown innodb1, but it is not failing over or reachable from the router node. Looking for your respose. Thank you.

[@RahP3]

What happens if one of the (Read-Only lets say innodb2) node goes down? Application connecting to (READ) localhost:6447 will get error or will the cluster automatically make the innodb3 node available on (READ) localhost:6447 connection?

[@krishnayadavrayappa9656]

Hii Sir , I have one doubt . What if the router server goes down? Or crash ?

[@manish0554]

Hi, How to replicate innodb cluster to one instnace slave. I want to replicate the DB for other purpase like Backup/analytics SQLs

[@mayurmakwana8153]

Unable to add instance

[@pawanrao9917]

Hi can you make one video for Dc Dr innodb cluster replication

[@hercules7sakthi]

Sure, will work on it

[@rakshithbs4687]

Please provide doc for this and can we do it single server?

[@hercules7sakthi]

i prefer reading the MySQL official documentations and MySQL leaders blogs.

[@jacobv912]

Hi! I have some doubts on clustering ,how can I contact you?

[@hercules7sakthi]

please reach me at [phone] on whatsapp

[@Unfoldingmoments]

can you provide any documentation for this ?

[@hercules7sakthi]

no, i am planning to have the blogs

[@MohammedAli-rt3gs]

Good video but need your notepad