Category Archives: Email Hosting

When Do We Need MySQL Databases With Our Web Hosting?

Leave a reply

Whenever you buy web hosting, your hosting provider is sure to include an option called “Databases” in his price quotation or package details. But not many of us know what are databases and why we need them when setting up a website. This article aims to explain a couple of reasons why we use databases and when we need them for our website.

The database systems we usually get with our web hosting accounts are all relational database systems or RDBMS. If we take a Windows hosting server we usually get Microsoft SQL aka MSSQL and if we take a Unix based system we usually get MySQL. Both these systems put your website data into tabular layouts for fast and easy retrieval.

Databases are a collection of rows and columns, where each row or column is related to the others in some way. Due to this relation, information from this database can be retrieved quickly and efficiently as compared to if the data was stored in any other unstructured format. You can consider a database as a collection of multiple spreadsheets which are all related to each other in some way or the other.

Security

A major advantage of having your data stored in a database is the ability to protect the database from unauthorized access, or the ability to protect a database record from being tampered with. A simple example would be the storage of login credentials. In a simple way, login credentials can be stored in a simple text file and be read by your script which does the authentication. However, your file will always save the password stored in plan text, making it vulnerable to anyone who has access to it. Databases have the ability to encrypt the entries using a hashing algorithm to obscure them. Further, to read or write to the database, you need to specify login details, something which is not easily possible with an ordinary text file or spreadsheet.

Efficiency

Due to the manner in which data is stored in the database, retrieval and storage is most efficient. Unlike a spreadsheet, where anything and everything can be stored in any cell, SQL restricts the type of information stored in each row or column based on certain conditions. This validation is inherent in the properties of SQL and is an added advantage for a programmer or developer. Due to the various inbuilt mechanisms that are present in RDBMS systems, they are the most preferred method of storage and retrieval of data.

An article on the DatabaseJournal Blog explains this in a lucid way:

“…The problem with text files is during a read, if the text file is large, it can take quite a bite of time to open and scan the contents of the file looking for what we want. Also, if we wanted to see all the sales to a specific customer, the entire text file would have to be read, and every line occurrence of the customer name would need to be saved in some temporary place until we had them all. If we saved to a spreadsheet instead of a text file, we would have a Sort feature built in. So we may be able to find all the sales to a specific customer quicker, but again, if the file was large, opening the spreadsheet could take a great deal of time.”

Administrative Control

Database systems also have various control mechanisms which allow easy administration of the database and tables within it. The most important part is user management. Each user can be given specific rights to the database, thereby allowing limitation in access so as to secure the data from being tampered, modified or altered. Database Administrator’s can tweak many settings of the database thereby restricting the flow of data, the connection speeds, maximum number of connections to the server and even adjust what hardware resources should be allocated for performing a task.

Is FTP Better Than A Web Based File Manager For My Website?

Leave a reply

Is FTP Better Than A Web Based File Manager For My Website?

FTP accounts are given with all web hosting accounts, so that users can upload, download, transfer and modify files in their hosting account. But contemporary web hosting control panels like cPanel, Plesk, HSphere etc. also offer a web based file manager which works through the browser. The web based file manager does not need any additional software to be downloaded, but an FTP client is need for accessing the files through FTP. Then why use FTP rather than the file manager? We list a couple of points in favour of using FTP over your browser based file manager. This article advocates for the use of FTP over your web based file manager in certain circumstances.

Multiple Files

When transferring multiple files to or from your website, FTP is definitely your best bet. FTP clients allow multiple connections to the server, thereby allowing you to start multiple file transfers simultaneously. This can drastically increase your file transfer speed and same a lot of your time. This is especially useful when dealing with a large website with lots of files spread across a large number of files and folders. Web based file transfer interfaces usually do not allow multiple file handling and only allow you to transfer files one by one. This can be a headache and make it difficult to transfer many files quickly. FTP clients put files into a mail queue and allow you to set priority for file downloads. You can set a “Very High” priority on small files and set a “Low Priority” on Large files which will take time.

Bandwidth Throttling

FTP clients like FileZilla allow you to restrict the amount of bandwidth that the file transfers should take. This prevents donkey work like file transfer to take up a major chunk of your internet speed and allow you to use the network simultaneously for other important purposes. This can also be important if your ISP throttles your connection and gives you a slower speed at different times of the day. An online file manager rarely has such an option, especially because it is supposed to be rudimentary.

