Through the Database Manager included in the Online Control Panel, it is also possible to make brand–new MySQL and PgSQL databases right away! Additionally, you’ve got direct access to the admin area software tools (phpMyAdmin and phpPgAdmin, respectively), which enables you to immediately alter the database you want.
A Simple point and click User interface
The most effective database control user interface
Database management may appear like a difficult task to new cloud hosting users, but with Hostlalia Unlimited Hosting’s Database Manager, it’s in fact quite simple! To configure a whole new database, you simply need to type in the username and password. Database backup copies are simply a mouse click away at the same time.Those who choose to look into their databases as well as revise them can make use of the phpMyAdmin and phpPgAdmin tools.
Simple and quick Database Backup
Database backup copies can be a mouse click away
Via the Database Manager you are able to make an archived duplicate of your database whenever you would like! That way, you’ll always have a back–up of your dynamic content material in case your website gets broken into or you incorrectly remove a database. To create a back–up: click the ’clock’ image next to a certain database and then wait for a couple of seconds for the process to be done.
There aren’t any restrictions about the volume of databases you are able to back up or the amount of backups you can create for a database.
By far the most stable open source databases
Almost all of the Linux shared web hosting plans provide PgSQL support. Whilst falling behind MySQL when considering popularity and employment, PgSQL databases are renowned for offering the highest level of security for your web site content material. That is the primary reason why businesses like Skype and Yahoo rely upon PgSQL databases as an alternative to MySQL.
In terms of database administration, PgSQL is just as easy to understand as MySQL.
The fresh face of MySQL
We have incorporated InnoDB – the new standard MySQL database engine on our web servers. InnoDB is good for big database sites that need high functionality and scalability. Experiments have established that sites making use of InnoDB based tables attain a 3–fold operation grow for huge joins, in comparison with those employing MyISAM tables.
InnoDB employs row–level locking in an effort to eliminate the overall performance difficulties witnessed at the maximum usage times of the earlier version of the database engine – MyISAM, which utilizes table–level locking.
Detailed Database Stats
In depth statistics for your databases
Checking the load accumulated by the databases within your powerful website assists you to avoid all kinds of overload difficulties that might slow it down and ward off visitors. For this purpose, we’ve incorporated a comprehensive Database Stats tool into your Online Control Panel. There you can see broad information about the arriving requests to your databases for every hour, day and month.
Depending on the amount of daily and per hour queries, you are going to be able to find out what databases are employed the most and also consider actions to optimize their work.