Posted on August 3, 2022Categories Docker, Plugin Development, Technology, WordPressTags , , , ,   Leave a comment on Testing MySQL Connectivity From WordPress Docker Containers

Testing MySQL Connectivity From WordPress Docker Containers

Moving forward with feature development for the Store Locator Plus® SaaS service includes moving forward with our tool kits and environments. Docker containers have become a bigger part of our development toolkit. They make for rapid deployment of isolated environments for testing various concepts without the overhead of virtual machines. While we have been working on Virtualbox virtualized machines for years, Docker is far faster to spin up and far less resource intensive. Along the way we have found the … Continue reading “Testing MySQL Connectivity From WordPress Docker Containers”

Posted on July 28, 2022Categories AWS, Lightsail, Technology, WordPressTags , ,   Leave a comment on Hosting WordPress On AWS

Hosting WordPress On AWS

As fate would have it, Summer 2022 has come with some life changes that include a renewed focus on the long-established business at Charleston Software Associates (CSA). In the decade-plus that the company has been in place there have been several key shifts in focus including the launch of Store Locator Plus® as a multi-faceted location mapping software and SaaS platform. Now, as the Store Locator Plus® business is back as the center of focus for the company, it is … Continue reading “Hosting WordPress On AWS”

Posted on July 8, 2020Categories Technology, WordPressTags , , , ,   Leave a comment on Cleaning Up WordPress – Large wp_options.idb

Cleaning Up WordPress – Large wp_options.idb

Did your tiny AWS Bitnami WordPress server run out of disk space? The culprit may be unoptimized data tables in MySQL. Finding a 4.9GB wp_options.idb file on your server is not as uncommon as you may think. What makes it surprising is when you look at your wp_options entries and discover there are only 300 rows in that table with limited text in the option_value column. Thankfully there is an easy fix as long as you can get enough disk … Continue reading “Cleaning Up WordPress – Large wp_options.idb”

Posted on March 30, 2020Categories Security, WordPressTags , , , ,   Leave a comment on Hate Spam? Turn Off Jetpack Email Sharing

Hate Spam? Turn Off Jetpack Email Sharing

The past few days have been spent diagnosing various email delivery issues from the AWS web cluster that is running our WordPress plugin store as well as our SaaS locator platform. During this process email routing was pushed from the servers through the AWS Simple Email System. SNS notifications were enabled to monitor the progress and provide some insight as to what was happening on the send mail side of things. Not far into the mission something odd was showing … Continue reading “Hate Spam? Turn Off Jetpack Email Sharing”

Posted on December 11, 2019Categories AWS, PHP, Security, Technology, WordPressTags , , , , , ,   Leave a comment on AWS LEMP Stacks and EFS Issues

AWS LEMP Stacks and EFS Issues

Lesson learned — if you are using EFS on production systems you want to be using provisioned throughput mode. But, before we get into that, let’s go over the details of this implementation… Service Configuration We utilize AWS EC2 instances to run multiple WordPress sites hosted in different directories. The configuration is fairly standard: 2+ servers configured as part of an load-balanced cluster. The servers run from the same image meaning they use the same underlying software stack. Part of … Continue reading “AWS LEMP Stacks and EFS Issues”

Posted on September 24, 2019Categories AWS, Technology, WordPressTags , , , , , , ,   Leave a comment on Converting A Standalone Instance Into An EC2 Load Balanced Cluster

Converting A Standalone Instance Into An EC2 Load Balanced Cluster

Creating a new web application that resides on an AWS load balanced cluster is easy with the Elastic Beanstalk assistant. That is a great solution if you want to run every web service or application on their own instances. It is not a great fit for complex environments like the one being used for Store Locator Plus®. Store Locator Plus® has several environments running within the same master domain. Multiple servers and load balancers creates a security certificate nightmare. Not … Continue reading “Converting A Standalone Instance Into An EC2 Load Balanced Cluster”

Posted on August 31, 2019Categories Programming, WordPressTags , , ,   Leave a comment on WP_User_Query Inverse (NOT) Search

WP_User_Query Inverse (NOT) Search

It took a LOT longer than it should have to build an efficient query for WordPress users today. The query — an WP_User_Query INVERSE search. The list I was trying to generate was based on two things: – All users with a meta_key field ‘account_status’ containing the status ‘active’– EXCLUDE all users with a nicename ending with “at_slp_dot_guru” Turns out this is a LOT more difficult than it should be due to shortcomings in the WP_User_Query class. The solution that … Continue reading “WP_User_Query Inverse (NOT) Search”

Posted on May 8, 2019Categories Plugin Development, Technology, WordPressTags , , , , , ,   Leave a comment on Cloning A VVV 2.6 Install

Cloning A VVV 2.6 Install

Decided to upgrade my long-term VVV setup that I use for daily client consulting work in preparation for a new gig as head of R&D and CTO for a super cool tech startup. As usual I should have left things alone as it was working fine; I only wanted to play with the newer VVV toys. You’d think I’d learn by now. What I ended up doing was cloning a working baseline VVV install I had created a few weeks … Continue reading “Cloning A VVV 2.6 Install”

Posted on March 25, 2019Categories TechnologyTags , , , , , , , , , , 1 Comment on The Code Block : WordPress Plugin Development Block 0

The Code Block : WordPress Plugin Development Block 0

The very first class at The Code Block at The BlockYard is going to begin the journey with WordPress plugin development. This is a starting point only. Something to get the ball rolling. Anticipate multiple forks as we start down the “Code Block chain”. We most certainly will end up in places we don’t expect as we follow this coding journey were it takes us over the next 6 months.

Posted on February 12, 2019Categories Technology, WordPressTags , , , , , , 5 Comments on nginx Installing WordPress In A Subdirectory

nginx Installing WordPress In A Subdirectory

We have recently run into a number of customers using Store Locator Plus® that are having issues with the new REST based geocoding system. It turns out that an overwhelming percentage of people that are having issues have WordPress installed in a subdirectory. Apparently not all subdirectory installs are created equal — if it is not done properly things break. What is a subdirectory install? A subdirectory install is one in which WordPress is installed in a directory within the … Continue reading “nginx Installing WordPress In A Subdirectory”