Know Your SQL Databases

Relational database management systems (RDMS) are very popular in the web hosting world. While non-relational databases, often called NoSQL, may be gaining popularity, most small, medium and even still some large websites rely on SQL technology. This is just a brief intro to the various brands of SQL out there.
MySQL – One of the older […]

Manage Your Log Files with Logstash

Your dedicated server has lots of logs. Almost every service and program running on a Linux or Unix server has a log file associated with it that includes relevant information about processes, errors and warnings. Sifting through all of those logs can be a pain, especially if you need to review old logs or compare […]

Tips for Boosting VPS Performance

In some instances, the performance of a VPS is limited to the hardware and software specifications of the host machine. You have a finite amount of CPU and memory resources at your disposal, and you are not free to change the operating system’s global configurations. Nevertheless, there are a plethora of OS and software parameters […]

Monitor MySQL Activities with MyTop

If you have been around Linux and/or Unix long enough, you have probably heard of “top”. It is a convenient program that can give you information about running processes, memory and cpu usage, load averages and a host of other details about your server. You can do almost the same thing with “mytop”, only specifically […]

How to Convert MyISAM to INNODB in phpMyAdmin

MySQL has a number of options for database storage. Two popular storage engines are MyISAM and INNODB. Each method has its advantages, and the purpose of this brief tutorial is not to debate which one is greater. If, however, you decide that you need to switch from one to the other, this guide should […]

How to Tunnel a MySQL Connection Through SSH

In a previous post, we highlighted some of the benefits of tunneling with SSH. Now, you will learn how to use an SSH tunnel to connect to MySQL remotely. With this method, you will connect to SSH, forwarding all information on port 3306 (the MySQL port) through this encrypted connection.
To get started, connect via SSH: […]

How to Grant MySQL Privileges with PHPMyAdmin

Managing MySQL from the command line is not exactly what one would call quick and easy. Also, there may be times when you do not have immediate access to SSH or have the time to type in multiple commands. Fortunately, phpMyAdmin offers a user-friendly and fast approach to managing your databases. For example, you can […]

Graphical Tools for Managing Cassandra

Apache Cassandra is a free and open source NoSQL database system, an alternative to relational database management systems (RDMS) such as MySQL. Originally developed by Facebook, Cassandra is designed to handle large amounts of data, heavy loads and high traffic sites. It comes with management tools such as cassandra-cli and node-tool, but those looking to […]

Must Have Linux/Unix Server Tools

Once you have deployed and booted up your first Linux server, you may suddenly find yourself in an awkward situation where you are unsure what to do next. There are so many options and so many ways to configure it that you might feel overwhelmed. The following tools are essentials for getting started with a […]

How to Reduce MySQL Server Load

MySQL is one of the most widely used relational database management systems (RDMS), but it can also be responsible for placing a heavy load on your server if you do not manage it well. The more traffic you get coming to your site, the harder your database server will have to work. While you can […]

Install LAMP on an Ubuntu Server Quickly and Easily

LAMP is a software stack for servers that refers to Linux Apache MySQL and PHP. It is still one of the most common configurations for servers and web applications, and it is very easy to install on Ubuntu servers. Simply follow these instructions:
The first part of LAMP, namely Linux, should already be installed, so […]

How to Setup Remote MySQL Access

Under normal circumstances, your MySQL server may only allow applications to connect to it locally, meaning both are running on the same server. If, however, you run MySQL on a separate machine, you will need to configure it to permit remote connections.
(Note: Replace terms in italics with the correct information from your own server)
Step […]

Understanding Log Files

If you are new to dedicated servers and have spent any time reading this site, you have undoubtedly come across posts from us reminding you to check and monitor your server’s log files. We even make sure to tell you where those log files are stored. In many cases, however, finding the log files is […]

How to Remove MySQL Databases and Users

You may spend a good portion of any given day adding users and databases to your MySQL server, but you might not spend much time removing them, even after you or your users no longer need them. Nevertheless, it is very important to not leave unattended databases and users lying around for would-be attackers […]

View Real-Time MySQL Loads with Innotop

MySQL is one of the most widely used database management systems. It is free and open source and works very well with dedicated servers designed to power websites. On Linux servers, a program called “top” allows you to see real-time load averages and usage for all running programs. If, however, you just want to see […]

