Database Manager

Administering your databases is much easier than before, due to the Online Control Panel user interface for MySQL and PgSQL administration! In case you do not have extensive expertise in dealing with databases, it will be easy to deal with our Database Manager.

You could make a new database just by specifying the username and security password or generate a database backup with a simple mouse click. Additionally, via the Data Manager you’ll possess direct access to the administrator area for each individual database, to help you to quite simply update it.

From the Database Manager you’ll be able to generate an archived duplicate of your database when you wish! Therefore, you will always have a data backup of your active content material in the event your site gets compromised or you accidentally remove a database. To make a back–up: click on the ’clock’ image beside a given database and afterwards just wait for a few seconds for the process to be finished.

There are not any boundaries for the number of databases you would be able to back up or the quantity of back–ups you can create for any database.

Just about all of the shared hosting plans bundles provide PgSQL support. Although falling behind MySQL in terms of acceptance and application, PgSQL databases are renowned for providing the greatest level of safety for your site content material. That’s the primary reason why companies such as Skype and Yahoo rely upon PgSQL databases as opposed to MySQL.

When considering database administration, PgSQL is equally easy to use as MySQL.

The MySQL databases on KickAssDomains.com’s machines use the most recent release of the InnoDB storage engine. InnoDB has been made to ensure the max functionality for web sites that operate with significant volumes of data. It boasts CPU performance that can not be matched by any other different disk–based relational database engines.

InnoDB is ACID–compliant and supplies 100% transaction support, which means that it is easy to update/insert/create/alter/drop repeatedly for one "operation" of your app. Furthermore, it utilizes row–level locking in place of MyISAM’s table–level locking, that improves multi–user concurrency and effectiveness.

We supply you an uncomplicated solution to monitor the database consumption on your dynamic web sites. From the detailed database stats interface, which is built into the Online Control Panel, you’re able to keep track of the load produced from your busy sites in real time. The displayed data will enable you to assess the database load fluctuations each hour, per day or on a monthly basis.

You can track the database load for all of your sites in the Database Stats portion of the Online Control Panel. The table on–screen shows the database queries generated during the present month. To inspect details for a past month, just click on the back arrows located at the top.