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 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 November 7, 2019Categories TechnologyTags , , ,   Leave a comment on Internet Enabled Voting For US Elections

Internet Enabled Voting For US Elections

Internet enabled voting is a must IMO. Many that are afraid of the security risks and remote hacking have a very shallow, if any, understanding of the risks involved. To claim physical (paper) voting is more secure is absurd. Every country that has used that system, including ours, has encountered fraud in some form. Maybe this is the perfect catalyst for getting our Internet providers to finally enable IPV6. It would make external attacks a couple orders of magnitude more … Continue reading “Internet Enabled Voting For US Elections”

Posted on November 7, 2019Categories TechnologyTags , , ,   Leave a comment on Internet Enabled Voting For US Elections

Internet Enabled Voting For US Elections

apple.news/A2hlUbDHwRjifTbSwv6fOZQ Internet enabled voting is a must IMO. Many that are afraid of the security risks and remote hacking have a very shallow, if any, understanding of the risks involved. To claim physical (paper) voting is more secure is absurd. Every country that has used that system, including ours, has encountered fraud in some form. Maybe this is the perfect catalyst for getting our Internet providers to finally enable IPV6. It would make external attacks a couple orders of magnitude … Continue reading “Internet Enabled Voting For US Elections”

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 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 May 8, 2019Categories PHP, Programming, Technology, WordPressTags , , , , 2 Comments on Ubuntu Trusty: PHP 7.2 MIA

Ubuntu Trusty: PHP 7.2 MIA

Working with Varying Vagrant Vagrants today and having problems spinning up a new box? Don’t blame yourself. It appears that the PHP 7.2 libs… in fact ALL of the PHP libs for Ubuntu Trusty have gone away. The ppa:ondrej/php repository that is cited everywhere has decided it is not going to serve up any PHP code to your Vagrant boxes today. Maybe they’ll fix it soon. Maybe not. If anyone has a workaround please comment here.

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.