My favorites | Sign in
Project Home Downloads Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
PurposeAndRequirements  
Why these scripts are built and what software is required.
Phase-Requirements
Updated Jan 22, 2014 by ilmar.kerm

Introduction

These scripts are written to help running multiple MySQL instances (with multiple MySQL software versions) in a clustered environment managed by Oracle Clusterware 11gR2.

Oracle Clusterware is included in the Oracle Unbreakable Linux Basic Support package, with no additional cost.

Design Requirements

  • Multiple MySQL instances running in the same cluster, in case of node failure affected MySQL instances are moved to any other surviving node (least loaded)
  • Different MySQL instances may run different MySQL RDBMS software versions
  • Each MySQL instance is listening to its own dedicated and clusterware managed IP address (so MySQL can always respond on default 3306 port and can move independently around nodes without any dependencies to other MySQL instances)
  • Clusterware monitors each MySQL instance and in case of trouble automatically moves IP and starts instance on another cluster node

Software Requirements

The scripts have been tested with:

  • Oracle Clusterware 11.2.0.2, 11.2.0.3 and 11.2.0.4
  • Oracle Enterprise Linux 5 and 6
  • MySQL 5.5, 5.6 Enterprise (tar package)
  • ACFS filesystem (bundled with Oracle Clusterware 11gR2)
Powered by Google Project Hosting