Clients often ask for our recommendation when buying web hosting for WordPress and particularly WooCommerce websites. Here, WooExpert Robin Scott gives guidance on choosing the…
WooCommerce Hosting – Best Hosts for your Store
MySQL
MySQL is part of the LAMP setup most often used by Silicon Dales for clients’ WordPress installs. That’s why you’ll find a bunch of tutorials, case studies and extension reviews mentioning MySQL on this page.
For those who want to know:
MySQL is an open-source relational database management system. Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter, and “SQL”, the abbreviation for Structured Query Language. (Wikipedia)
If you would like help with a MySQL setup, contact Silicon Dales.
Complete WooCommerce Speed Optimization Guide
As accredited WooCommerce Expert developers, Silicon Dales offers a full WooCommerce optimization service to medium and larger Woo stores, but what do we actually do?…
Big WordPress Problem – Slow WP Admin / Uncached Pageloads Slow
Some problems are first world problems. Other problems are big WordPress problems. Slow WordPress Admin? Slow uncached pageloads? We deal with some big WordPress customers,…
Give your WordPress website some TLC this Valentine’s
Every Wordpress website needs tender loving care, to keep up with the latest versions of software, new browsers & devices and the latest security patches.…
Minimum Requirements for WooCommerce
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…
How to Safely Update Linux in AWS EC2 Micro Instance – Using Yum
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…
Find out Apache, MySQL, PHP (etc) versions via Plesk
Are you running Plesk on your dedicated server or VPS? Do you want or need to know what version of MySQL, PHP, Apache – or…
How Do You Pronounce “MySQL”?
We sometimes talk on the telephone with various technology companies, and their representatives. Two camps, both alike in dignity The people on the telephone fall…
Installing XCache on Amazon EC2
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…
How to Find & Replace in MySQL
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…
AWS EC2 Instance Won’t Stop
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…
How to Make WordPress Auto-Thumbnails Work
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…
Installing APC on Amazon EC2 Instance
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…
How to Restart MySQL After Editing innodb Log Size
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…
Convert WordPress MySQL Database Tables from MyISAM to InnoDB for Better Scale
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…
Fix MySQL Server Issue: “Another MySQL daemon already running with the same unix socket.”
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…
MySQL Innodb Tables Crashing on AWS EC2 Instance? Is Your Disk Full?
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…
WordPress Extensions
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…
WordPress – Using MySQL to Update Specific Custom Fields
Some time ago, we told you how to Find & Replace Data using MySQL – today I am going to explain how to use this…
Transport HTTPS traffic to HTTP with .htaccess
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…
How to Setup MySQL’s my.cnf for Micro AWS EC2 Instance
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…