Posts

Building a Highly Available MySQL 8 InnoDB Cluster

Image
A 3-node Group Replication cluster with MySQL Router, tested end-to-end for automatic failover and manual switchover By Munish Kumar Karna | Oracle DBA Over the past few days I set up and stress-tested a production-style MySQL 8.0 InnoDB Cluster from scratch — 3 database nodes running Group Replication behind MySQL Router, with a full failover and switchover drill at the end. Sharing the walkthrough here in case it helps anyone building HA MySQL on-prem or in a private cloud. Architecture Three MySQL 8.0.46 nodes in single-primary Group Replication, fronted by MySQL Router for transparent read/write and read-only routing: Node IP Address (example) mysql01 10.0.10.11 mysql02 10.0.10.12 mysql03 10.0.10.13 mysqlrouter 10.0.10.20 1. Host Prep & Firewall Configured /etc/hosts on all three nodes for name resolution, verified with ping and getent hosts Installed MySQL 8.0 Server + MySQL Shell ( mysqlsh ) on all nodes Opened the required ports: 3306 (MySQL...
Post a Comment
Read more

Oracle RAC 26ai Installation on Oracle Linux 9 — Step by Step Guide

Image
Oracle RAC 26ai Installation on Oracle Linux 9 — Step by Step Oracle 26ai brings a new major release of the Oracle AI Database and Grid Infrastructure stack, and getting a 2-node Real Application Clusters (RAC) environment up and running is still the best way to really learn how the pieces fit together. This walkthrough documents a complete build of a 2-node Oracle RAC 26ai cluster ( racnode1 / racnode2 ) on Oracle Linux 9 , from OS preparation through Grid Infrastructure, the Database software, and finally creating the RAC database with DBCA. The lab was built on Oracle VM VirtualBox with shared disks for ASM, but everything from the OS prerequisites through the DBCA screens applies equally to any virtualization platform or bare metal. Contents 1. Operating System Preparation 2. Kernel Parameters and Security Limits 3. Required Packages, OS Groups and Users 4. Create Grid and Oracle Homes 5. Shared Disks and Oracle ASMLib 6. Cluster Verification Utility (Pre-check) 7. Install ...
Post a Comment
Read more