As a client hosted on our servers, you can choose between two database solutions – MySQL and PostgreSQL (not all hosting plans support PostgreSQL, though).

First, let’s consider the similarities.

Both databases are open-source, supported by contributors and developers on a voluntary basis and are offered free of charge. Both are relational database management systems (RDBMS), PostgreSQL being focused on the object-oriented database model.

MySQL gets the first open-source database market share spot, while PostgreSQL occupies the third position, lagging behind Microsoft SQL server, another free SQL developer.

MySQL is the most popular open-source database management systems, due to its ease of use and speed of performance. All the scripts offered by our 1-click Web Apps Installer tool are fully MySQL-compatible.

Also, MySQL is cross-platform, which means that you can design your database application on a Windows or Mac computer and then host it on our Linux OS server with the same success.

IT companies known to use MySQL include Yahoo!, Cisco, Sabre and Slashdot.

Here is why you would want to choose MySQL as your database solution:

• Broader support;
• Simpler database design will less coding;
• MySQL’s replication is much better than the one provided by PostgreSQL and there’s only one way to do it, while PostgreSQL has lots of different replication; systems, thus unnecessarily complicating the process;
• You can easily create basic web-driven websites;
• MySQL is faster than PostgreSQL;
• Data Integrity – PostgreSQL is at a disadvantage because it wants your data to be correct by enforcing constraints. MySQL has limited referential constraints;

PostgreSQL is also a cross-platform database.

It is the choice of developers who want more flexibility and features, currently not supported by MySQL, like async notifications, OO (Inheritance of tables), transactional DDL statements, triggers (supported by MySQL 5.x), foreign keys (supported by MySQL 5.x) and full implementation of sequences.

Additionally, if you are planning a migration from Oracle, DB2 or MSSQL, PostgreSQL follows many of the SQL ANSI standards, thus allowing the creation of complex SQL commands, available with the proprietary database solutions.

To summarize, the need for the following components should draw your attention to PostgreSQL:

• Complex rule sets (business rules, for example)
• Use of procedural languages on the server
• Complex database design
• Use of geographical data

More specific comparative tables are provided at the following addresses for further reference:

http://www.postgresonline.com/journal/index.php?/archives/51-Cross-Compare-of-SQL-Server,-MySQL,-and-PostgreSQL.html#extended

Go to the Statistics > Traffic Stats section of your Control Panel to view detailed visitor statistics for each of your domains and subdomains.

The statistics for the www and non-www version of your site are gathered “under one roof” and are stored in the ‘non-www’ hostname.

This allows for the server to process data faster than splitting it in two.

In case you need an alternative, there are public services such as Google Analytics. More information could be found at:

http://www.google.com/analytics/

Of course, you need to have associated accounts with the respective vendor systems in order to gain access to these services.

Another alternative is Piwik. Installing it is easy and does not require much effort: http://piwik.org/docs/installation/

You can check the vendor FAQ as well: http://piwik.org/docs/installation/

First, make sure that you know where exactly the files for your website are located. Usually each domain/subdomain points to a folder with the same name as the domain/subdomain located inside the /www/ directory in your hosting account.

So, if you want to back up the files for my-best-domain.com, they are most likely located in /www/my-best-domain.com/

Here is how you can back up your files:

Option 1: Go to Files > File Manager.
Select the folder(s) and/or the file(s) that you want to download and click on the Download button (), which is located at the top of the files list or click right button of the mouse to open the drop-down menu. Choose an option and  within a few seconds a windwow appears and asks you if you wish to save the file.

Choose “Save As…” and point the location on your computer where the file should be saved.
You get an archive, which contains all the file(s) and/or folder(s) that you have selected.

Option 2: You can back up your files via FTP. To do this, connect via FTP, using your main FTP account. Once the connection is established, you will see a list of all the domain folders.
Right click on the desired folder, then choose Download*. Your files will start downloading on your computer.

* The exact download process may vary depending on the FTP client that you use. For further information, please refer to: How to connect via FTP and upload/download files?

Option 3: In case you would like to create a .zip archive of your files, but instead of downloading it locally to your computer, you want to keep it on the server, here is what needs to be done:

1. Go to the File Manager section and access the folder where the files are located. Via the “Create New File/Folder” options at the top, create a folder called “BACKUP“.
2. Use the “Select all” option, then leave ONLY the folder “BACKUP” unchecked. Copy the files to the newly created folder “BACKUP“.
3. Create a file called zip.php into the same directory where the folder “BACKUP” is located and include the code:
   
   <?php exec(“zip -r BACKUP BACKUP”); ?>
4. Open http://my-best-domain.com/zip.php * in a browser and the script will create an archive of the “BACKUP” folder.

*IMPORTANT: The exact URL of the script depends on the domain and the folder where the files are located. What is important is that you run the script by accessing it through the web.
If you go back to the File Manager section, in the folder where you created the zip.php file, you will find a file called BACKUP.zip – this is in fact the archive with your files” backup.

An Internet Protocol (IP) address is a numerical label that is assigned to devices participating in a computer network. An IP address serves two principal functions in networking: host or network interface identification and location addressing.

The role of the IP address has also been characterized as follows: “A name indicates what we seek. An address indicates where it is.”

By default, your hosting account and all the websites you have with us use the shared IP address of the server – meaning that many websites on the same server reside under the same IP address.

You have the option to use a dedicated IP address and your domain or subdomain will be the only one corresponding to this IP address.

In other words, the dedicated IP address will be reserved just for you not only on our server and network but worldwide on the Internet.

One of the main uses of dedicated IP addresses concerns the installation of SSL certificates that are required for secure pages.

If you want to have a form on the website that will collect sensitive information, for example, for payments or client accounts, it is advised to have that page secured in order to protect the personal or financial information of your visitors and clients.

Another purpose of using a dedicated IP address is if you need to open your website using the IP address as a URL instead of using the domain or subdomain it is hosted under.

For more information on how to purchase, request and assign a dedicated IP address, please refer to the article How do I get a dedicated IP for my domain/subdomain?

To edit a custom A record, go to My Domains > DNS Records section.

Find the domain/subdomain in the list below and click on it.

Replace the current IP address with the new IP (A record) and click the “Modify” button.

To add a TXT record, go to My Domains > DNS Records and click on the “Add А New Record” button, then select the desired domain from the “Hostname” drop-down menu. If the record will be added for a domain, leave the field before the drop-down menu empty. If it is for a subdomain, type in the subdomain name.

Example: to add a TXT record for my-best-domain.com – just select it from the “Hostnames” menu.
To add a TXT record for webmail.my-best-domain.com – type “webmail” and select “my-best-domain.com” from the menu.
Select “TXT” type of the record from the ‘Type’ menu, then type its value in the ‘Value’ field below.

Example: for TXT the value should look like: v=spf1 mx -all

Optionally you can adjust the TTL settings. Click on the “Add a New Record” button to add your new TXT record.

To order an ID protection service to a domain or group of domains, please follow the steps:

1. Go to My Domains > Whois Privacy Protection section. In the “Domain” column, select the ones which you need to protect, and mark their checkboxes. Click on the Whois Privacy Protection icon.
2. In the “Order Whois Privacy Protection” page you need to choose a payment method. When ready press the “Continue” button.
3. Ones the payment is completed the domain’s WHOIS Data shield will be activated.

Note: If you want to add Whois protection service only to a single domain name you can also click on its corresponding “Order Whois Privacy Protection” icon.

You can host multiple* domain names in a single hosting account with us. The first domain name that will be hosted in your account is specified during the signup procedure. In order to properly host additional domain names, go to My Domains > Hosted Domains section, click the “Host Domain” button and follow the steps:

1. Make sure the option “Host Domain” is selected.
2. Type in your domain name, e.g. my-best-domain.com

*The domain name must be registered and the name servers must be changed with the ones specified in the Hosted Domains section.

Note: the “Don’t manage DNS” option has to be selected ONLY if you wish to use third party name servers for your domain name and just point it to this account using A record redirection. Otherwise leave that box unchecked and set our Name Servers (NS) for your domain.

Each domain name servers are managed from its Registrar – the company, where you have bought the domain from. If your domain name has been registered from this hosting account, its name servers could be managed from My Domains > Registered Domains.

3. Advanced Settings – this section is optional. Please leave the default settings if you are not sure what to do.

