Database Manager

The Database Manager in the Hosting Control Panel incorporates an effective yet well designed interface. You are able to configure a whole new MySQL or PostgreSQL database by just entering a user name and security password. Additionally, you can make a back–up file or modify the security password of the database with just a click of the mouse.

Via the Database Manager you’ll possess direct access to the administrative area for every one of your databases, so you’re able to make simple and easy modifications when you need to.

Within the Database Manager it’s easy to create an archived backup of your database when you desire! For this reason, you will always have a back–up of your operating content if your website gets compromised or if you mistakenly erase a database. To make a back–up: click on the ’clock’ icon beside a certain database and then just wait for a couple of seconds for the backup process to be performed.

There are not any boundaries for the number of databases you would be able to back up or the amount of backup copies you can create for a database.

You are going to find PgSQL support in all of our cloud plans offers. PgSQL databases are not as sought after and commonly used as MySQL, nevertheless they deliver the top level of stability for your site content. For this reason, a lot of famous companies like Skype and Yahoo utilize PgSQL databases. Dealing with PgSQL databases is as easy and simple as MySQL, because of the incredibly user–friendly user interface of the Database Manager.

PgSQL databases are provided automatically with the most sophisticated web hosting plans. For the basic packages, they’re featured as upgrades.

The MySQL databases on Kremer Design’s web servers use the most recent build of the InnoDB storage engine. InnoDB is designed to guarantee the top functionality for sites that process sizeable amounts of data. It presents CPU performance that can not be matched by other different disk–based relational database engines.

InnoDB is ACID–compliant and provides total transaction support, which means it’s possible to update/insert/create/alter/drop repeatedly for a single "operation" of your application. At the same time, it employs row–level locking and not MyISAM’s table–level locking, that increases multi–user concurrency and efficiency.

From the all–encompassing database statistics tool integrated into the Hosting Control Panel, it will be possible to keep a record of the stress created through your dynamic sites round the clock. Every overload problem with your sites could reduce the loading rates and have a damaging impact on the overall impression of your respective site visitors. Consequently, by having data about the database load in real time, it will be easy to fix overload troubles as quickly as possible.

The database statistics user interface shows data of the number of daily, hourly and monthly queries, so you can evaluate just how the load is allocated over several time frames.