Database Manager

Database management may appear like a difficult task to unskilled cloud hosting users, nevertheless with BMtec’s Database Manager, it’s actually reasonably easy! To set up a new database, you simply have to type in your username and password. Database backups are just a click away as well.People that choose to explore their databases and then modify them can make use of the phpMyAdmin and phpPgAdmin tools.

Via the Database Manager it is easy to create an archived duplicate of your database anytime you want! For this reason, you will always have a backup of your operating information in case your website gets hacked or if you erroneously eliminate a database. To produce a back–up: click the ’clock’ image next to a particular database and after that just wait for a few seconds for the backup process to be completed.

There are not any limits for the number of databases you are able to back up or the number of back–ups you may make for a database.

Nearly all of our Linux web hosting plans present PgSQL support. Whilst dropping behind MySQL with regard to global recognition and utilization, PgSQL databases are famous for offering up the top level of stability for your website content. That’s the primary reason why brands like Skype and Yahoo use PgSQL databases as opposed to MySQL.

In terms of database management, PgSQL is equally quick as MySQL.

The MySQL databases on BMtec’s servers use the most current version of the InnoDB storage engine. InnoDB was created to guarantee the maximum functionality for web sites that operate with substantial volumes of data. It provides CPU performance that could not be matched up by alternative disk–based relational database engines.

InnoDB is ACID–compliant and gives total transaction support, so that you’ll be able to update/insert/create/alter/drop a couple of times for one "operation" of your web application. Also, it utilizes row–level locking as an alternative for MyISAM’s table–level locking, that raises multi–user concurrency and performance.

Via the all–encompassing database stats tool integrated into the Web Site Control Panel, it will be possible to keep track of the load accumulated by your dynamic websites at any hour. Any overload difficulty with your sites can slow the loading rates and have a bad impact on the online experience of your respective visitors. Therefore, having details for the database load immediately, it will be possible to mend overload issues straight away.

The database stats interface shows information of the number of daily, hourly and monthly queries, so you’re able to assess how the load is spread over different time frames.