Database Manager

Managing your databases is easier than ever, because of the Online Control Panel interface for MySQL and PgSQL administration! Even if you do not have detailed knowledge in utilizing databases, you will find it easy to handle the Database Manager.

You can create a new database by just specifying the username and password or create a database back–up with merely a click of the mouse. Also, with the Data Manager you will get direct access to the administrator area for each individual database, which means you can conveniently alter it.

Within the Database Manager you can generate an archived backup of your database when you would like! Therefore, you will always have a back–up of your active information in the event your site gets hacked or you erroneously eliminate a database. To create a back–up: click the ’clock’ symbol beside a particular database and after that wait for a few seconds for the process to be finished.

There won’t be any restrictions on the volume of databases you would be able to back up or the quantity of backups you may make for any database.

You are going to find PgSQL support in every one of our Linux shared web hosting offers. PgSQL databases are not as sought after and widely used as MySQL, but they deliver the highest possible level of safety for your web site content. For this reason, many well–known brands like Skype and Yahoo employ PgSQL databases. Managing PgSQL databases is as simple and easy as MySQL, because of the incredibly user–friendly interface of the Database Manager.

PgSQL databases are integrated by default inside of the most advanced web hosting packages. For the basic plans, they’re offered as upgrades.

The MySQL databases on Teknai-IT’s machines use the most current release of the InnoDB storage engine. InnoDB was made to ensure the highest efficiency for sites that work with significant volumes of data. It delivers CPU effectiveness that could not be matched up by alternative disk–based relational database engines.

InnoDB is ACID–compliant and provides 100% transaction support, meaning it is possible to update/insert/create/alter/drop several times for one "operation" of your web app. In addition, it uses row–level locking in lieu of MyISAM’s table–level locking, that increases multi–user concurrency and efficiency.

We supply you a fairly easy technique to keep tabs on the database usage on your busy web sites. Through the in–depth database statistics interface, that is integrated into the Online Control Panel, you are able to keep an eye on the load made by your dynamic sites in real time. The offered information will assist you to analyze the database load fluctuations by the hour, on a daily basis or each month.

You are able to monitor the database load for all your websites within the Database Stats section of the Online Control Panel. The table onscreen presents the database queries made within the present month. To take a look at details for a past month, all you have to do is click on the back arrows situated at the top.