MySQL Replication

Sure, its not the most original of topics, but it is one I’ve relied upon from time to time. For years, this guide from Digital Ocean was my go to choice.

It wasn’t until my most recent visit for an upcoming project that things looked, well, a little different. It was mostly the same, but subtle differences meant it was no longer compatible with how I’d been familiar with setting it up.

Therefore this quick post is to capture the old method of setting it up for posterity.

Continue reading “MySQL Replication”

Restoring a Joomla website

From time to time we come across legacy applications and deployments that you didn’t know exist until something goes wrong with it. This week it was an unbeknown to me Joomla website that had been ticking over since 2012. However recent visits to the site got this result:

A report came in on this issue and a few checks of the domain DNS revealed it was on a platform we use for domains and web hosting.

Not overly familiar with the hosting company from a website standpoint and even less with Joomla, it was time to first fathom out how it works, and them find the problem and fix

Continue reading “Restoring a Joomla website”

Update: James-Batchelor.com

This website has received yet another update, and now I am happy with it.

The biggest change was to change the blogging software to WordPress. Although my previous software (BlogEngine.net) was built on ASP.Net and SQL Server, my current choice of language and database that I am most familiar with, I felt that BE was way to bloated and it felt unrefined for my needs.

So I went with WordPress, it seems most blogs I read use this and they look slick, to I wanted a piece of the action. This meant installing PHP and MySQL on IIS, something I really did not want to do due to the resource hog on my server, but I bit the bullet and ordered more RAM for the server.

So far, so good!