Databases Manager

Overseeing your databases is less complicated than ever before, due to the Web Site Control Panel interface for MySQL and PgSQL administration! Provided you do not have extensive experience in handling databases, you will find it effortless to deal with our Databases Manager.

You could make a completely new database merely by entering the user name and security password or produce a database back–up with simply a mouse click. Moreover, from the Data Manager you’ll possess direct access to the management area for each database, which enables you to effectively revise it.

Within the Databases Manager it is easy to make an archived duplicate of your database anytime you desire! Therefore, you are going to always have a back–up of your dynamic content in case your site gets compromised or you mistakenly remove a database. To create a backup: click the ’clock’ image on the side of any database and then simply wait for a couple of seconds for the process to be executed.

There are no restricts on the quantity of databases you can back up or the number of back–ups you can make for a database.

PgSQL databases are significantly less famous in comparison to the prevalent MySQL databases. Nevertheless, they’re a favorite choice for programmers who are looking for the greatest safety for their websites and applications. Because of the incredibly user–friendly Databases Manager built into the Tehnodar Control Panel, you can administer all your PostgreSQL databases with a mouse click.

Yow will discover PgSQL databases included automatically in the top cloud hosting packages. If you are using a regular hosting package, you are able to request PgSQL databases to be added to your account as upgrades.

The MySQL databases on Tehnodar’s servers work with the most recent build of the InnoDB storage engine. InnoDB is designed to ensure the highest possible effectiveness for websites that operate with significant volumes of data. It supplies CPU performance that can not be matched up by other disk–based relational database engines.

InnoDB is ACID–compliant and gives complete transaction support, which means that you are able to update/insert/create/alter/drop repeatedly for one "operation" of your web application. Additionally, it utilizes row–level locking as an alternative to MyISAM’s table–level locking, that improves multi–user concurrency and effectiveness.

From your broad database stats tool included in the Web Site Control Panel, you are going to be able to make a record of the load produced by your dynamic web sites 24 / 7. Virtually any overload problem with your websites can slow the loading rates and have a negative impact on the online experience of your site visitors. So, by having details about the database work live, it will be straightforward to solve overload troubles in a timely manner.

The database statistics user interface displays info of the volume of daily, hourly and monthly queries, to help you to examine the way the load is distributed over various time frames.