This is a demo tutorial to show how we can create InnoDB Cluster with newly installed Certificate and having X509 certificate verification via MySQL Router connection.
The full process is recorded on Youtube - showing creating InnoDB Cluster with newly installed CA, Server Certificates. The Router creation is configured with SSL Server certificate from the same CA certificate across Server nodes. The creation of User (create user my509user identified by '....' require X509) using X509 certificate PASSTHROUGH verification via Router connection.
The following environment was tested
Oracle Linux Server release 8.6
MySQL Server 8.0.31
MySQL Shell 8.0.31 …[Read more]