Database Manager

Database management may sound like a difficult job to unskilled hosting users, but with our Database Manager, it’s in fact quite simple! To set up a whole new database, you just ought to type in your username and password. Database backups are a mouse click away also.Those who choose to look into their databases and then alter them may use the phpMyAdmin and phpPgAdmin tools.

We have made the manual database back–up formation into a simple activity. To do this: inside the Database Manager, click the ’clock’ icon near the database that you would like to back up and then hang on for a couple of seconds for the backup process to take place. With regards to the size of the database, the creation of the back–up file will need between a couple of seconds and a minute.

You can make as many back–ups per database as you desire. We have not fixed any limitations for the quantity of databases that you could back up too.

PgSQL databases are less common compared to the widespread MySQL databases. Even so, they represent a favorite choice for web developers who seek the ultimate security for their sites and applications. Via the incredibly user–friendly Database Manager built–into the CDI Create Control Panel, you can administer all of your PostgreSQL databases with a click of the mouse.

You can find PgSQL databases incorporated automatically with the advanced shared website hosting plans packages. In case you are using a standard hosting package, you are able to request PgSQL databases to be added in your hosting account as upgrades.

The MySQL databases on our machines make use of the most recent version of the InnoDB storage engine. InnoDB is made to guarantee the highest efficiency for websites that operate with large amounts of data. It features CPU effectiveness that could not be matched by any other disk–based relational database engines.

InnoDB is ACID–compliant and provides full transaction support, meaning you’re able to update/insert/create/alter/drop many times for a single "operation" of your application. Moreover, it uses row–level locking as a substitute for MyISAM’s table–level locking, that increases multi–user concurrency and efficiency.

From the all–encompassing database stats tool built–into the Online Control Panel, it’s possible to keep track of the load accumulated from your active websites around the clock. Every single overload trouble with your sites could slow the loading rates and have a bad effect on the online experience of your respective website visitors. Consequently, having info about the database load live, it will be straightforward to resolve overload troubles right away.

The database data interface shows info of the number of daily, hourly and monthly lookups, which means you can examine just how the load is allocated over various time frames.