Within the Matrix Hosting Online Control Panel you can find a full featured, user–friendly Databases Manager! Utilize it in order to enjoy complete command over your databases. It is easy to easily set up new MySQL and PgSQL databases and supervise them via the phpMyAdmin and phpPgAdmin software programs, respectively.
Clean and Very easy User interface
Handle all your databases from a single location
The Databases Manager in our Online Control Panel contains an effective yet simplified interface. You can configure a new MySQL or PostgreSQL database by just specifying a username and security password. In addition, you may create a back–up file or customize the password of your database with a mouse click.
Via the Databases Manager you will get immediate access to the management area for every one of your databases, allowing you to make simple corrections in the event you need to.
Simple Database Back up
Back up your databases in a moment
We have changed the manual database backup generation into a simple task. To execute that: inside the Databases Manager, click on the ’clock’ icon near the database that you plan to back up and wait for a couple of seconds for the process to take place. Depending on the size of your database, the building of any back–up file is going to take somewhere between a couple of seconds and a minute.
You may create as many backup copies of a database as you desire. We haven’t determined any confines about the amount of databases that you could back up as well.
Support for PgSQL
Warranted security for one’s databases
PgSQL databases are less widespread compared to the prevalent MySQL databases. Nevertheless, they’re a favorite choice for programmers seeking the greatest security for their web sites and applications. Thanks to the intuitive Databases Manager incorporated into the Matrix Hosting Control Panel, you can control your PostgreSQL databases with only a mouse click.
You will find PgSQL databases incorporated by default inside the best web hosting plans packages. Assuming that you are using a basic hosting package, you can easily request PgSQL databases to be added to your account as upgrades.
InnoDB Databases
The newest face of MySQL
We have installed InnoDB – the new default MySQL database engine on every one of our servers. InnoDB is great for big database websites which require high general performance and scalability. Tests show that web sites working with InnoDB based tables reach a 3–fold overall performance boost for very big joins, as compared with those utilizing MyISAM tables.
InnoDB utilizes row–level locking in an effort to clear away the operation issues discovered at the high usage times of the previous variant of the database engine – MyISAM, which utilizes table–level locking.
Detailed Database Stats
Complete statistics for your databases
We offer you an effortless approach to keep tabs on the database utilization of your powerful sites. Through the in depth database statistics user interface, which is built into the Online Control Panel, you are able to monitor the load created from your active web sites in real time. The supplied info will assist you to evaluate the database load fluctuations per hour, each day or monthly.
You can observe the database load for all of your sites within the Database Stats part of the Online Control Panel. The table on–screen features the database queries generated in the present month. To check details for an earlier month, all you have to do is click on the back arrows positioned at the top.