Database Manager

Taking control of your databases is simpler than before, due to the Website Control Panel interface for MySQL and PgSQL control! In case you do not have thorough expertise in making use of databases, you will find it an easy task to work with our Database Manager.

You can make a completely new database just by keying in the user name and password or create a database backup with only a mouse click. Additionally, with the Data Manager you will get direct access to the administrator area for every database, so you can almost instantly modify it.

Assuming you have worked with databases, you are aware that making a manual database backup just isn’t a simple task. So as to change this, we have developed a simple and easy to use tool that can back up your whole database with just one mouse click. The data backup file shall be set for you in less than a minute, with regards to the size of the selected database.

There won’t be any restrictions on just how many back–ups you could make for a selected database.

PgSQL databases are significantly less sought after when compared to the prevalent MySQL databases. Even so, they represent a favorite option for designers seeking the maximum stability for their websites and applications. Thanks to the intuitive Database Manager built into the Pivad Design Control Panel, you can manage all your PostgreSQL databases with only a click of the mouse.

You are going to find PgSQL databases included by default within the top cloud web hosting packages. In case you are with a basic hosting package, you can ask for PgSQL databases to be added to your web hosting account as upgrades.

The MySQL databases on Pivad Design’s servers make use of the newest version of the InnoDB storage engine. InnoDB has been created to ensure the highest efficiency for web sites that deal with big volumes of data. It supplies CPU efficiency that can not be equalled by alternative disk–based relational database engines.

InnoDB is ACID–compliant and offers full transaction support, so that you’re able to update/insert/create/alter/drop a couple of times for one "operation" of your application. At the same time, it takes advantage of row–level locking in lieu of MyISAM’s table–level locking, that boosts multi–user concurrency and efficiency.

From the in–depth database statistics tool included in the Website Control Panel, you are going to be able to make a record of the load created by your busy web sites 24 hour a day. Virtually any overload difficulty with your web sites can slow the loading speeds and have a bad influence over the overall impression of your website visitors. So, having details for the database work live, it is possible to solve overload problems right away.

The database stats user interface reveals information of the amount of daily, hourly and monthly lookups, which enables you to evaluate the way the load is distributed over various time frames.