Within the Number One Hosting Website Control Panel you’re going to find a fully–fledged, intuitive Databases Manager! Put it to use to get total control over all your databases. It’s possible to simply configure new MySQL and PgSQL databases and administer them via the phpMyAdmin and phpPgAdmin software programs, respectively.
A Convenient–to–use Interface
Control your databases with just a mouse click
Overseeing your databases is easier than before, thanks to the Website Control Panel user interface for MySQL and PgSQL control! Even though you may not have detailed experience of handling databases, it will be an easy task to manage the Databases Manager.
You could make a completely new database by simply specifying the user name and security password or create a database backup with just a click of the mouse. Furthermore, via the Data Manager you have direct access to the administrator area for each and every database, so you can efficiently update it.
Straightforward Database Back–up
Guard your database information with only a click
Assuming you have dealt with databases, you know that creating a manual database backup just isn’t a simple task. In order to change this, we’ve created an effortless to use tool that can back up your whole database with simply a single click of the mouse. The backup file will be available for you in under a minute, depending upon the size of the selected database.
There won’t be any restrictions on the actual number of back–ups you could make for a specific database.
Support for PgSQL
Assured security for your databases
PgSQL databases are less common than the prevalent MySQL databases. Nevertheless, they’re a favorite choice for developers who seek the finest safety for their websites and web applications. Via the incredibly user–friendly Databases Manager incorporated into the Number One Hosting Control Panel, you can control all your PostgreSQL databases with just a click of the mouse.
You’ll find PgSQL databases integrated by default inside of the best shared hosting packages packages. Assuming that you are using a basic hosting package, you’ll be able to request PgSQL databases to be included in your web hosting account as upgrades.
The brand new face of MySQL
We have set up InnoDB – the new standard MySQL database engine on our servers. InnoDB is ideal for huge database sites that require high levels of efficiency and scalability. Trials have revealed that websites working with InnoDB based tables reach a 3–fold performance grow for substantial joins, compared to those working with MyISAM tables.
InnoDB makes use of row–level locking so as to take away the general performance difficulties discovered at the maximum usage times of the earlier variant of the database engine – MyISAM, which employs table–level locking.
Detailed Database Stats
Detailed stats for all your databases
With the broad database statistics tool built–into the Website Control Panel, it will be possible to make a record of the stress created from your dynamic web sites 24 / 7. Virtually any overload issue with your web sites can lower the loading speeds and have a bad effect on the overall experience of your site visitors. So, by having data for the database work right away, it will be easy to fix overload issues straight away.
The database stats user interface reveals info of the volume of daily, hourly and monthly lookups, which means you can evaluate how the load is allocated over several time periods.