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!

[sudeeptachoudhury]

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

[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.

[krishnayadavrayappa]

It's really very good explanation.

[mallishivam]

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

[sharmilarajendran]

Hi Shakthi good explanation keep it up

[prashantgupta]

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

[mohanb]

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?

[creativeground]

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.

[vishusrangolifoodanddailyv]

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..?

[krishnayadavrayappa]

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

[pawanrao]

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

[manish]

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