Database Manager

Database management might sound like a difficult job to inexperienced cloud hosting customers, nevertheless with Toxist’s Database Manager, it’s actually really simple! To create a new database, you just have to enter your username and password. Database back–ups are simply a mouse click away on top of that.People who want to explore their databases and also revise them are able to use the phpMyAdmin and phpPgAdmin tools.

Via the Database Manager you’ll be able to create an archived backup of your database when you wish! Therefore, you will always have a back–up of your dynamic information in the event your website gets broken into or if you accidentally erase a database. To produce a backup: click the ’clock’ image beside any database and afterwards simply wait for a couple of seconds for the process to be performed.

There are not any limits for the amount of databases you are able to back up or the number of backups you may make for a database.

PgSQL databases are less common than the widespread MySQL databases. Nevertheless, they represent a favored selection for designers who seek the best stability for their sites and web applications. Because of the user–friendly Database Manager built into the Toxist Control Panel, you can control all your PostgreSQL databases with just a click of the mouse.

You’ll find PgSQL databases provided by default within the top cloud hosting packages. If you are with a basic hosting package, it is possible to ask for PgSQL databases to be added in your cloud hosting account as upgrades.

The MySQL databases on Toxist’s machines work with the most recent release of the InnoDB storage engine. InnoDB was made to guarantee the maximum functionality for sites that operate with big amounts of data. It supplies CPU effectiveness that could not be equalled by any other different disk–based relational database engines.

InnoDB is ACID–compliant and gives 100% transaction support, which means it is possible to update/insert/create/alter/drop many times for one "operation" of your app. At the same time, it utilizes row–level locking instead of MyISAM’s table–level locking, that increases multi–user concurrency and functionality.

Monitoring the load generated by the databases on your powerful website makes it possible to avoid any kind of overload difficulties that can slow it down and chase away visitors. For that reason, we’ve designed a in depth Database Stats tool into your Web Site Control Panel. There you can find comprehensive information regarding the incoming requests to your databases for every hour, day and month.

Based on the volume of daily and per hour queries, you’re going to be able to find out which databases are utilized the most and consider measures to enhance their load.