This is a guide on how to configure ProFTPd for SFTP sessions. Secure File Transfer Protocol (SFTP) is a secure version of FTP which transfers files via the SSH protocol. ProFTPD can be reconfigured to serve SFTP sessions vs using the default FTP protocol. This guide assumes you already have
MySQL tables can become corrupt for a variety for reasons such as incomplete writes, running out of space, the MySQL daemon being killed or crashing, power failures. If MySQL detects a crashed or corrupt table it will need to be repaired before it can be used again. This guide will
mod_expires is a module which runs on the Apache web server. It allows manipulation of the cache control headers to leverage browser caching. What this means more specifically is that you will be able to set values on how long the image will be stored by the browser when a
WebP is a new image format that provides a lossless and lossy compression on PNG and JPEG file types. It was developed by google resulting in up to 80% smaller image size. It is supported by Google Chrome and Opera. You can use Nginx and Apache to determine if this
Collectd is a daemon which collects system performance data and and metrics. It runs as a daemon and the data collectd collects can either be processed locally or sent to a central logging server. It is easy to configure and setup and can be configured to report to various metric
mod_rewrite is a Apache module installed on linux servers to manipulate URLs submitted in the browser to perform other functions than it appears. Mod_rewrite can improve SEO appearing to give it a static appearance.
This guide assumes you already have Apache installed, if you do not please see How to Install Apache
MySQL contains it own 'root' password independent of the system root password, this is a guide on how to reset the MySQL root password. To reset it you will need root access on the server that has the MySQL instance. The same process applies to percona and mariadb servers as
What Is Mod_Auth_Mysql?
mod_auth_mysql is a Apache module used for authenticating users against a MySQL database. It is commonly used to protect pages and directories accessed via a web browser. You can view more about it on the project page.
This guide assumes you already have a working mysql installation and Apache
Percona Xtrabackup can be used to create "hot backups" of MySQL servers fairly quickly and can avoid some of the pitfalls of mysqldump. Xtrabackup can be setup to use backup locks instead of read locks which is much less invasive, this is available on innodb tables. MyISAM and other tables
Galera cluster is a true multi-master MySQL cluster using synchronous replication. It allows for any of the nodes to be used as a master or all of them as well as providing automatic node joining and node removal. The multi-master configuration is very different from the typical master-slave configuration