Web applications

Last updated:

Sysadmins of the North goes global!

How to set up a global Geolocation DNS load balancing Varnish Cache Content Delivery Network with Bind9, geo-ip database, Varnish Cache and DigtalOcean. DIY High-Availability for your website!

blue elephant plush toy on black laptop computer -- Photo by Ben Griffiths

Web applications

Last updated:

How to set a good PHP realpath_cache_size

Learn how to optimize PHP performance by checking and setting PHP realpath_cache_size. The realpath_cache_size size represents the total number of bytes in the path strings stored, plus the size of the data associated with the cache entry

Web applications

Last updated:

Exploit PHP's mail() to get remote code execution

Exploit PHP's mail() function for remote code execution. Apparently, if you are able to control the 5th parameter of the mail() function ($options), you have the opportunity to execute arbitrary commands.

WordPress XMLRPC API

WordPress

Last updated:

Huge increase in WordPress xmlrpc.php POST requests

How to identify, block, mitigate and leverage xmlrpc.php scans, brute-force, and user enumeration attacks on WordPress sites... Secure WordPress xmlprc.php interface and reduce service disruption.

Joomla ACL decision flowchart

Web applications

Last updated:

8 Tips to improve Joomla performance

Learn how to speed-up Joomla performance on Windows Server IIS using these 8 simple, but important, tips. Add caching, gzip compression, set your sessions & optimize MySQL database functions.

WordPress

Last updated:

Export and migrate WordPress to Ghost

I wanted to migrate from WordPress to Ghost, and at first failed. Here's the write-up: exporting WordPress to JSON and fixing Ghost's import errors.

Web applications

Last updated:

Minify JavaScript, CSS and compress images

Minify JavaScript and CSS the easy and fast way, with YUI Compressor and UglifyJS on the Linux, macOS and Windows command line.

High Performance MySQL

WordPress

Last updated:

Wp_options table autoload micro-optimization

The autoload feature loads and caches all autoloaded options, if available, or all options. The default option is to autoload, and over time when the wp_options table grows, this degrades performance. Today I noticed a slow MySQL query coming from a WordPress database (WordPress wp_options table). This made me investigate and to optimize the WordPress wp_options table “autoload” feature.

WordPress logo

WordPress

Last updated:

Clean-up spam comments and meta data

Delete WordPress spam comments and meta data in your database, easily with phpMyAdmin or mysql cli. Keep your WordPress database lean & mean!

Umbraco

Last updated:

Configure SQLServer sessionState for Umbraco

Configure Umbraco for SQLServer sessionState storage and prepare Umbraco for high performance web garden or web farm, and load balancing environments. This post explains it all.