MySQL has two primary storage engines: MyISAM and InnoDB.
Each has its own performance characteristics and considerations but generally MyISAM is good for read-intensive data and InnoDB is good for transactional data.
Jeff Wilson
How to improve your Debian VPS security by using DenyHosts and Logwatch
What is DenyHosts?
It is a python script intended to be run by GNU/Linux system administrators and users to help thwart SSH server attacks which are also known as dictionary based attacks and brute force attacks. It has the ability to run as a daemon and it can automatically block attackers and prevent them from gaining access to your server.
Nginx virtual host – Nginx server block
We’ll show you how to create an Nginx Virtual Host, also known as an Nginx Server Block. In one of our previous tutorials we explained How to install and configure LNMP (Nginx, MySQL and PHP) server on a Debian 6 (squeeze) VPS, now we’re going to look at how to set up a new server block (virtual host) for each new domain.
How to configure IMAP with SSL
IMAP or Internet Message Access Protocol is one of the two most commonly used protocols for e-mail retrieval. This is a step-by-step tutorial on how to configure IMAP to use SSL encryption for secure communication on port 993 (by default IMAP uses port 143).
How to install LEMP on Debian 6 (squeeze) VPS
Status: Deprecated
This article, “How to install LEMP on Debian 6 (squeeze) VPS” covers a version of Debian 6 that reached end of life (EOL) on November 30th, 2020, and is no longer supported. For this reason, this guide is no longer maintained. If you are currently operating a server running Debian 6, we highly recommend that you contact RoseHosting fully managed support to upgrade or migrate to a supported version of Debian 6 for you.
See Instead: This guide might still be helpful as a reference, but may not work on other Debian releases. We strongly recommend using a guide written for the version of Debian you are using. The following RoseHosting tutorial outlines how to install LEMP on Debian 8.
To install LEMP on Debian 6, you need to start with Nginx, a free, open-source, high-performance HTTP server. Unlike his ‘friends’, it does not rely on threaded handling of the requests but instead it uses a much more scalable event driven (asynchronous) architecture. This uses a very small and predictable amount of memory under heavy load. Nginx in combination with the simple and very robust FastCGI Process Manager for PHP (PHP-FPM) and the world most popular database server MySQL can give you a lot of power and performance while still using a small memory footprint.
The following article looks at how to install and configure this stack on one of our Debian based VPSes.
How to Reset MySQL Root Password
We will show you, how to reset MySQL root password. If you assigned a root password previously but have forgotten it, you can assign a new password. Resetting the root password of MySQL server, is fairly easy task, and it can be accomplished in less than 10 minutes.