Database Manager

The Database Manager in our Website Control Panel provides a robust but simplified interface. It is easy to set up a completely new MySQL or PostgreSQL database by just entering a username and password. Moreover, you can make a back–up file or modify the password of an database with just a mouse click.

Through the Database Manager you will get immediate access to the management area for all of your databases, so that you can make simple modifications should you have to.

From the Database Manager you can produce an archived copy of your database whenever you wish! That way, you are going to always have a back–up of your active content if your website gets compromised or you incorrectly erase a database. To produce a back–up: click on the ’clock’ icon next to a certain database and afterwards just wait for a couple of seconds for the backup process to be executed.

There are not any boundaries on the amount of databases you would be able to back up or the number of backups you can create for a database.

PgSQL databases are significantly less sought after in comparison to the standard MySQL databases. Nonetheless, they’re a preferred selection for developers who are looking for the finest protection for their web sites and web apps. Through the incredibly user–friendly Database Manager built into the TERIONET Control Panel, you can administer your PostgreSQL databases with merely a mouse click.

You are going to find PgSQL databases provided by default within the advanced Linux web hosting packages. If you are with a standard hosting package, you are able to ask for PgSQL databases to be added in your cloud hosting account as upgrades.

We’ve added InnoDB – the brand new default MySQL database engine on all our web servers. InnoDB is good for significant database sites which need high levels of general performance and scalability. Trials indicate that websites working with InnoDB based tables attain a 3–fold functionality increase for very large joins, compared to those using MyISAM tables.

InnoDB takes advantage of row–level locking in an effort to remove the effectiveness problems seen at the maximum usage times of the earlier variant of the database engine – MyISAM, which uses table–level locking.

From your in depth database statistics tool built into the Website Control Panel, it’s possible to keep a record of the load accumulated by your active web sites twenty–four hours a day. Every single overload difficulty with your websites can lower the loading speeds and have a damaging influence over the overall experience of your respective visitors. Which means that, having info about the database work live, you will be able to solve overload troubles as soon as possible.

The database data user interface shows data of the quantity of daily, hourly and monthly lookups, meaning you can review just how the load is spread over various periods of time.