Deploy the regular cluster You will be much better off following the instructions for deploycluster for deployment than following the directions farther down.  They will still work, but are quite a bit more manual. I have posted an example netconf.ini and params.ini that you could use with a little bit of tweaking.  The deploycluster zip file has some sample params.ini and netconfig.ini you can look over as well.  You would probably want to reduce the number of disks used in params.ini and change the diskgroup redundancy as well. One thing to note is that you need to have a DNS entry that resolves to at least one IP for whatever you specify as SCANNAME in netconf.ini.  We won’t be using SCAN as we aren’t deploying an Oracle Database, but as far as I know there is no way to remove it/shut it off. You will… Read More »Deploying MySQL on Oracle Clusterware – Part 3

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

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