Database Manager

The Database Manager inside our Web Site Control Panel features a powerful yet simple to use user interface. You can set up a brand new MySQL or PostgreSQL database by just entering a username and security password. Also, you can make a backup file or alter the password of a database with a mouse click.

With the Database Manager you will get direct access to the administrator area for all your databases, meaning you can make easy adjustments in the event you need to.

If you have dealt with databases, you already know that creating a manual database back–up is simply not a basic job. As a way to change this, we’ve created very simple tool that will back up your whole database with only one mouse click. The back–up file will be all set for you in under a minute, with respect to the size of the chosen database.

There won’t be any confines on exactly how many back–ups you can make for any specific database.

PgSQL databases are much less famous as opposed to the standard MySQL databases. On the other hand, they’re a favorite selection for designers seeking the greatest safety for their web sites and web apps. Through the intuitive Database Manager included in the Optimum Web2b Control Panel, you can manage all of your PostgreSQL databases with simply a click of the mouse.

You can discover PgSQL databases incorporated by default with the best shared website hosting plans packages. In case you are using a standard hosting package, it is easy to request PgSQL databases to be added in your hosting account as upgrades.

We’ve set up InnoDB – the brand new default MySQL database engine on our machines. InnoDB is great for big database sites that require high functionality and scalability. Tests have demonstrated that sites employing InnoDB based tables achieve a 3–fold overall performance increase for very large joins, as compared to those applying MyISAM tables.

InnoDB utilizes row–level locking in order to remove the efficiency difficulties discovered at the maximum consumption times of the previous version of the database engine – MyISAM, which utilizes table–level locking.

With the comprehensive database stats tool built–into the Web Site Control Panel, you are going to be able to keep a record of the load accumulated through your active sites around the clock. Any overload difficulty with your sites could lower the loading speeds and have a negative impact on the overall impression of your visitors. Hence, by having information for the database load in real time, you’ll be able to solve overload troubles in a timely manner.

The database statistics interface reveals information of the volume of daily, hourly and monthly queries, so you can assess how the load is allocated over various periods of time.