Database Manager

Administering your databases is easier than ever before, as a result of Web Hosting Control Panel interface for MySQL and PgSQL control! In case you do not have thorough knowledge in dealing with databases, you will find it effortless to work with our Database Manager.

You could make a new database simply by keying in the username and password or generate a database back–up with simply a click of the mouse. In addition, with the Data Manager you will get direct access to the management area for each individual database, to help you to conveniently modify it.

We have developed the manual database back–up creation into a quite simple task. To execute this: inside the Database Manager, click the ’clock’ symbol next to the database that you intend to back up and after that hang on for a few seconds for the process to take place. With regards to the size of the database, the generation of the backup file will need between a few seconds and a minute.

You can create as many backup copies per database as you desire. We have not determined any confines on the amount of databases that you could back up too.

PgSQL databases are less popular as opposed to the well–known MySQL databases. Having said that, they are a favorite choice for designers who seek the utmost security for their websites and web apps. Because of the intuitive Database Manager built–into the DukiyaHost Control Panel, you can administer your PostgreSQL databases with merely a mouse click.

You are going to find PgSQL databases provided automatically inside of the top Linux shared web hosting services packages. In case you are using a basic hosting package, it is easy to ask for PgSQL databases to be included in your web hosting account as upgrades.

The MySQL databases on DukiyaHost’s machines use the newest version of the InnoDB storage engine. InnoDB has been developed to ensure the top efficiency for websites that deal with huge volumes of data. It grants CPU performance that can not be matched by alternative disk–based relational database engines.

InnoDB is ACID–compliant and supplies 100% transaction support, which means you’re able to update/insert/create/alter/drop more than once for one "operation" of your application. In addition, it works by using row–level locking instead of MyISAM’s table–level locking, that enhances multi–user concurrency and functionality.

DukiyaHost offers you a very easy way to track the database use for your busy web sites. From the in–depth database statistics user interface, that is built into the Web Hosting Control Panel, you are able to observe the load created from your dynamic sites in real time. The delivered data will assist you to evaluate the database load variations on an hourly basis, daily or on a monthly basis.

You are able to keep an eye on the database load for all your web sites within the Database Stats section of the Web Hosting Control Panel. The table onscreen shows the database queries created within the present month. To have a look at information for a previous month, all you have to do is click on the back arrows positioned at the top.