Database Manager

Overseeing your databases is much simpler than before, on account of the Web Site Control Panel user interface for MySQL and PgSQL management! In case you do not have extensive knowledge in making use of databases, it will be an easy task to work with the Database Manager.

You can create a whole new database just by keying in the user name and security password or produce a database back–up with simply a mouse click. Moreover, from the Data Manager you will have direct access to the administrator area for every single database, meaning you can immediately manage it.

With the Database Manager it’s possible to produce an archived backup of your database when you desire! For this reason, you are going to always have a data backup of your dynamic information in the event your site gets broken into or you mistakenly get rid of a database. To generate a back–up: click on the ’clock’ symbol alongside a certain database and then just wait for a few seconds for the process to be performed.

There won’t be any limitations about the amount of databases you would be able to back up or the amount of backup copies you can create for a database.

Just about all of our Linux shared hosting packages bundles feature PgSQL support. While dropping behind MySQL when considering popularity and employment, PgSQL databases are famous for supplying the maximum level of protection for your web site content material. That’s the main reason why companies such as Skype and Yahoo make use of PgSQL databases instead of MySQL.

With regards to database management, PgSQL is as easy to use as MySQL.

The MySQL databases on our machines use the newest version of the InnoDB storage engine. InnoDB has been developed to guarantee the maximum performance for web sites that deal with sizeable amounts of data. It provides CPU performance that could not be equalled by other disk–based relational database engines.

InnoDB is ACID–compliant and offers 100% transaction support, meaning it is easy to update/insert/create/alter/drop many times for one "operation" of your app. Furthermore, it utilizes row–level locking and not MyISAM’s table–level locking, that increases multi–user concurrency and performance.

From the detailed database statistics tool included in the Web Site Control Panel, you are going to be able to keep track of the load generated by your active sites at any hour. Virtually any overload issue with your web sites could lower the loading rates and have a bad influence over the overall impression of your website visitors. Consequently, by having details about the database work right away, you will be able to solve overload difficulties as fast as possible.

The database data user interface shows data of the number of daily, hourly and monthly queries, to help you to assess just how the load is distributed over different time frames.