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 […]

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: […]

Speed Up Your Web Applications with Memcached

Most modern websites are dynamic in nature. They are updated on the fly, rely on database backends and often feature some type of support for user interaction. While those aspects of dynamic websites are all positive, the negative side is that they require more system resources, especially memory. A more resource-intense web application can slow […]

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 […]

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 […]

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 […]

Is the End of the Year a Good Time for Major Changes?

As we approach the new year, it might be tempting to make sweeping changes to your organization and to your dedicated server. This is a normal feeling. After all, even in our daily lives, we often start the new year with resolutions (ones that are often too high-reaching and hard to keep). The question posed […]

The Big Truth about Big Data: Part 2

In part one, we defined big data, but the name big data really only tells you what the problem is. It does not address the solution. You have this massive amount of unstructured data, and you have no way of organizing it. What should you do? This is where big data solutions come […]

The Big Truth about Big Data: Part 1

The business world is abuzz with talk of “big data”, but many people probably still do not have a firm grasp on what it means and how it will impact the IT world. If you manage servers for a living, there is a good chance that you will soon encounter an employer or client who […]

3 Types of Database Backup Storage

Most websites use databases to store the majority of their information. Therefore, backing up your databases is much more important than backing up other server files. Most other files can be replaced, but the information in your database is often unique and irreplaceable.
Where you store your database backups is very important and can ultimately decide […]

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 […]

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 […]

How to Connect to a Virtualbox VM Via SSH (Part 2)

Continued from Part 1. Next, you need to configure Virtualbox to appear on your network. You can do this by using a second virtual network device. Do the following:

Click File…Preferences
Choose “Network” and add a new device if one is not already present by click the green plus.
You should then have a device called vboxnet0 or […]

Finding Server Files with the Locate Command

When you have a dedicated server, it can sometimes be difficult to find the files you need. Tools like “find” and “grep” are always at your disposal, but as they dig through your mountain of data, they can take a good deal of time. Fortunately, Linux and Unix servers have a tool called “locate” that […]

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 […]

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 […]

Benefits of Running a Database-Only Server

When you first start out in the world of dedicated servers, you may have no other financial option than to run your web server and database server on the same machine.  As your business or non-profit grows, however, it may be necessary to consider other options, such as cloud computing or starting a new server […]

Connecting to MySQL from a Remote Location

The most common way to work with and manage MySQL is directly, using the command line or a web-based tool such as phpMyAdmin.  If, however, you have more than one database server or need to do routine complex tasks, the former may be too tedious, and the latter may be too simple.  Another possible reason […]

8 Signs That It’s Time to Get a Dedicated Server

Sometimes it is difficult to know when it is time to make the move from one technology to another, or when to upgrade from one version to a later one.  As your website or websites grow, it is important to track their progress, understand their weaknesses, and be prepared to take them to the next […]

MySQL Backup with AutoMySQLBackup

With the emergence of dynamic websites, most sites on your dedicated server probably use some form of database.  Chances are, if a site uses a database, it is running on MySQL or other SQL server.  It is no longer sufficient for system administrators or even individual website owners to only backup the contents of a […]

How to Optimize MySQL Databases in SSH

Optimizing your MySQL database can help it run better, reduce fragmentation, and ultimately give you a boost in performance.  In many cases, you can optimize your MySQL database using a graphical frontend, such as phpMyAdmin, but in some instances it is quicker and easier to run the command from within an SSH session, especially if […]

Alternatives to MySQL Database Server

Because most of today’s websites are dynamic and use server-side scripting, it is pretty much expected for dedicated servers to have some form of database management, either in the form of a full database server or a set of database libraries. MySQL is one of the most widely-used relational database management systems (RDBMS). […]

Benefits and Disadvantages of Server-Side Scripting

Server-side scripting is a method of programming for the web that relies on software running on the server to execute instructions rather than the user’s browser or installed plugins.  In this way, the resulting page or web application appears to be a regularly generated HTML page at the time of loading.  Some of the benefits […]