WEB HOSTING KNOWLEDGEBASE -  WEB HOSTING UK -  RESELLER HOSTING -  CPANEL LINUX HOSTING -  VPS HOSTING

Archive for MySQL Hosting

Load Balanced Web Servers and MySQL Servers

Q. Do You offer load balanced apache servers and mysql dedicated servers?

Ans : Yes. We offer load balanced apache servers (Web Servers) as well as MySQL servers. We are hosting a couple of biggest forums in the world which use multiple apache servers and high configurations quad core xeons for MySQL. Clustering of multiple MySQL servers is expensive but clustering of apache servers is quite simple and the only cost involved in it is for the dedicated servers. Basic dedicated server configurations are available at http://www.eukhost.com/dedicated-server-hosting.php but high configuration quad xeon servers can be setup as per requirement.

Please contact our sales department for custom quote.

Load Balanced Web Servers
For Load Balanced Web servers’ architecture, we will setup 2 or more similar configuration
Web Servers which will be behind the Load Balancer. Each Web Server will have a public IP assigned to it as well as a Internal LAN IP. We prefer LAN over VLAN as internal communication of the Web Servers and Database Server(s) can be completely isolated from external traffic. After the implementation of Load Balancing routing rules on the Load Balancer, we configure Firewall rules to allow web traffic on the Web servers to pass trough the Load Balancer. Our Office IP and Customers IP will be the only IPs to have remote access of all Servers. No other IP will be able to access any of the Web Servers or Database Server(s). Load Balancer will take care of equal distribution of traffic on each of the Web Servers and each of your web servers will then pass on SQL queries to the Database Server. Web Servers will allow only inbound connection on port 80, while SQL servers will allow only inbound connection on port 1433 if using MSSQL on the Database Servers or port 3306 if using MySQL on the Database Server. Database Servers will allow incoming SQL queries only from the LAN IP of the Web Servers. Inbuilt TCP / IP firewall settings of Linux 0S (Load Balancer) will be utilized for this setup and this will eliminate any requirement of additional Hardware Firewall. Firewall rules on the Web Servers and Database Servers will be configured using inbuilt IP security Firewall if Windows or TCP/IP based host access control policy if using Linux Servers. We have expertise in setup of such Load Balanced secure clusters and there’s absolutely no reason to be concerned about server security, Load Balanced routing rules or Firewall settings.

We also use some specific Load Balancers procured from Cisco and Juniper for such Load Balanced clusters. We prefer CSS 11000 (Cisco) & Juniper TX2200 for high-end clusters.

Drupal Web Hosting

Drupal Website Hosting

Drupal Web Hosting

Do you offer Drupal Hosting?

- Yes, Drupal is supported on all our web hosting packages. PHP and MySQL are the important requirements for  Drupal Hosting and they are available on all our web hosting plans. We would suggest a linux web hosting package for hosting a Drupal Website as PHP MySQL is the perfect combination on linux servers along with cPanel.

Drupal can be installed at a one click through Fantastico which makes it much easier. cPanel is the most easy to use control panel and allows you to manage database and other tasks of Drupal application.

Drupal Web Hosting

All our servers are Drupal-optimized and performance oriented. Our support team have expertise in managing Drupal websites and they are available 24×7 to provide technical assistance.

Drupal is one of the leading content management systems (CMS) around. Drupal is free and open source CMS written in PHP programming language. Power features and easy management tools of Drupal supports variety of websites. Small websites, blogs or major community websites can be published via Drupal. Drupal meets the website requirements of all small and big organisations. Drupal includes Community web portals,Social Networking sites,E-commerce applications ,Personal web sites or blogs and many such portals.

Drupal is easy to install and use where you won’t need to be expert in programming language. Search engine friendly URL’s, categories and search functions are some of the features on Drupal. Additonal  modules with Drupal adds more functionality to a website. Drupal installation can easily be converted to a forum, blog, wiki or any other website as per requirements.

All you need to do is open a Drupal web hosting account where you can easily have the Drupal application installed.

Mambo Web Hosting

Mambo CMS Hosting

Mambo Web Hosting

Do you offer Mambo Hosting?
Mambo website hosting is supoported on all our servers.

Mambo is most powerful content management system (CMS) around. With the help of web based interface along with user friendly features you can create simpler as well as more complex corporate websites. Mambo is PHP MySQL based so Linux web hosting as well as  windows web hosting package will suited for Mambo website.

eUKhost is most trusted company in UK for Mambo Hosting due to the high level security on our servers. We have enabled mod_security rules on our servers which filters intrusions, hacking attempts   and other invalid arguments passed by the intruders.

Mambo is easy to install on a website. If you have cPanel hosting package , you can install Mambo CMS at a one click through Fantastico.

Mambo Web Hosting

All you need to do is select appropriate domain name and proceed with Mambo installation.

Mambo is easy to use or manage and website can be customized from easy to use administrative panel. You won’t need to be an IT expert as it is suited for newbies as well as advanced users.You can have a look at Mambo tutorial to learn about its functionality and design. Default theme of Mambo can be changed anytime and and can be customized as per your requirements.You can change it to a custom Mambo template which can be used for a website.

Mambo functionality can be further extended by adding extra tools for your website. It will help you to create more advanced websites like ecommerce website, forums, gallery etc. Mambo is an excellent website building tool through which you can create personal as well as business website.

Backup Database from PHPMyAdmin