How to Reinstall Packages on a Linux Server

Linux has a very unique method of installing applications. Most Linux distributions rely on package management systems that download package archives containing all of the files for an application and then copy them to their correct locations. Once the files are installed, any changes you make to them can affect the functionality of the app. […]

How to Find Things in a MySQL Database

Most modern websites run on some type of dynamic content management system. Many of them are powered by MySQL databases. In the event that you need to manually search for some information, there are two primary ways that you can search your database: 1) the MySQL command-line interface, and 2) a web-based interface like phpMyAdmin.
Command […]

How to Manage MySQL Users in Webmin

In a previous post, we looked at some of the ways in which you can manage a MySQL user from the mysql command-line prompt. Today, you will learn about managing MySQL users from within Webmin’s web-based control panel.
To begin managing MySQL in webmin, do the following:

Login to webmin and find the section called “Servers”
Click “MySQL […]

3 Database Types and When to Use Them

Databases come in many sizes and flavors. Knowing which one is best for the type of application/website and data you are using can save you a lot of time and money in the long term. The following are three common database types as well as scenarios when you might want to use them.
Flat-file Database – […]

MySQL User and Password Management

As you manage your dedicated server, you will invariably come across times when you need to reset passwords, add or delete accounts, or generally perform maintenance on your database users. When working with MySQL, there are a couple of simple ways to manage user accounts. The first involves accessing it from the command line, while […]

Advantages of Running a Free and Open Source Server

The majority of dedicated servers connected to the web use Apache HTTP Server, a free and open source web server program. Many servers also run Linux-based operating systems and rely on open source database servers, such as MySQL. Free and open source software has become quite prolific on the web, and there are many advantages […]

Back to the Basics #5:Other Server Software

Choosing your operating system and web server software is only the beginning. If you need a custom dedicated server built to your specifications, you will need to specify several other types of software, including database system, DNS, mail transfer agent (MTA), scripting languages (PHP, Ruby, Perl, etc.), firewall, virtualization, and more.
DNS – The management of […]

An Introduction to HTML5 Storage

System administrators do not normally concern themselves with web development, and blogs like Dedicated Server School are not normally in the business of discussing web design techniques, but there are some exceptions. The first notable exception occurs when the actions of web developers directly affect the performance of a server. Such is the case with […]

5 Server Logs You Should Routinely Check

One of the important things you can do with a dedicated server is to check it to ensure it is running smoothly and not experiencing any hidden problems. On Linux and Unix servers, log files can provide vital information about key components of your server. The following log files are ones you should routinely check:

Web […]

How to Copy All of the Tables from One Database to Another

Under normal circumstances, one of the easiest ways to copy the contents of one MySQL database to another is to use phpMyAdmin to dump the database to a file. You can then import the contents into your destination database. This usually works, but I recently encountered a situation where phpMyAdmin could not handle a particularly […]

How to Add and Drop MySQL Users

Most MySQL users manage their databases using some type of graphical user interface (GUI), whether it is a web-based tool like phpMyAdmin or a desktop tool like MySQL Administrator. For a dedicated server system administrator, however, there are times when it may actually be more convenient to use queries in the MySQL text-only command line […]

How to Setup ownCloud: Open Source Cloud File Storage

The cloud has become quite popular in the IT world. One could say that the cloud is taking the tech world by “storm”. There are many reasons for this, some financial, others practical, but ultimately it is an option that is worth considering.
The most popular form of cloud computing is the public cloud. In this […]

Moving from One OS to Another

In most situations, an individual or company will keep the same operating system for the entire time they use a server.  While there may be occasional upgrades, these usually do not involve switching to another OS completely.  At the end of the server’s life, however, you may decide to go with a different OS.  If […]

How to Manage MySQL Users in cPanel

MySQL is a powerful database server that you can use in conjunction with server-side scripting like PHP to enhance your websites with dynamic content.  By default, the only way to manage MySQL is from the command line. Fortunately, there are web-based tools like phpMyAdmin and cPanel that provide other options.
In cPanel, you can create and […]

How to Get Troubled Server Applications Fixed

Picture this.  You wake up one morning to several text messages, emails, and even voice mail messages all saying essentially the same thing.  Something is wrong with your dedicated server.  It could be something small, like a single web-based tool that is not functioning properly, or something huge like an […]