London, United Kingdom

(+44) 07788.377.460 [email protected]

Tag: MySQL

A successful directory structure

Don’t just dump it all in the root! If software development is your job, then just don’t be that guy! Consider a project like the one described in my Advanced WordPress and Docker or FastAPI on Docker posts. I prefer to organise my code into directories for the application code […]

WordPress via nginx on Docker

Run WordPress on Docker (with nginx)

Synopsis This article describes how to configure and deploy a WordPress instance, either in production or for local development (and assumes a beginner+ / enthusiast+ level in DevOps).To achieve this, other than the official WordPress codebase, we will also need a database and a web server which we’ll refer to […]

Restore MySQL Replication

an introduction is needed before diving into the procedures… First you need to stop Apache service on web server, or any other measure to prevent other environments from writing to your DBs: :~$ sudo service apache2 stop flush / reset queries & flush tables with read lock and disable keys […]

Configure MySQL Replication (draft)

setting up MySQL replication