Skip to content

Oracle Grid Infrastructure

Deploying MySQL on Oracle Clusterware – Part 5

Installing MySQL There are a few ways to get the MySQL software set up for clustering.  One option is to install the rpm for MySQL on both cluster nodes.  There is also a tar file containing what you need to create a yum repository that can be used by multiple servers.  You could also use a tar of the software and just extract it to a shared filesystem.  The benefit of the last option is that you can have multiple instances of MySQL hosted on the same cluster running different versions. I decided to have MySQL 5.7 installed from a yum repository, but also have a MySQL 5.6 home extracted from a tar in case you needed to run an older version concurrently. At the time of writing, I used the following patches from MOS as they had the latest versions of… Read More »Deploying MySQL on Oracle Clusterware – Part 5

Deploying MySQL on Oracle Clusterware – Part 4

If you are not deploying an extended distance cluster, you can skip on to part 5 of this series. Configure the witness site At your witness site all you need is a Linux machine running an NFS server.  This could be something as simple as an EC2 instance running in Amazon.  The Oracle whitepaper on this that I referenced is available here.  You need to create a directory and export it to both cluster nodes.  For example you could add these lines to /etc/exports on the nfs server: Once that is done, you just need to do the following as root on each node: Add a line like this to /etc/fstab on each node: If you have not yet installed the patch for 19373893 you need to mount the NFS share with the hard option instead of soft.  However if you do… Read More »Deploying MySQL on Oracle Clusterware – Part 4

Deploying MySQL on Oracle Clusterware – Part 3

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

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