Databases Manager

Database management may seem like a difficult task to novice web hosting users, nevertheless with the Databases Manager, it’s actually pretty simple! To make a brand new database, you just need to type in the username and password. Database backup copies are simply a mouse click away too.People who choose to explore their databases and also revise them can use the phpMyAdmin and phpPgAdmin tools.

We have developed the manual database backup formation into a quite simple task. To execute that: inside the Databases Manager, click on the ’clock’ icon on the side of the database that you intend to back up and after that hang on for a few seconds for the process to take place. Depending on the size of your database, the building of a back–up file can take somewhere between a few seconds and a minute.

You may create as many backups of a database as you wish. We have not fixed any confines for the amount of databases that you can back up either.

PgSQL databases are much less widespread than the common MySQL databases. On the other hand, they are a favored selection for developers seeking the best security for their websites and applications. Through the easy–to–use Databases Manager incorporated into the TecIT Solutions Control Panel, you can administer all of your PostgreSQL databases with only a click of the mouse.

Yow will discover PgSQL databases integrated by default within the best Linux shared website hosting packages packages. In case you are using a regular hosting package, you are able to ask for PgSQL databases to be added to your hosting account as upgrades.

The MySQL databases on TecIT Solutions’s servers utilize the most up–to–date build of the InnoDB storage engine. InnoDB is intended to ensure the highest possible performance for sites that operate with significant amounts of data. It presents CPU effectiveness that can not be matched by alternative disk–based relational database engines.

InnoDB is ACID–compliant and grants total transaction support, meaning it is possible to update/insert/create/alter/drop repeatedly for one "operation" of your application. Also, it works by using row–level locking in lieu of MyISAM’s table–level locking, that improves multi–user concurrency and functionality.

Keeping tabs on the load accumulated by the databases on your powerful site makes it possible to reduce all overload troubles that might slow it down and chase away site visitors. For this reason, we have integrated a thorough Database Stats tool inside the Control Panel. There you can find comprehensive information about the inbound requests to your databases for every hour, day and month.

Using the number of daily and per hour queries, you’re going to be able to find out what databases are used the most and consider steps to optimize their load.