Skip to content

Linux

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

Installing Qubes OS 3.2 on a HP Zbook Studio G3

I recently got a demo unit of an HP Zbook Studio G3 to play with.  It is a tricked out one with a 4k display and a NVMe drive.  I wanted to try out Qubes OS on it, but the installer would lock up when I tried to boot it. Getting Qubes to install and boot The rough steps for getting a HP Zbook Studio G3 to install Qubes OS 3.2 are: Get a copy of the Qubes OS 3.2 ISO Write the ISO to a USB Drive Mount the EFI boot partition of the USB drive Windows will automatically mount it if you plug in the USB drive – a Mac won’t recognize it at all Modify the EFI/BOOT/xen.cfg file so that all of the kernel lines contain acpi_osi=! acpi_osi=”Windows 2009″ I found this useful tip on the ArchWiki Disable Secure Boot… Read More »Installing Qubes OS 3.2 on a HP Zbook Studio G3

SSSD and Active Directory Primary Group

If you’re ever scratching your head because you’re seeing messages like this when trying to diagnose a sssd issue with an ad_access_filter for the user foobar:  [sdap_access_filter_done] (0x0100): User [foobar] was not found with the specified filter. Denying access. You just know that foobar is a member of one of the groups the ad_access_filter is looking for, so what is going on?   The issue is probably that foobar is a member of the group, but also has that group set as it’s primary group. The primary group of an account in Active Directory doesn’t appear under the account’s memberOf LDAP attribute.  You’ll have to add the primaryGroupID attribute to your ad_access_filter.

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