Anyone operating a blog, newsletter, or other creative side hustle knows there are a lot of moving pieces involved behind the scenes. Keeping the cadence going not only requires commitment and skills, but also various tools and software…

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

At the time of writing, the OpenLampTech developer newsletter is entering its 10th straight month of publishing so I thought it was time to share a ‘Tools of the Trade – …

Galera Load Balancer (GLB) is a scalable and performant, yet easy to use TCP/IP connection balancing proxy. It is the oldest, yet actively maintained load balancer in the MySQL ecosystem, with a wide array of customers using it in production.

Firstly, please request for binaries via contacting sales@galeracluster.com. Once you have access to the package repository, you’ll have access to RPMs. Installing the RPMs are straightforward, and you can also add it to your Yum repository. This blog presumes you already have access to the binaries.

You can start it up, really simply:

glbd --threads 6 127.0.0.1:3306 188.166.179.177:3306 165.22.50.152:3306 165.22.49.92:3306 …

A few things we have noticed recently when it comes to Galera Manager support requests, that we feel we should address in this blog post.

First and foremost, it is a requirement that you install Galera Manager on a clean host. This means you install the base operating system and nothing else: no Nginx, no Apache, no InfluxDB, etc. The Galera Manager installer (gm-installer) will pull all the requisite packages, set SELinux to permissive during the install, etc. The next release of the gm-installer aims to be less fragile when it comes to this, and will aggressively handle installs on machines that already have software installed on it.

The other common issue is the inability to access ports, generally blocked by a firewall (gm-installer should have fixed this as long as setup is going properly), or some other reason. What gm-installer cannot fix …

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.38 (release notes, download). This release incorporates all changes to MySQL 5.7.38, adding a synchronous option for your MySQL High Availability solutions.

In MySQL 5.7.38, we now distinguish between unset ssl_mode and ssl_mode explicitly set to “DISABLED”, because previously ssl_mode=DISABLED was ignored in the xtrabackup-v2 script.

This is a rare release where you are also meant to continue using the Galera replication library 3.37 implementing the wsrep API version 25, from the previous release, as there was no changes made to the Galera replication …

A few weeks ago, we did a Galera Cluster webinar on Managed Galera Clusters on DigitalOcean.

Some of you may notice that the current version of Galera Manager is 1.6.4, and one of the major fixes we have in there is to support the new API token format of DigitalOcean. DigitalOcean has documented this here: Updated API Tokens new management features: in partnership with GitHub –Secret Scanning, Prefixes, and more! and as a consequence we needed to update to accept new API tokens, or it would fail in deployment. If you’re wondering how to create a …

We don’t always need all rows from the table as part of the final results set. You can use one (or more) of the comparison operators to filter the rows with a WHERE clause conditional. In this post, we are looking at the equality comparison operator (=)…

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

Image by kalhh from  …

The MySQL DATE() function is a built-in function you use to extract just the date portion from a DATE or DATETIME value. Learn how to use the DATE() function in this blog post…

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

Image by MaeM from Pixabay

MySQL DATE() Function Syntax

The …

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 5.7 and 8.0, consisting of MySQL-wsrep 5.7.37 (release notes, download) and MySQL-wsrep 8.0.28 (release notes, download) with Galera replication library 3.37 (release notes, download) implementing wsrep API …

The Galera Cluster Enterprise Edition

Codership is pleased to announce the Galera Cluster Enterprise Edition.

Galera Cluster Enterprise Edition consists of an enhanced Galera Cluster server, Galera Manager and Galera Load Balancer.

The enhanced Galera Cluster Server includes

1) A new Online Schema Upgrade method called Non Blocking Operations (NBO), adds more high availability to your cluster while performing schema changes.

• • Schema changes made on all cluster nodes in the same total order sequence, with much more efficient locking compared to the Total Order Isolation (TOI) method.
  • SET GLOBAL wsrep_OSU_method='NBO'

…

I recently took some time to explore the MySQL GROUP BY WITH ROLLUP modifier. As a self-starter, I’m always unknowingly studying SQL concepts that I soon need for a query requirement. Call it luck or premonition, doesn’t matter to me. I’ll take these small wins thanks to my curiosity…

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

I went for a deep dive into the WITH ROLLUP GROUP BY modifier over on the OpenLampTech publication page.

Read the article, …