Database Manager

Administering your databases is simpler than ever, due to the Online Control Panel user interface for MySQL and PgSQL administration! Even though you may not have extensive experience of handling databases, you will find it simple to deal with the Database Manager.

You may create a new database by just specifying the user name and password or generate a database backup with a simple mouse click. Furthermore, with the Data Manager you will have direct access to the administrator area for each and every database, allowing you to almost instantly update it.

From the Database Manager you’ll be able to generate an archived backup of your database when you want! For this reason, you are going to always have a backup of your dynamic content material in case your web site gets compromised or if you mistakenly delete a database. To produce a back–up: click on the ’clock’ symbol beside a certain database and after that just wait for a few seconds for the backup process to be finished.

There are not any limitations on the volume of databases you are able to back up or the amount of backups you can create for a database.

You’re going to find PgSQL support in every one of our Linux shared web hosting packages bundles. PgSQL databases might not be as sought after and widespread as MySQL, nevertheless they give the maximum level of stability for your web site content and articles. Therefore, a number of well–known companies like Skype and Yahoo utilize PgSQL databases. Handling PgSQL databases is as easy as MySQL, because of the incredibly user–friendly interface of the Database Manager.

PgSQL databases are included by default with the most advanced web hosting plans. For the normal bundles, they are included as upgrades.

With appsulous, you will regularly find the latest edition of MySQL plus the default MySQL storage engine – InnoDB, set up.

InnoDB is much more secure in comparison to the former storage engine’s version – MyISAM. It is ACID–compliant and, even more importantly – it grants complete transaction support. In addition, it employs row–level locking, as opposed to MyISAM’s table–level locking, that used to lead to effectiveness troubles at high usage periods.

From the detailed database stats tool included in the Online Control Panel, you’re going to be able to keep track of the load accumulated by your dynamic websites round the clock. Virtually any overload difficulty with your sites could reduce the loading rates and have a damaging impact on the overall impression of your visitors. Hence, having data for the database load right away, it will be straightforward to resolve overload problems as soon as possible.

The database data user interface shows info of the volume of daily, hourly and monthly lookups, so its possible to examine just how the load is allocated over several time frames.