Inside the 1-Core Website Control Panel you can find a fully–featured, convenient–to–use Database Manager! Utilize it in order to enjoy total command over all your databases. It’s possible to conveniently set up new MySQL and PgSQL databases and control them with the phpMyAdmin and phpPgAdmin software tools, respectively.
Neat and Simple User interface
Command all of your databases from within one place
The Database Manager inside the Website Control Panel contains a refined but simplified user interface. You are able to set up a new MySQL or PostgreSQL database by just entering a user name and security password. Also, you could make a backup file or alter the password of the database with only a click of the mouse.
Via the Database Manager you’ll get immediate access to the admin area for all of your databases, which means you can make quick changes should you need to.
Simple and easy Database Backup
Guard your database content with simply a click
In case you have worked with databases, you know generating a manual database back–up is not really an elementary task. In order to change this, we’ve developed a simple tool that will back up your whole database with merely a single mouse click. The backup file will be ready for you in under a minute, with respect to the size of the chosen database.
There are not any limitations on the actual number of copies you can create for a specific database.
PgSQL Support
By far the most secure open source databases
A majority of the Linux hosting service packages provide PgSQL support. While falling behind MySQL with regard to level of popularity and application, PgSQL databases are renowned for delivering the top level of security for your web site content material. It is the basic reason why companies such as Skype and Yahoo go with PgSQL databases in lieu of MySQL.
In relation to database management, PgSQL is just as uncomplicated as MySQL.
InnoDB Databases
The brand new face of MySQL
We have integrated InnoDB – the brand new default MySQL database engine on all our web servers. InnoDB is ideal for large database sites that require high levels of functionality and scalability. Trials demonstrate that websites applying InnoDB based tables reach a 3–fold general performance boost for huge joins, as compared with those employing MyISAM tables.
InnoDB utilizes row–level locking in order to be able to get rid of the efficiency issues detected at the top consumption times of the prior release of the database engine – MyISAM, which uses table–level locking.
Detailed Database Stats
Complete statistics for all of your databases
From the in depth database statistics tool integrated into the Website Control Panel, you’ll be able to keep a record of the load created by your active web sites 24 hour a day. Any overload difficulty with your websites can slow the loading rates and have a damaging impact on the overall experience of your website visitors. So, by having info about the database work immediately, it will be possible to solve overload issues straight away.
The database stats user interface reveals info of the amount of daily, hourly and monthly lookups, so its possible to evaluate the way the load is distributed over different periods of time.