Automation

FTP clients allow you to automate many tasks. Some software allow you to batch edit documents in your account on the fly. Other FTP services allow you to perform certain functions or execute commands based on file downloads or uploads. For example some FTP clients allow you to shut down or restart the system when a file queue completes downloading. This can be especially useful for unattended systems where you have left the files to download over a long period of time and don’t want to monitor the progress. You can also open up programs or pass on information to software on your machine about the file downloads.

Secure Connections

FTP systems allow you to use an encrypted connection to transfer files. Using multiple methods of encryption, FTP allows more security than conventional browser based file managers, due to the multiple failure points in them. SFTP, FTPeS, FTP over SSH etc. are some common options that you can use when using FTP. These options need to be enabled by your FTP server in order to use them. Browser based file managers can also be accessed over a secure https connection, but the main cause for concern is browsers which are needed to access the files. An added security measure is that FTP clients can provide you a log of the files that were transferred so that you know exactly what is going on.

File Modification

FTP clients allow you to quickly change file permissions, file ownership, file locations and even allow you to edit files directly in the FTP client. This saves you time in uploading the file again. Some FTP clients also allow you to open a new connection in the same window so that you can copy or move files to and from each account. This can be especially useful when you are migrating a website from one server to another.

When in a hurry, you can always use a web file manager to make small changes or upload / download a couple of files. However, for mass file management, FTP clients become indispensable.

Tips To Prevent Failed Backups Of Your Website

Leave a reply
Tips To Prevent Failed Backups Of Your Website

Tips To Prevent Failed Backups Of Your Website

Most of us keep regular backups of all our important data, especially which is on the internet. Websites should also be backed up regularly as a safety measure in case of a disaster and also as a version tracking mechanism. This ensures that in the event of our website being hacked or becoming corrupt, we can quickly restore it to a prior version. Most of us have automatic mechanisms to take a backup. But little do we realise that taking a backup doesnt really end there. We need to ensure that it is a workable backup and not a dummy file which has not value. This article explains how we can prevent backup file failures and how to ensure that our website backup will be of use when we need it.

Elements

An important aspect of taking backups is not to forget any of the elements that make up your account. Your web hosting account has several elements which need to be backed up so that you can restore your entire account. This means that you need to backup things like Email, Website Files, Databases, Configuration Files, Web Statistics, Email Forwarders and any other customizations that you may have done with any of these elements. Hosting Control Panels like cPanel or Plesk may allow you to take backups of these elements separately or compile them into a single compressed file. Forgetting even one part of your account backup may render your website useless. Many people forget to take a backup of their database files since the backend is not something that the users interact with. Similarly, the small configuration files and customizations can also boost the speed and efficiency when you attempt to restore the backup.

Disk Space Shortage

The in-built backup options of your web hosting control panel will usually save your backup in the home directory of your account. This means that the backup will also consume hosting space within your account. If you are on a limited space plan, you should have atleast 50% free disk space before you backup your account. If you do not have enough space, the backup may not complete fully or may get corrupt. This can be disastrous when you are dependent on it and when you want to restore the account. Ensure that you have enough free space so that your backup is not stuck.

Failed Download

One of the most common failure points when taking a backup is the download to your local machine or onto the media you are ultimately backing up on. Very often, when the backup file is being downloaded on the media or machine, the network connection may drop or the process maybe terminated. This may indicate that the file has been downloaded, but actually the file is only partially downloaded. A client of ours who was switching from shared hosting to a dedicated server was taking a backup of his website on his own. He started downloading the backup file from his hosting account. The size of the backup file was about 600 MB. On his internet connection, it indicated that about 8 minutes were left for the download to complete. In between the download process, his internet connection dropped. He noticed that the file transfer had stopped and file was on his hard disk. However, he did not notice the file size and assumed that the entire 600 MB has been downloaded. The backup file was corrupt and had downloaded only 350 MB. Luckily he noticed the mistake and was able to retrieve the backup file. You may not always be so lucky.

Integrity Check with the Checksum