How to Backup Database from PHPMyAdmin

PhpMyAdmin

You are able to backup databases in a variety of ways, one of which is via the Backup Facility with cPanel but there are other alternatives to Backup MySQL databases without the need of that facility on its own. You can backup via phpMyAdmin in the Export section of the facility. Just like the backup facility in cPanel, it can give backups to you as a .tar.gz format which means you’ll be able to restore it via the cPanel facility if you need to do so.
• Once you’ve accessed the phpMyAdmin facility go into the database (empty or otherwise) and from the top menu click Export.
• Scroll down on that page until you get to a ‘Save as file’ option and select ‘gzipped’ and leave the settings as default.
• Click ‘Go’

To restore via the phpMyAdmin facility unfortunately you’ll already need the database setup to restore the inner contents, such as the tables, etc. So create a new database (name it the same as the database name that you backed up previously). Once you’ve created the database and you’re inside it, from the top menu again click Import.
• Simply select ‘Browse’ and find the relevant gzipped file, and leave all settings as default.

If all goes well you should see the contents of the database all there. Remember just like the cPanel backup facility, if you use usernames for each database you’ll need to set that up individually, for instance if you restored the backup via the cPanel facility. Make sure you re-connect the username and database together.

Access to MySQLDump and MySQL?

Q. Is access to the MySQLDump and MySQL utilities available?

Ans. We offer PHPMyAdmin utility which allows you to dump and restore your MySQL database from your end. cPanel Hosting customers can access PHPMyAdmin from the MySQL section of their control panel, whereas Windows Hosting Packages customers can access PHPMyAdmin from http://www.domain.com/webdataadmin/

You can also enable remote access for your database from your control panel to connect using dreamweaver, MySQLYog, or other MySQL interfaces. There are many other tools available for authenticated MySQL remote access which can be used from your end.

MySQL version?

Q. What version of MySQL are you currently running?

Ans. We are running the latest stable build of MySQL (MySQL 5.x). Generally we do not include the version information on the FAQs as MySQL service commonly undergoes upgrades at regular intervals.

PhpMyAdmin Hosting

Q. Do you provide PhpMyAdmin support on your web hosting plans?

Ans. phpMyAdmin is a web-based database management user interface ideal for managing MySQL databases and firmly integrated within the client’s control panel. All eUKhost web hosting packages includes unlimited number of MySQL databases. These can be easily managed directly on the server, using the web-based phpMyAdmin tool offered. phpMyAdmin is accessible right from your control panel under the MySQL section. Once in, select the database you would like to modify.

phpMyAdmin Mysql

phpMyAdmin comes standard with any MySQL hosting. Currently it can:

* create and drop databases
* create, copy, drop and alter tables
* delete, edit and add fields
* execute any SQL-statement, even batch-queries
* manage keys on fields
* load text files into tables
* create and read dumps of tables
* export data to CSV values
* administer multiple servers and single databases

eUKhost’s PHP/MySQL hosting accounts include:

* Powerful Redundant servers.
* 24/7 Technical Support to assist you.
* Unlimited MySQL databases.
* PhpMyAdmin to administer MySQL databases.
* 99.96% uptime guarantee.
* 30 day money back guarantee.

eUKhost is happy to offer you this powerful and at the same time easy-to-use tool for your effective work with MySQL web hosting.

In case of any assistance with PhpMyAdmin, you can also refer to PhpMyAdmin Tutorial

Which version of PHP and MySQL do your VPS use?

Q. PHP/MySQL version used on VPS Hosting?

Ans. We can setup any version of PHP and MySQL for you on your VPS, Semi Dedicated Server and Dedicated Server. Although the recommend versions are the latest versions which are MySQL 5.x and PHP 5.x if you wish to order a new Virtual Private Server. The versions of PHP and MySQL on our servers are updated/upgraded when there are any stable versions available to ensure hassle-free development and security.

Moving Access database to MySQL?

Q. Can you help me to move MyAccess database to MySQL?

Ans. We can offer you all the help that you need to move from Microsoft Access to MySQL. We provide an easy to use tool to move data back and forth between Access and MySQL. We also have instructions on how to switch your website to the MySQL database.

PHP/MySQL and Private Nameservers

Q. Which version of PHP and MySQL is installed on your servers. Will I get Private Nameservers?

Ans. We have latest version of PHP 5.x with MySQL 5.0.51 installed on our shared cPanel Hosting servers. We provide cPanel control panel on Linux cPanel Hosting and DotNetPanel control panel on Windows Web Hosting. We have highly reliable and stable Linux cPanel servers, as well as Windows DotNetPanel servers. We offer 24×7 uninterrupted Email, Live Chat and Toll-Free Phone Support. We offer private nameservers on Reseller Hosting , VPS Hosting and Dedicated Servers only. Private Nameservers are included on the Linux Reseller as well as Windows Reseller Hosting plans. Private Nameservers are feature is not available with shared cPanel Hosting and DotNetPanel Windows hosting plans, all other plans come with private nameservers feature.

PHP & MySQL version can be customized as per your requirement on VPS Hosting or Dedicated Servers. If you wish to use an older version of PHP or MySQL and not the latest one, you can contact our support team and request them to setup / move your account on a server which has the php or mysql version of your choice. We have multiple shared cPanel Hosting and DotNetPanel Windows Servers with different versions of PHP and MySQL on those. Additional PHP modules and components can be added to your web server as and when needed.

« Previous entries