Database Manager

The Database Manager within our Online Control Panel has an effective nevertheless simple to use user interface. You’re able to configure a completely new MySQL or PostgreSQL database by just typing in a username and security password. Moreover, you may create a backup file or change the password of the database with simply a click of the mouse.

With the Database Manager you will possess immediate access to the administration area for all of your databases, which means you can make easy modifications in the event you need to.

From the Database Manager you can easily make an archived backup of your database whenever you want! For this reason, you are going to always have a backup of your dynamic information in the event your website gets broken into or you accidentally delete a database. To generate a back–up: click on the ’clock’ symbol alongside a given database and then simply wait for a couple of seconds for the process to be finished.

There aren’t any restrictions about the number of databases you are able to back up or the volume of back–ups you can create for a database.

The majority of the Linux shared hosting packages plans grant PgSQL support. Although falling behind MySQL when considering acceptance and usage, PgSQL databases are famous for providing the greatest level of security for your web site content. That is the reason why businesses like Skype and Yahoo go with PgSQL databases as a substitute for MySQL.

When it comes to database management, PgSQL is just as simple and easy as MySQL.

The MySQL databases on our servers use the newest build of the InnoDB storage engine. InnoDB was built to ensure the highest efficiency for sites that deal with huge volumes of data. It supplies CPU efficiency that could not be equalled by alternative disk–based relational database engines.

InnoDB is ACID–compliant and grants 100% transaction support, meaning that you’re able to update/insert/create/alter/drop repeatedly for a single "operation" of your web application. Additionally, it uses row–level locking in lieu of MyISAM’s table–level locking, that improves multi–user concurrency and efficiency.

With the in depth database stats tool built–into the Online Control Panel, you will be able to make a record of the stress created through your dynamic web sites 24 / 7. Every overload issue with your sites could slow the loading rates and have a damaging effect on the overall experience of your respective visitors. Thus, having information for the database load immediately, you are able to resolve overload problems right away.

The database statistics user interface reveals data of the number of daily, hourly and monthly lookups, in order to analyze how the load is allocated over various periods of time.