Archive for the 'Database Management' Category

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

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

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

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

The Big Truth about Big Data: Part 3

In part one, we defined big data, and in part two, we talked a little about why companies might need big data and how an open source solution might be the best way to go. In this part, we will take a look at one open source solution that is making headlines. It is called […]

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

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

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

How to Increase MySQL Memory Usage Above 2GB

MySQL is a great database server for small, medium, and large websites, but large sites may find that the database alone can consume a great deal of system resources.  Ideally, you should be able to increase resources (i.e. more processors and more memory) in order to get better performance.  In reality, however, there are some […]

7 Ways to Troubleshoot Database Connections

With most of the world using dynamic websites, databases have become a regular part of the web hosting experience. Even if your database always works and run smoothly, you may have users on your dedicated server who are not so fortunate. Because many applications, scripts, and users may attempt to access the database […]

How to Manually Grant MySQL Privileges

Under normally functioning circumstances, you may never need to manually grant privileges in MySQL. When creating databases in cPanel, phpMyAdmin, or any other web-based interface, you can easily accomplish the same task without accessing the command line. In rare instances, however, those frontends may not work or may not be easily accessible to […]

MySQL Administration with phpMyAdmin

MySQL administration from the command line is an excellent skill to know, just in case you need it, but sometimes, graphical interfaces are easier and faster. Web-based configuration is also important if your dedicated server hosts websites for other users. You might not want them poking around in MySQL via SSH. In […]

Automatic MySQL Backup

Most websites these days rely on content management systems, blogging software, and other types of web applications and scripts to update, manage, and configure them. Rather than static HTML pages stored in the user’s home directory, most content is now stored in databases.
As a dedicated server administrator, it is imperative that you have backups […]

How to Export a MySQL Database

There are a few reasons why you might need to export a MySQL database. If you ever need to transfer your data to a new server, backup your databases, or provide a former client with their website content, being able to quickly and easily backup a database is important.
With phpMyAdmin and other web-based management […]

Optimizing the performance of your hosted MYSQL Database

More performance! When it comes to Mysql database hosting the issue of more speed and performance is always paramount. So to help you achieve that we want to provide you some tips for understanding the query cache and optimizing it based on your usage for the best database performance.
The query cache operates independently […]

How to Automatically Optimize MySQL Databases

Running a dedicated server can be time consuming. There are a myriad of logs, services, and users to check and recheck. Any automation you can setup will greatly reduce your daily, weekly, and monthly work load. Cron is a handy way to automate tasks, as we have previously demonstrated.
MySQL databases, in particular, […]