Databases Manager

Database management may sound like a hard task to newbie hosting customers, however with the Databases Manager, it’s in fact reasonably easy! To set up a brand new database, you just have to key in the username and password. Database back–ups are just a click away on top of that.People that choose to look into their databases and then modify them can make use of the phpMyAdmin and phpPgAdmin tools.

We have designed the manual database back–up formation into a quite simple activity. To execute that: within the Databases Manager, click the ’clock’ symbol next to the database that you would like to back up and afterwards wait for a few seconds for the backup process to take place. With regards to the size of your database, the building of a backup file is going to take between a few seconds and a minute.

You may make as many copies of a database as you wish. We have not set any limits for the amount of databases you can back up either.

PgSQL databases are much less sought after than the widespread MySQL databases. Nonetheless, they represent a favored option for developers seeking the utmost safety for their web sites and applications. Via the user–friendly Databases Manager incorporated into the Ezi Web Hosting Services Control Panel, you can administer all your PostgreSQL databases with a click of the mouse.

You can discover PgSQL databases provided automatically inside the best cloud hosting packages. Assuming that you are with a regular hosting package, you can easily request PgSQL databases to be added to your hosting account as upgrades.

We’ve set up InnoDB – the brand new standard MySQL database engine on every one of our servers. InnoDB is great for massive database sites which need high levels of overall performance and scalability. Tests have shown that sites making use of InnoDB based tables attain a 3–fold performance grow for significant joins, compared to those applying MyISAM tables.

InnoDB utilizes row–level locking as a way to get rid of the performance issues spotted at the maximum usage times of the earlier release of the database engine – MyISAM, which employs table–level locking.

Monitoring the load produced by the databases within your active site makes it possible to prevent any sort of overload difficulties that can slow it down and ward off site visitors. For this purpose, we’ve bundled a detailed Database Stats tool in the Website Control Panel. There you can see extensive info on the inbound requests to your databases for every single hour, day and month.

In line with the amount of day–to–day and hourly queries, it will be easy to determine which databases are being used the most and then consider steps to optimize their work.