Database Manager

Database management might sound like a hard task to beginner web hosting clients, nevertheless with DLive’s Database Manager, it’s actually pretty simple! To configure a whole new database, you just have to key in your username and password. Database backups are only a click away also.People that need to examine their databases and change them are able to use the phpMyAdmin and phpPgAdmin tools.

Within the Database Manager you are able to produce an archived backup of your database when you want! Therefore, you’ll always have a back–up of your dynamic content if your web site gets compromised or you accidentally remove a database. To create a backup: click the ’clock’ icon alongside any database and after that simply wait for a few seconds for the process to be executed.

There are no limits about the amount of databases you would be able to back up or the quantity of backups you can create for any database.

PgSQL databases are much less popular than the common MySQL databases. Nevertheless, they’re a favorite alternative for designers who are looking for the greatest security for their sites and applications. Through the easy–to–use Database Manager built–into the DLive Control Panel, you can administer all your PostgreSQL databases with a mouse click.

You can discover PgSQL databases provided by default inside the advanced shared hosting packages. In case you are using a standard hosting package, you can request PgSQL databases to be added to your website hosting account as upgrades.

We have added InnoDB – the brand new default MySQL database engine on every one of our servers. InnoDB is good for large database sites that need high functionality and scalability. Experiments have demonstrated that web sites applying InnoDB based tables achieve a 3–fold general performance increase for significant joins, when compared with those using MyISAM tables.

InnoDB uses row–level locking in an effort to eliminate the effectiveness problems seen at the maximum consumption times of the earlier version of the database engine – MyISAM, which uses table–level locking.

We offer you a pretty simple method to keep track of the database consumption on your active websites. Via the in depth database statistics user interface, which is included in the Web Control Panel, it’s possible to monitor the load accumulated by your dynamic websites in real time. The delivered info will let you evaluate the database load changes each hour, each day or on a monthly basis.

You’ll be able to record the database load for your websites through the Database Stats area of the Web Control Panel. The table on–screen shows the database queries generated within the present month. To assess info for an earlier month, just click on the back arrows positioned at the top.