We present you with a convenient Databases Manager, bundled with our Web Site Control Panel, from where you can generate brand–new MySQL and PgSQL databases right away. Also, you are able to be in charge of all their settings via the easy access presented to the phpMyAdmin and phpPgAdmin software instruments.
A Well designed Interface
Manage your databases with simply a click
Overseeing your databases now is easier than before, as a result of Web Site Control Panel interface for MySQL and PgSQL management! Even if you do not have substantial expertise in utilizing databases, it will be an easy task to handle JTJ Data Service’s Databases Manager.
You may create a new database simply by entering the user name and password or produce a database backup with just a click of the mouse. Moreover, from the Data Manager you have direct access to the administration area for each database, so you’re able to effectively revise it.
Quick Database Backup
Back up your databases in a minute
We have made the manual database backup creation into a very easy job. To execute this: in the Databases Manager, click on the ’clock’ image near the database that you plan to back up and wait for a couple of seconds for the backup process to take place. Depending upon the size of your database, the generation of a backup file will need somewhere between a few seconds and a minute.
You can make as many back–ups of a database as you want. We have not set any confines on the volume of databases that you could back up too.
Just about the most risk–free open source databases
Just about all of JTJ Data Service’s Linux shared hosting plans offer PgSQL support. Whilst dropping behind MySQL when it comes to reputation and utilization, PgSQL databases are famous for presenting the maximum level of safety for your web site content. This is the primary reason why companies like Skype and Yahoo go with PgSQL databases instead of MySQL.
In relation to database administration, PgSQL is as quick as MySQL.
The brand new face of MySQL
We have installed InnoDB – the brand new standard MySQL database engine on every one of our web servers. InnoDB is perfect for sizeable database web sites that need high performance and scalability. Experiments show that web sites applying InnoDB based tables reach a 3–fold overall performance boost for very large joins, as compared to those working with MyISAM tables.
InnoDB works by using row–level locking in order to be able to remove the operation issues observed at the maximum consumption times of the prior variant of the database engine – MyISAM, which utilizes table–level locking.
Detailed Database Stats
Precise stats for all your databases
Tracking the load caused by the databases within your active site makes it possible to prevent any overload troubles that can slow it down and chase away website visitors. For this purpose, we have integrated a comprehensive Database Stats tool in the Web Site Control Panel. There you can get detailed information regarding the arriving requests to your databases for each hour, day and month.
In line with the volume of daily and per hour queries, you are able to find out what databases are used the most as well as consider measures to enhance their work.