Installing APC on Amazon EC2 Instance

Installing APC on Amazon EC2 Instance featured image

Some time ago, I wrote a short blog post explaining how to go about installing XCache on an Amazon EC2 instance to help with opcode caching. More recently, we’ve begun using APC for similar reasons, with excellent results, including on Amazon EC2 Micro instances, which can be used under their free usage tier to run […]

How to Restart MySQL After Editing innodb Log Size

How to Restart MySQL After Editing innodb Log Size featured image

Sometimes, either because we’ve got a puny amount of RAM available, or because we’ve recently boosted available RAM, we want to allow MySQL a different amount of memory for it’s innodb logs. However, when we change this, restarting MySQL(d) can cause a hiccup or two. Namely, the MySQL service won’t restart. If this happens, what […]

Installing XCache on Amazon EC2

Installing XCache on Amazon EC2 featured image

We’ve been benchmarking Amazon EC2 server instances for some highly complicated PHP applications over the past week. During this time, we’ve discovered that XCache is perhaps the best opcode caching product for our purposes. If anyone would like a walkthrough for installing XCache on an Amazon EC2 instance, simply leave a comment below and we […]

WordPress Extensions

WordPress Extensions featured image

We often install the Open source (free, and developed by a community of programmers, rather than one, paid, team) Content Management System (CMS), WordPress. WordPress was originally a blogging platform developed by Matt Mullenweg, but, in its short history, the software, which runs on (also Open source) PHP and MySQL, has developed into far more […]

How Do You Pronounce “MySQL”?

How Do You Pronounce “MySQL”? featured image

We sometimes talk on the telephone with various technology companies, and their representatives. The people on the telephone fall into one of two camps: technical and non-technical. Nobody, however, seems to be sure exactly how to pronounce the abbreviation “MySQL”. The people who made and host MySQL have been quite clear about this. It is […]

How to Find & Replace in MySQL

How to Find & Replace in MySQL featured image

Sometimes, we need to find and replace certain strings or pieces of data in MySQL on the fly, for example if we’ve changed a Top Level domain (TLD) and want to update a bunch of links all in one go. For those times, the following command can be issued: update [table_name] set [field_name] = replace([field_name],'[string_to_find]’,'[string_to_replace]’); […]

How to Make WordPress Auto-Thumbnails Work

How to Make WordPress Auto-Thumbnails Work featured image

If you’re recently installed WordPress onto a new server (we do this a lot on Amazon EC2 instances of varying sizes) and you notice that your image uploads aren’t auto-thumbnailing (when WordPress “crunches” your images into “thumbnail” “medium” and “large” sizes for use throughout your website) then chances are your server doesn’t have the GD […]

Transport HTTPS traffic to HTTP with .htaccess

Transport HTTPS traffic to HTTP with .htaccess featured image

The sharp-eyed among you may have noticed that we very recently updated a couple of things here at the Silicon Dales website, and one of those steps has involved switching from delivering pages via HTTPS, now that we have retired the online shop section. The precise mechanism for doing this on a LAMP setup using […]

How to Setup MySQL’s my.cnf for Micro AWS EC2 Instance

How to Setup MySQL’s my.cnf for Micro AWS EC2 Instance featured image

If you’re using a micro AWS EC2 instance to host a website which uses a database running on MySQL (yes, this is possible using WordPress on a free usage tier!), then you’ll need to configure MySQL to play nicely on such a puny setup. One very easy way to get this working relatively well is […]

AWS EC2 Instance Won’t Stop

AWS EC2 Instance Won’t Stop featured image

If you use a lot – or even just one – EC2 instance on Amazon Web Services (AWS), from time-to-time, you might find that an instance becomes unresponsive, you can’t get in via SSH, and, when in the AWS console, the instance just won’t stop! When this happens, you select “Stop” in the console, and […]

Fix MySQL Server Issue: “Another MySQL daemon already running with the same unix socket.”

Fix MySQL Server Issue: “Another MySQL daemon already running with the same unix socket.” featured image

Just the code you need for responding to this error. The following message can sometime prevent MySQL from (re)starting: Another MySQL daemon already running with the same unix socket. Sometimes, this message displays when you KNOW there is not another MySQL daemon running on the same unix socket, because you just issued a “stop” command […]

Convert WordPress MySQL Database Tables from MyISAM to InnoDB for Better Scale

Convert WordPress MySQL Database Tables from MyISAM to InnoDB for Better Scale featured image

Scaling WordPress websites to stupidly big levels is something that makes us very, very happy. Over the past 10 years, I’ve overseen some fairly significant web applications, powered by WordPress, which pushed the envelope in terms of what the CMS can do. One instance saw us taking 5,000+ XML (NewsML + other types) files pushed […]

Big WordPress Problem – Slow WP Admin / Uncached Pageloads Slow

Big WordPress Problem – Slow WP Admin / Uncached Pageloads Slow featured image

Some problems are first world problems. Other problems are big WordPress problems. We deal with some big WordPress customers, and often their sites can become slow. There’s sometimes a myth floating around that “WordPress doesn’t scale” or, more specifically, that “WooCommerce doesn’t scale” but there’s a reason I call this a myth… because it isn’t […]

Give your WordPress website some TLC this Valentine’s

Give your WordPress website some TLC this Valentine’s featured image

Every WordPress website needs tender loving care, to keep up with the latest versions of software, new browsers & devices and the latest security patches. To give your users the best experience possible, make sure your website gets the TLC it deserves with our checklist below: The Silicon Dales WordPress TLC Checklist Backup your website. Upgrade to […]

Minimum Requirements for WooCommerce

Minimum Requirements for WooCommerce featured image

Below are the minimum requirements for WooCommerce and (by extension) WordPress. Some are taken from WooCommerce, some from WordPress, and also, some, we are adding as recommendations. It should be apparent, below, which is which! Before getting started, if you’re here to assess a WooCommerce host, then you may be interested to check out our […]

WordPress – Using MySQL to Update Specific Custom Fields

WordPress – Using MySQL to Update Specific Custom Fields featured image

Some time ago, we told you how to Find & Replace Data using MySQL – today I am going to explain how to use this query to update specific custom fields in WordPress databases, in bulk, on-the-fly, without having to login, open, and edit every single WordPress post you’ve got! Remember, before doing anything to […]

MySQL Innodb Tables Crashing on AWS EC2 Instance? Is Your Disk Full?

MySQL Innodb Tables Crashing on AWS EC2 Instance? Is Your Disk Full? featured image

We’ve been asked to troubleshoot Amazon Web Services Elastic Compute Cloud (AWS EC2) instances for a number of reasons. Recently, we took a look at an Amazon EC2 instance which was being used as a MySQL server and the task was to see why several MySQL innodb tables were crashing. The situation had got so […]

How to Safely Update Linux in AWS EC2 Micro Instance – Using Yum

How to Safely Update Linux in AWS EC2 Micro Instance – Using Yum featured image

Often, when logging into via SSH to an Amazon EC2 instance, you are told that there are several updates (usually including security updates) waiting to be updated on your system. The panel on Amazon Linux even goes so far as to explain how one might go about updating to this version. HOWEVER, as this may […]

Silicon Dales