Re: Queries on innodb cluster

[Imran Khan]

Dear Frederic Descamps,

Thanks for the your reply.

• Can I go with 2 MySQL nodes (can I achieve high availability with 2 MySQL node?) , one MySQL router server and one MySQL shell server?

• OK. I will use MySQL router. If router server goes down then will all the systems useless or not work?

• I will use two application servers with load balancing so on which server I need to setup router?
On one application server or on both application servers? If on both, how to setup router servers on it?

• You mean data will sync automatically after setup of Innodb cluster between MySQL nodes?

• Shared storage is required between MySQL node or I can use individual stroage?

Please provide me step by step setup of Innodb cluster on MySQL 8.0.16. That will be great for me.

Thanks,
Imran Khan.



Edited 4 time(s). Last edit at 05/10/2019 04:03AM by Imran Khan.