Databases Manager

The Databases Manager in our Online Control Panel incorporates a refined but simple to use user interface. You can easily set up a whole new MySQL or PostgreSQL database by just specifying a user name and security password. Also, you may create a backup file or customize the password of the database with merely a click of the mouse.

Via the Databases Manager you’ll have direct access to the admin area for each of your databases, which enables you to make effortless modifications should you have to.

Within the Databases Manager it is simple to make an archived duplicate of your database whenever you wish! Thus, you will always have a back–up of your active information if your web site gets compromised or you accidentally eliminate a database. To generate a back–up: click on the ’clock’ symbol alongside any database and then wait for a few seconds for the backup process to be completed.

There won’t be any confines about the quantity of databases you are able to back up or the amount of backup copies you can make for a database.

PgSQL databases are significantly less common in comparison to the standard MySQL databases. Then again, they are a favored choice for developers who are looking for the utmost safety for their sites and web applications. Through the incredibly user–friendly Databases Manager integrated into the SpacefishX Control Panel, you can control your PostgreSQL databases with a click of the mouse.

You’ll find PgSQL databases included by default inside of the top Linux cloud packages packages. Assuming that you are with a standard hosting package, it is easy to request PgSQL databases to be added in your web hosting account as upgrades.

We’ve set up InnoDB – the new standard MySQL database engine on all our servers. InnoDB is ideal for massive database sites that need high efficiency and scalability. Experiments indicate that websites utilizing InnoDB based tables achieve a 3–fold general performance boost for huge joins, in comparison with those working with MyISAM tables.

InnoDB uses row–level locking so as to get rid of the functionality problems spotted at the high consumption times of the prior variant of the database engine – MyISAM, which employs table–level locking.

Through the comprehensive database stats tool incorporated into the Online Control Panel, it’s possible to keep a record of the stress created by your dynamic websites at any hour. Virtually any overload difficulty with your sites could slow the loading speeds and have a bad influence over the overall experience of your respective website visitors. So, by having information about the database load right away, you will be able to eliminate overload troubles quickly.

The database stats interface displays details of the quantity of daily, hourly and monthly queries, allowing you to review just how the load is distributed over different time periods.