Reading Time: 2 minutes
While automated backups are important, sometimes you just want to take a MySQL dump of the database prior to making a change to your site. When modifying files in Linux, you can simply copy a file to another name in order to make a new copy. In this tutorial, we will show you how to create a backup of your database (or multiple databases) and also how to restore a backup from either command line or cPanel.
Continue reading “How to Back Up And Restore MySQL Databases From The Command Line”
Reading Time: 6 minutes
Our last article on Ubuntu security suggestions touched on the importance of passwords, user roles, console security, and firewalls. We continue with our last article and while the recommendations below are not unique to Ubuntu specifically (nearly all discussed are considered best practice for any Linux VPS server or dedicated server) but they should be an important consideration in securing your server. Continue reading “How Do I Secure My Linux Server?”
Reading Time: 5 minutes
When security is paramount to your business a few security implementations can go a long way. In the first article of our Ubuntu security series you’ll find effective tactics that can be easily enforced.
We continue with our second article in our Ubuntu Security series, where we will be suggesting further options to consider.
Continue reading “Best Practices for Security on Your New Ubuntu Server: AppArmor, Certs, eCryptfs, and Encrypted LVM”
Reading Time: 4 minutes
Thank you for taking the time to review this important information. You will find this guide broken down into six major sections that coincide with Ubuntu’s security policy guide. The major topics we talk on throughout these articles are as follows:
Continue reading “Best Practices for Security on Your New Ubuntu Server: Users, Console and Firewall”
Reading Time: 8 minutes
MyISAM is a table-locking based engine. Table-locking prevents all other processes from writing data to the target table. This locking behavior encompasses the entire MyISAM table, no matter how minor the datachange. This type of locking preserves the integrity of the data but at the cost of performance. The performance penalty for using table-locking based engines like MyISAM become more laborious as the row count in the table grows. Very large tables will see a significant delay in performance when data needs to be written to a MyISAM table.
Continue reading “MySQL Performance: MyISAM”
Reading Time: < 1 minute
PostgreSQL (pronounced “post-gress-Q-L”) is a household name for open source relational database management systems. Its object-relational meaning that you’ll be able to use objects, classes in database schemas and the query language. As part of our PostgreSQL series, we’ll show you how to list and switch between databases quickly.
Continue reading “Listing and Switching Databases in PostgreSQL”
Reading Time: 6 minutesAs discussed earlier in our MySQL Performance series, the InnoDB storage engine is designed to be a high-performance database for very large datasets. The row-locking technique it uses allows for many read and write requests to occur on a single table concurrently. This is a vast improvement in speed over traditional Continue reading “MySQL Performance: InnoDB Buffers & Directives”
Reading Time: 3 minutesThe majority of work needed when adjusting the MySQL server is editing the applicable directives within a MySQL configuration file. There are multiple, optional configuration files that MySQL looks for when starting up. They are read in the following order: Continue reading “MySQL Performance: System Config & Routine Maintenance”
Reading Time: 16 minutesAs we explored in our previous article of our MySQL Performance Series: MySQL vs. MariaDB there are very few downsides to using MariaDB over standard MySQL. Our high-availability MariaDB’s have proven itself to be a worthy successor with easily mitigated drawbacks. As the last article in our series we will focus on upgrading to various MySQL and MariaDB version on the following servers:
Continue reading “MySQL Performance: Converting MySQL to MariaDB”