Skip to content

Linux

Deploying MySQL on Oracle Clusterware – Part 2

Create the LUNs for the cluster So before we deploy the cluster we need to create the shared disks that the cluster will use. The layout that you want to use will depend on the recommendations from your storage vendor.  The layout will also be affected by whether or not you are doing an extended distance cluster.  I am setting this up on Dell Compellent storage, so I followed the documentation in the Dell Storage Center and Oracle12c Best Practices and Dell Compellent – Oracle Extended Distance Clusters. About the storage I used Compellent systems are Active/Passive so for best performance and easy manageability we want 1 LUN from each controller going to a disk group.  Each Compellent controller has a unique serial number so I decided to use them in the name of the disk to help with identification.  For example, lets… Read More »Deploying MySQL on Oracle Clusterware – Part 2

Deploying MySQL on Oracle Clusterware – Part 1

Introduction One of the cool things about working in higher education is that in certain cases there is infrastructure in place that you could only dream of in other industries. In this case, I’m referring to having multiple datacenters on campus with lots of single mode fiber run between them. This makes it easy to have a stretched SAN fabric as well as private networks for cluster heartbeats. Extended Distance Cluster With SAN storage available in both datacenters, it makes sense to deploy an extended distance cluster for mission critical systems. Oracle VM doesn’t support an extended distance cluster per Doc ID 1602029.1. That said, Oracle RAC does support this scenario. There is documentation here for setting up an Oracle RAC extended distance cluster. But what if I wanted to have a setup like this for other applications? If you… Read More »Deploying MySQL on Oracle Clusterware – Part 1