Database Manager

Database management may seem like a hard task to new website hosting customers, however with the Database Manager, it’s in fact simple! To set up a completely new database, you only have to key in your username and password. Database backups are a click away as well.People who choose to examine their databases and also revise them should use the phpMyAdmin and phpPgAdmin tools.

We have developed the manual database backup generation into a very simple job. To execute this: inside the Database Manager, click the ’clock’ symbol beside the database that you plan to back up and after that wait around for a few seconds for the backup process to take place. Depending upon the size of your database, the creation of the back–up file will take somewhere between a few seconds and a minute.

You may make as many back–ups per database as you wish. We haven’t set any restrictions about the amount of databases you could back up as well.

PgSQL databases are much less sought after compared to the prevalent MySQL databases. Then again, they represent a favored choice for designers seeking the ultimate protection for their web sites and web apps. Through the intuitive Database Manager incorporated into the SATINWEB Control Panel, you can administer all your PostgreSQL databases with a mouse click.

Yow will discover PgSQL databases bundled automatically within the top hosting packages. If you are with a basic hosting package, you’ll be able to ask for PgSQL databases to be added to your website hosting account as upgrades.

We have set up InnoDB – the new standard MySQL database engine on all our machines. InnoDB is made for substantial database web sites that need high efficiency and scalability. Experiments have revealed that web sites employing InnoDB based tables reach a 3–fold efficiency increase for substantial joins, when compared with those applying MyISAM tables.

InnoDB uses row–level locking in an effort to eliminate performance difficulties found at the high consumption times of the earlier release of the database engine – MyISAM, which utilizes table–level locking.

Keeping tabs on the load made by the databases in your powerful web site assists you to reduce any sort of overload problems that might slow it down and ward off site visitors. As a result, we have provided a thorough Database Stats tool straight into the Web Hosting Control Panel. There you shall find comprehensive information regarding the inbound requests to your databases for every single hour, day and month.

In line with the number of day–to–day and hourly queries, it will be straightforward to find out what databases are utilized the most and also take procedures to enhance their work.