The best way to ensure your backup file’s integrity is using a checksum tool to verify the checksum of the file before and after it is downloaded. Ideally this means that you get a unique hash value of the file from the web server. This unique hash value is tied to the file and is almost impossible to reverse engineer. Then, after you have downloaded the file, retest for the checksum of the downloaded file on your backup media. The checksum of the file should be exactly the same. If the file is corrupt or tampered or has not downloaded properly, the checksum will mismatch and you will get to know easily. This ensures data integrity and provides assurance of a healthy backup file.

 

Buying Web Hosting Space From Your Web Designer? Watch Out

Leave a reply

We all love to shirk responsibility and hand over some of our problems for people who are willing to handle them. Buying the right type of web hosting maybe quite an overwhelming process for a not so tech savvy business owner. The task of how muck disk space, how much bandwidth and all the technical jargon involved can get quite taxing to understand. This is a primary reason why web designers are more than happy to bundle a web hosting account along with their designing fees. But there are many ways in which such relationships can get sour if the terms of the bundling are not made clear initially. This article explains what could go wrong if you buy web hosting space from your web designer rather than buying it independently.

Buying Web Hosting Space From Your Web Designer? Watch Out

Buying Web Hosting Space From Your Web Designer? Watch Out

Price

Although you may feel that you’ve got a great package deal on your web hosting along with design fees, you should be aware that web hosting fees are recurring fees and usually payable monthly or annually. Don’t get carried away with the waiver of fees for the first year. Some website owners are in for a rude shock when the next year on the renewal anniversary, they receive a huge invoice for renewal of the web hosting account. Design firms are almost always resellers or affiliates of web hosting companies and never a web host themselves. This can be a positive thing as well as a negative thing. Sometimes they may be able to offer you a highly competitive pricing, while some of them may just exploit your ignorance or inability.

Lock In

Taking a package from your website developers may lock you in to their web hosting package as well as their design. More than a physical barrier, it creates a sort of psychological block which prevents you from switching services or choosing a different design for your website. This is precisely the reason why low cost packages are offered and customers are lured to them. Website owners fear that if they shift the design services, then the developers may not be too cooperative and not give them control of the hosting account. Similarly, even if the hosting account has limited features or provides bad service, you may be willing to stick to it if it is bundled with your development package. You should always have control of your hosting account and also have your design source code with you.

Support

If your web designer is knowledgeable, well equipped and efficient, you may get good technical support. Issues related to your website’s hosting will be solved quickly. But if your designers are new to the hosting world, they may not be of much help. Sometimes it maybe helpful to buy the hosting and design from the same company, so that all your services are under one roof. This way there can be no blame game as to which service is deficient, in case of a failure. However, this can also be a disadvantage if you have hired a nascent design firm. They maybe too raw to know the intricacies of hosting and may not be able to keep up with changing technologies or may not be competent to provide the right security or optimization measures. This should not be expected from them either, as designing is their primary business and all other things are side businesses.

Control

If you are taking a package deal, make things clear at the beginning. What happens if you decide to hire the services of another designer? Who keeps the control of the website? On whose name is the domain name and hosting registered? How do you login to control your website files? These are some of the basic questions that you should ask when you are offered such a deal. You don’t want to end up having a disagreement with your web designer, who turns off your website and takes control of your domain name, leaving you high and dry.

Google Hates These Things You Do…

Leave a reply

There are a couple of things that Search Engines look at when ranking your website in search results, for various keywords. These include original content, number of links pointing from other website’s to yours, your overall online presence, the quantity of relevant content on your pages. People have tried long and hard to manipulate Google’s search algorithm by trial and error of various methods. The bottom line being that you just can’t fool Google. Although there maybe more than 2000 factors which determine how your site is ranked, there is a sure-shot list

Google Hates These Things You Do...

Google Hates These Things You Do…

of points which Google hates and will punish you if you do those things. This article aims to highlight some key points which you should definitely avoid if you want to be in Google’s good books.

Plagiarized Content

Google hates copy cats. The whole purpose of Google is defeated if it is not able to serve up fresh, genuine and relevant content for a user’s search query. When a person look for something using Google, he is dependent on Google to provide the most accurate websites which will provide the information sought. If Google does not catch the attention of the searcher, he will look for the information elsewhere and Google would have lost out on potential ad revenue in the process. Google says:

“Purely scraped content, even from high-quality sources, may not provide any added value to your users without additional useful services or content provided by your site; it may also constitute copyright infringement in some cases. It’s worthwhile to take the time to create original content that sets your site apart. This will keep your visitors coming back and will provide more useful results for users searching on Google.”

Dummy Websites

To get back links from external websites, webmasters buy many domain names and put up rudimentary content with a link back to the parent website which they want to boost in search results. Google calls these doorway pages and penalizes doorway sites themselves and also websites using doorway pages. Since these websites or pages are “typically large sets of poor-quality pages where each page is optimized for a specific keyword or phrase” they offer no value added benefit to Google users.

“Google frowns on practices that are designed to manipulate search engines and deceive users by directing them to sites other than the one they selected, and that provide content solely for the benefit of search engines. Google may take action on doorway sites and other sites making use of these deceptive practices, including removing these sites from Google’s index.”

People also use such dummy websites to automatically redirect visitors to the real website and mislead the user about where they are being taken. The dummy website will show up on Google Search Results, but the user is ultimately taken to the real website which has nothing to do with the search results.

Paid Links

Paid Links are basically links which are not earned due to quality, but are instead bought from websites which are willing to make a quick buck. This dilutes the quality of content for the search results and leads to irrelevant or misleading information. Google classifies buying or selling links that pass PageRank, excessive link exchanges, large-scale article marketing or guest posting campaigns with keyword-rich anchor text links and even using automated programs or services to create links to your site as Paid Links. These are all liable for being penalized and even removed from Google’s Search system.

Comment Spamming

Google’s Webmaster Support says that “If you’ve ever received a comment that looked like an advertisement or a random link to an unrelated site, then you’ve encountered comment spam.” Comment Spam is visible on many blogs, which have popular content. Spammers post a comment or remark about the article and surreptitiously insert a link with their own brand or promotion in it. Comments are usually in the form of random praise about the article or some obscure sentence related to the article content and sometimes is outright junk text. All these qualify for the penalty by Google.

Will Webmail Be The Future Of Email Storage?

Leave a reply
Will Webmail Be The Future Of Email Storage?

Will Webmail Be The Future Of Email Storage?

With email being a primary mode of formal and official communication around the world, an important question that should be asked is that how and where will users store their data. As data storage evolved and modes of storage cross conventional limitations, innovations in Information technology has taken thing to the next level. People have stopped using their desktops for storing their email and prefer to have webmail storage which allows them to access their mail from any location at any time without dependence on any hardware. This article discusses the factors which may influence a users decision in using webmail for storing email.

Mobile Devices

Mobile devices have a lesser capacity to store as compared to our desktops and laptops. Mobile devices are used more for storing entertainment material like movies, games and music rather than emails and office work. Hence, people using mobile devices are more likely to keep their emails on their mail server rather than downloading them

Cheap Disk Space

As hardware prices reduce, so does the price of disk space. Both physical hard disk drives and even virtual storage space costs lesser and lesser day by day. Due to economies of scale, online storage space works out far cheaper (per GB) as compared to a hard disk. This encourages email users to outsource their email storage to an online solution rather than to have the headache of managing and storing the emails on their local computer.

Cloud Storage

A major reason why people will not download mails on their phones or computers is because of lack of accessibility. We all want a single location for managing our mail and documents. Earlier people would use multiple devices to download their mail and were virtually locked in to that device to manage their emailing. This meant that any hardware failure would lead to work disruption. Similarly backups were also tougher to make on a specific device. Your entire online life depended on that one device. If you bought a new device or upgraded it, you would need to carefully migrate your data. Today’s world is platform independent. You are not locked in to one type of device or one specific device. With web mail and online storage you can access your mails from any device. Your mail client only becomes a viewing tool and not a storage tool. It doesnt matter how you access your mail when it is online. You can use a laptop, desktop, mobile phone or even a browser enabled device to see your mails.

Profile Personalization

Another important feature after storage is singularity of your customization and profile. Many of us have our email signature stored with our email clients. If we use our mobile phone, we have to reset our email signature. If we use a separate webmail client, we need to reconfigure our entire signature and email preferences all over again. With webmail, any device you are on will have the same settings as other devices which access your mail. You don’t need to bother about the consistency of your email preferences or personal customization to your profile or email interface as it is always consistent.