mysql

  • An Active/Active Apache/MySQL Cluster

    While I was working on the active/active iSCSI cluster, I began wondering if the same technology and concepts could be used to create a pair of active/active Apache/MySQL servers.  Turns out it can.  The primary issue to keep in mind is that in this setup, the potential exists for running 2 instances of both Apache and MySQL (actually MariaDB which is a drop-in replacement) on the same system.  So long as you have unique sockets (IP address + port) and the resources on each system to do so, that shouldn't be a problem.

  • MySQL Authentication Using SSSD and Active Directory or LDAP

    Someone recently asked me if it was possible to log into MySQL running on Linux using an active directory account.  "Interesting idea", I thought to myself so I set out to see if I could make it work.  Turns out it wasn't all that hard to do.  Time for the usual disclaimer.  I have only tested this in my home lab but I know of no reason why this wouldn't work for you.  With that said, let's dig in!

  • Red Hat Enterprise Linux Updates Database

    If you run Red Hat Enterprise Linux and can't yet justify the cost of the Red Hat Satellite product, this post might be of interest to you.  Many admins in this situation will set up a local Red Hat yum repository and point all their systems at it for updates but in this scenario, how do you know what systems need what updates?