Go to main content

Oracle^® Solaris Cluster Data Service for MySQL Guide

Exit Print View

» ...Documentation Home » Documentation Library » Oracle^® Solaris Cluster Data ... » Deployment Example: Installing MySQL in a ... » Example: How to Configure MySQL in a Scalable ...

Updated: October 2019

Oracle^® Solaris Cluster Data Service for MySQL Guide

Document Information

Using This Documentation

Chapter 1 Installing and Configuring HA for MySQL

Appendix A Deployment Example: Installing MySQL in a Failover Configuration

Appendix B Deployment Example: Installing MySQL in a Scalable or Multiple-Master Configuration

Target Cluster Configuration

Software Configuration

Installing and Configuring MySQL on Local Storage

Example: How to Prepare the Cluster for MySQL

Example: How to Configure MySQL in a Scalable Resource Group

Example: How to Configure MySQL in a Multiple-Master Resource Group

Example: How to Install and Bootstrap the MySQL Software on Local Storage

Example: How to Modify the MySQL Configuration Files

Example: How to Enable the MySQL Software to Run in the Cluster

Appendix C HA for MySQL Extension Properties

Language:

Example: How to Configure MySQL in a Scalable Resource Group

This procedure describes how to configure MySQL in a scalable resource group. If you need to configure MySQL in a multiple-master group, see Example: How to Configure MySQL in a Multiple-Master Resource Group.

Register the necessary data types on one of the nodes.
```
phys-schost-1# clresourcetype register ORCL.mysql
```
Create the failover resource group for the shared address resource.
```
phys-schost-1# clresourcegroup create RG-ACCESS
```

Create the shared address resource.

phys-schost-1# clressharedaddress create ha-host-1

Create the MySQL resource group.

phys-schost-1# clresourcegroup create RG-MYSQL

Enable the resource groups.

phys-schost-1# clresourcegroup online -M RG-MYSQL
phys-schost-1# clresourcegroup online -M RG-ACCESS

Copyright © 2000, 2019, Oracle and/or its affiliates.