June 2014 - Sysadmins of the North

.svc WCF web service returns 404 Not Found on IIS 8

When a Windows Communications Foundation (WCF) web service returns a 404 Not Found error, after installing the HTTP-Activation feature in IIS, you might need to add an extra Handler to your IIS configuration.

By Jan Reilink 30/06/2014Windows Server

Web applications

8 Tips to improve Joomla performance

Speed-up Joomla with just a few config settings: 8 Tips to improve Joomla performance. Add caching, gzip compression, set your sessions & optimize MySQL database functions... Provide your visitors with a blazing fast Joomla website!

By Jan Reilink 29/06/2014Web applications

MySQL

MySQL database optimization with indices

MySQL indexes (indices) are important. Why? Because they speed up the process for MySQL to find requested information.

By Jan Reilink 21/06/2014MySQL

MySQL

Convert MySQL MyISAM tables to InnoDB

Convert MyISAM to InnoDB for better database performance. In the earlier days of MySQL, the default storage engine for your database tables was "MyISAM". InnoDB is the engine to use now, and MyISAM is no longer actively developed. Therefore all MySQL optimizations are for InnoDB, and it's recommended to switch from MyISAM to this InnoDB storage engine for your MySQL database tables. Follow this tutorial on how to convert from MyISAM to InnoDB.

By Jan Reilink 19/06/2014MySQL

Windows Server

Send email with Ghost using SMTP authentication and TLS encryption

As you know, more and more web hosting providers require SMTP authentication (often abbreviated as SMTP AUTH) and a TLS encrypted connection to send email. Here you'll find some script examples to Send secure SMTP email from your website.

By Jan Reilink 19/06/2014Windows Server

Windows Server

Export and migrate WordPress to Ghost

A little while ago I installed Ghost on IIS, along with the required Node.js and iisnode module. All in an isolated test environment, in which Ghost runs as a production site only. Now I wanted migrate from WordPress to Ghost, but failed. Here's the write up.

By Jan Reilink 16/06/2014Windows Server

MySQL

How to flush MySQL query cache from time to time

Learn how to manually flush MySQL's query cache or automatically using a Linux cron job. Flushing the query cache does not delete (or clear) the query cache. For this you have to use the "reset query cache" command.

By Jan Reilink 15/06/2014MySQL

GNU Linux

How to delete all MAILER-DAEMON emails in Postfix queue

Delete all MAILER-DAEMON emails from your Postfix queue fast when it matches a sender or recipient email address condition. For example, delete emails based on Message-ID header, To or From address.

By Jan Reilink 04/06/2014GNU Linux

Month: June 2014

.svc WCF web service returns 404 Not Found on IIS 8

8 Tips to improve Joomla performance

MySQL database optimization with indices

Convert MySQL MyISAM tables to InnoDB

Send email with Ghost using SMTP authentication and TLS encryption

Export and migrate WordPress to Ghost

How to flush MySQL query cache from time to time

How to delete all MAILER-DAEMON emails in Postfix queue

Windows Server

Web applications

PowerShell