Database Manager

Administering your databases now is easier than ever, because of the Web Control Panel interface for MySQL and PgSQL management! Even though you may not have detailed experience in making use of databases, it will be simple to handle our Database Manager.

You may create a completely new database by only typing the username and password or create a database backup with just a mouse click. Likewise, through the Data Manager you will have direct access to the admin area for each individual database, meaning you can quite simply alter it.

We have evolved the manual database back–up formation into a very easy job. To do so: in the Database Manager, click the ’clock’ symbol beside the database that you intend to back up and then wait for a couple of seconds for the process to take place. Depending upon the size of your database, the building of any back–up file will take somewhere between a couple of seconds and a minute.

You can make as many backups per database as you want. We haven’t specified any boundaries about the number of databases that you could back up too.

Almost all of Hosting Smiles’s shared web hosting plans feature PgSQL support. Whilst falling behind MySQL with regard to level of popularity and utilization, PgSQL databases are renowned for delivering the greatest level of stability for your site content. This is the primary reason why companies such as Skype and Yahoo use PgSQL databases as opposed to MySQL.

With respect to database management, PgSQL is identically uncomplicated as MySQL.

We have set up InnoDB – the new default MySQL database engine on every one of our web servers. InnoDB is perfect for big database websites that demand high levels of efficiency and scalability. Trials have demonstrated that web sites using InnoDB based tables reach a 3–fold performance boost for significant joins, when compared to those applying MyISAM tables.

InnoDB employs row–level locking as a way to eliminate the overall performance difficulties observed at the high usage times of the prior release of the database engine – MyISAM, which uses table–level locking.

We offer you a fairly easy option to observe the database use of your dynamic websites. Via the descriptive database stats user interface, that is built–into the Web Control Panel, you are able to track the load created through your dynamic sites in real time. The provided data will assist you to assess the database load variations on an hourly basis, on a daily basis or each month.

It’s possible to keep an eye on the database load for all of your web sites in the Database Stats part of the Web Control Panel. The table on–screen shows the database lookups accumulated during the present month. To take a look at info for a previous month, just click on the back arrows positioned at the top.