Database Manager

The Database Manager within our Web Hosting Control Panel features a powerful but still user–friendly and uncomplicated interface. You are able to set up a new MySQL or PostgreSQL database by simply typing in a username and password. Furthermore, you could make a backup file or change the security password of an database with just a mouse click.

Within the Database Manager you will possess direct access to the administrator area for every one of your databases, so its possible to make quick changes when you need to.

In case you have dealt with databases, you already know that generating a manual database back–up is just not a basic task. So as to change this, we’ve made an effortless to use tool that can back up your complete database with just a single click of the mouse. The data backup file will be prepared for you in less than a minute, depending on the size of the chosen database.

There are no limitations on the actual number of backups you can make for a selected database.

PgSQL databases are much less widespread in comparison to the popular MySQL databases. Then again, they represent a preferred option for developers seeking the finest stability for their sites and web applications. Because of the easy–to–use Database Manager built into the SmartBuy Web Hosting Control Panel, you can control your PostgreSQL databases with just a mouse click.

You are going to find PgSQL databases included by default with the best Linux cloud hosting packages packages. If you are using a regular hosting package, you can request PgSQL databases to be included in your website hosting account as upgrades.

The MySQL databases on our machines make use of the newest version of the InnoDB storage engine. InnoDB has been built to guarantee the highest possible effectiveness for sites that work with sizeable volumes of data. It delivers CPU effectiveness that could not be matched by other disk–based relational database engines.

InnoDB is ACID–compliant and offers full transaction support, meaning you can update/insert/create/alter/drop many times for one "operation" of your web application. Additionally, it takes advantage of row–level locking in contrast to MyISAM’s table–level locking, that increases multi–user concurrency and performance.

From your comprehensive database statistics tool incorporated into the Web Hosting Control Panel, you are able to keep a record of the load created from your busy sites at any hour. Every single overload difficulty with your websites could slow the loading speeds and have a bad influence over the online experience of your respective website visitors. Thus, having info for the database work instantly, it is also possible to resolve overload troubles at once.

The database stats interface displays information of the number of daily, hourly and monthly queries, so its possible to examine just how the load is spread over different time periods.