Database Manager

Database management may seem like a hard task to unskilled hosting customers, nevertheless with our Database Manager, it’s actually relatively easy! To set up a brand new database, you only ought to type in your username and password. Database backup copies are a mouse click away also.People who would like to examine their databases as well as revise them may use the phpMyAdmin and phpPgAdmin tools.

We have transformed the manual database backup formation into a very easy activity. To do so: inside of the Database Manager, click the ’clock’ symbol next to the database that you want to back up and after that wait around for a couple of seconds for the process to take place. Depending on the size of the database, the building of the backup file will take between a few seconds and a minute.

You can create as many back–ups of a database as you want. We’ve not fixed any restrictions for the amount of databases that you could back up too.

Nearly all of Crane Internet Solutions’s shared web hosting packages provide PgSQL support. Whilst dropping behind MySQL with respect to reputation and application, PgSQL databases are famous for providing the top level of stability for your web site content material. That is the primary reason why brands like Skype and Yahoo employ PgSQL databases as a substitute for MySQL.

When it comes to database management, PgSQL is identically simple and easy as MySQL.

The MySQL databases on our web servers use the latest version of the InnoDB storage engine. InnoDB has been meant to ensure the highest possible functionality for websites that operate with massive amounts of data. It supplies CPU performance that could not be matched up by alternative disk–based relational database engines.

InnoDB is ACID–compliant and provides full transaction support, meaning that it is possible to update/insert/create/alter/drop more than once for one "operation" of your app. Moreover, it takes advantage of row–level locking as an alternative to MyISAM’s table–level locking, that improves multi–user concurrency and effectiveness.

Through the all–inclusive database stats tool built–into the Hosting Control Panel, you are going to be able to keep track of the load accumulated through your active sites round the clock. Every single overload trouble with your sites could slow the loading speeds and have a damaging effect on the overall experience of your respective website visitors. Thus, by having information for the database work right away, you are able to mend overload issues promptly.

The database statistics interface reveals details of the volume of daily, hourly and monthly queries, so its possible to analyze just how the load is spread over various time frames.