Database Manager

Managing your databases is much easier than ever, on account of the Hosting Control Panel interface for MySQL and PgSQL control! Assuming you do not have substantial expertise in managing databases, it will be an easy task to work with our Database Manager.

You can make a whole new database by just keying in the user name and password or make a database backup with just a click of the mouse. Likewise, within the Data Manager you’ll get direct access to the admin area for every database, allowing you to conveniently alter it.

We have changed the manual database backup creation into a very simple task. To execute this: inside of the Database Manager, click the ’clock’ symbol beside the database that you intend to back up and wait for a couple of seconds for the backup process to take place. Depending upon the size of your database, the building of a back–up file will need between a few seconds and a minute.

You can create as many backup copies of a database as you want. We’ve not set any boundaries about the amount of databases you can back up as well.

PgSQL databases are significantly less common as compared to the well–known MySQL databases. Nevertheless, they represent a favorite choice for web developers who are looking for the ultimate stability for their sites and applications. Due to the intuitive Database Manager incorporated into the 1CreationSiteWeb.Com Control Panel, you can administer your PostgreSQL databases with only a click of the mouse.

You will find PgSQL databases bundled automatically inside the top Linux shared packages packages. Assuming that you are using a basic hosting package, you are able to ask for PgSQL databases to be added in your account as upgrades.

With 1CreationSiteWeb.Com, you’ll inevitably discover the most recent edition of MySQL along with the default MySQL storage engine – InnoDB, set up.

InnoDB is much more reliable as compared to the former storage engine’s version – MyISAM. It’s ACID–compliant and, even more importantly – it has full transaction support. What’s more, it works by using row–level locking, rather than MyISAM’s table–level locking, that previously used to lead to efficiency problems at high usage occasions.

With the in–depth database stats tool built–into the Hosting Control Panel, it’s possible to keep a record of the stress created from your active sites twenty–four hours a day. Any overload problem with your sites can reduce the loading rates and have a bad impact on the online experience of your respective website visitors. So, by having information for the database load immediately, it will be possible to mend overload problems in a timely manner.

The database data interface shows information of the amount of daily, hourly and monthly lookups, in order to assess the way the load is distributed over several time frames.