Using MySQL Tuner with MariaDB on Ubuntu 22.04
Leaving MariaDB settings out of the box may work for some people but not so productive for others, MariaDB can be a resource hog if not checked and result in issues like OOM-Killer(Out of memory) knocking it off. You can use a tool called MySQLTuner to give you some variables to adjust in your MariaDB/MySQL…
Read MoreFlush DNS cache locally on macOS Ventura, Monterey, Big Sur, OSX, Linux and Windows
When URLs are just not resolving the way you want, it may be time to clear or flush the DNS nameserver local cache – enter the relevant command in the Terminal/command line for the macOS operating system you are on. How to flush the local macOS DNS cache macOS Ventura 13.0.0 sudo dscacheutil -flushcache; sudo…
Read MoreRestart and view status of RunCloud services on the Command Line
Here are some command line commands to view the status as well as restart some key services such as OpenLiteSpeed, MariaDB, Redis and Memcached, after having SSH’ed in to your server as root. MySQL/MariaDB Get the status of MariaDB systemctl status mariadb Output will be similar to above, this gives a lot of information on…
Read MoreGetting Browsersync running with Gulp 4 and Valet on macOS
Get Browsersync going with Gulp 4+ and Valet as a local development environment. With Gulp 4+ there has been some code upgrades that require any older gulp.js files to be updated, this guide looks at making Browsersync work with Gulp with the local development tool being Valet. nodejs Ensure you already have nodejs and npm…
Read MoreConverting MySQL/MariaDB database tables from MyISAM to InnoDB
The InnoDB storage engine in MySQL/MariaDB is more performant than MyISAM – here are a few ways to change that database structure, using both the command line and also some WordPress plugins. Changing from MyISAM to InnoDB via the command line If you have wp-cli installed on your webserver you can check for MyISAM tables…
Read MoreSet Memory Limit for PHP CLI on RunCloud, OpenLiteSpeed
On a RunCloud instance, PHP CLI is a separate server setting which is a toggle control to set the version of PHP that applies to using PHP commands on the command line for the whole server. You can set it by selecting the server in the RunCloud panel then Settings > PHP-CLI Version > PHP…
Read MoreSyncing RunCloud and Cloudflare firewalls for fail2ban IPs
This guide looks at adding a proxied Cloudflare service to a server set up with RunCloud and fail2ban with a WordPress jail conf set up. Once you start using Cloudflare as a CDN solution for your hosting, you are adding another firewall into the equation, albeit a very good one, but you may want to…
Read MoreInstalling Gulp on macOS Ventura – Intro guide to Gulp
Installing Gulp on macOS Ventura, macOS Monterey and earlier OS versions requires Nodejs and npm (Node Package Manager), so get that installed first following the linked guide. Gulp is an easier and slightly more modern javascript task runner than its sibling Grunt, which helps you automate numerous tasks in your workflow. You need to install…
Read MoreInstalling node.js on macOS Ventura and earlier macOS versions
node.js allows you to run javascript in the Terminal as appose to a regular browser which makes for a modern workflow in web development, with both node.js installed and a package manager called npm (Node Package Manager) also installed, which can manage other packages that work with node.js, one of the main ones being gulp.js…
Read MoreSet up malware scanner LMD Maldet and ClamAV on a RunCloud instance
How to set up a malware scanner with LMD Maldet and ClamAV on a RunCloud server instance. One of the popular and open source malware scanners is an app called Linux Malware Detect and works well scanning any Linux web server, it keeps a daily updated database of known malware exploits from an updated registry…
Read More