Database Manager

The Database Manager inside our Web Site Control Panel incorporates a robust yet convenient to use user interface. You are able to configure a new MySQL or PostgreSQL database by simply entering a user name and password. Also, you could make a back–up file or modify the security password of any database with merely a mouse click.

From the Database Manager you have immediate access to the administrative area for every one of your databases, so that you can make effortless alterations in case you need to.

From the Database Manager you’re able to generate an archived backup of your database anytime you need! For this reason, you will always have a backup of your active information if your site gets broken into or you incorrectly erase a database. To produce a back–up: click the ’clock’ image alongside a certain database and afterwards wait for a few seconds for the process to be done.

There are no limitations about the number of databases you can back up or the amount of backup copies you can create for a database.

PgSQL databases are significantly less sought after when compared to the well–known MySQL databases. Then again, they represent a favorite option for programmers who are looking for the best protection for their sites and web apps. Thanks to the user–friendly Database Manager included in the Ameriline Hosting Control Panel, you can administer all your PostgreSQL databases with simply a mouse click.

Yow will discover PgSQL databases bundled automatically within the top shared website hosting plans packages. Provided that you are with a basic hosting package, it’s possible to request PgSQL databases to be added in your web hosting account as upgrades.

With Ameriline Hosting, you’ll invariably discover the newest version of MySQL along with the default MySQL storage engine – InnoDB, mounted.

InnoDB is more dependable as compared to the old storage engine’s edition – MyISAM. It is ACID–compliant and, above all – it has total transaction support. It also uses row–level locking, as opposed to MyISAM’s table–level locking, that seemed to lead to functionality problems at peak usage occasions.

Keeping track of the load caused by the databases in your dynamic web site makes it possible to reduce any kind of overload problems that might slow it down and ward off visitors. For this purpose, we’ve built in a in depth Database Stats tool straight into the Web Site Control Panel. There you can get broad information about the inbound requests to your databases for each hour, day and month.

Based on the amount of daily and by the hour queries, it will be straightforward to find out what databases are being used the most and also take actions to optimize their work.