4. Click „Add a Host“ to host your domain in your hosting account.

Once you add the domain name, a red icon will be displayed under the NS column. Once the name server changes propagate (this may require up to 24 hours), the DNS status will be updated as well. More information on that matter is available in the article: Why is there a red icon sign (DNS error) for my domain’s name servers?

* Please have in mind that in order to host additional domain names, you must make sure that your hosting plan can support it. For that you should refer to the Account Usage table available on the left side of the Web Hosting Control Panel.

There you can see the number of domain names that you are currently hosting and the number of the domain names that you can add. If the available amount is zero, you must upgrade your account in order to host more domain names. You can find more information in the article How do I upgrade my hosting account?

Subdomains are basically separate hostnames that are part of a larger domain.

 For instance, “example1.my-best-domain.com” and “example2.my-best-domain.com” are subdomains to the larger domain “my-best-domain.com“.

You can have a further subdivision – “english.example1.my-best-domain.com” and “spanish.example1.my-best-domain.com” are subdomains to “example1.my-best-domain.com“.

In theory, this subdivision can go down to 127 levels deep, and each one can contain up to 63 characters, as long as the whole domain name does not exceed a total length of 255 characters. In practice, some domain registries have shorter length limits than that.

Subdomains are commonly used to assign a unique name to a particular department, function, or service related to the main site or organization. For example, the forum on a given website can have its separate subdomain – forum.my-best-domain.com.

From the Hosted Domains area of the Control Panel, you can create a subdomain for a domain name that is already hosted in your account. 

Here are the steps to follow:

1. Click on the “Create a Subdomain” button on the top right and make sure the option “Create a Subdomain” is selected.
2. To create the subdomain webmail.my-best-domain.com, type in “webmail” and select “my-best-domain.com” from the the drop-down menu, containing all hosted domains.
3. Advanced Settings – this section is optional. Please leave the default settings if you are not sure what to do. (Read further below to learn more about the Advanced settings)
4. Click “Add a Host” to create the subdomain. The new host will need about 10 minutes to start working.

Here is what the Advanced settings are about:

Path: this field enables you to choose the folder that the subdomain will point to. By default that is: /www/subdomain/. For instance, the default path to example1.my-best-domain.com is /www/example1.my-best-domain.com/. 

IP Address: here you have a dropdown menu that enables you to select the shared IP address of your account or assign a dedicated IP address for that particular subdomain. For more information on dedicated IP addresses, please refer to the respective articles in this knowledge base.

After that you have the option to specify a custom error page for errors 400/401/403/404. You can also use the system (Apache) page or the default error pages.

Secure Socket Layer (SSL): this option enables you to use secure pages on this subdomain. For more information on SSL, please refer to the respective articles in this knowledge base.

ModSecurity: the ModSecurity firewall option allows you to protect your subdomain-installed applications from most common hacker attacks; 

Further below you have the option to Activate Access & Error Logs. The Access Logs show you when the subdomain was accessed and by what IP address. The Error Logs show when and what errors occured on the subdomain.

You can see all subdomains in your account listed in the table of hosted domains.

In this table, you can find the following information per subdomain: the current name server status, the number of pertaining mailboxes, an indicator if an SSL certificate is installed, an indicator if DNSSEC is enabled, a button that will open the folder that this subdomain is pointed to, a button to check the traffic stats for this subdomain, a button to edit this subdomain and finally a button to delete this subdomain.

IMPORTANT: The “www” subdomain is the default subdomain of your domain. You cannot delete the “www” subdomain. Instead, you can simply delete the domain name from the Hosted Domains section of the Control Panel. Editing the “www” subdomain also updates the domain name itself. In other words, if you want to edit the domain name my-best-domain.com, then simply edit the www.my-best-domain.com subdomain.

There are 3 ways to access the traffics stats for a domain name:

1. Click on the “Traffic Usage Statistics” icon in the “Actions” column;

2. Right-click on the domain’s name, located in the “Domain” column. This will open a context menu, from where you can select “Traffic Usage Statistics”;

3. Click on the domain’s name, located in the “Domain” column. This will open the “Domain Information” pop up window with information for the domain name and several quick access icons. Locate the “Traffic” icon and click on it.