Welcome to www.tetheredmommy.com

Web Hosting - Databases, What Are They and Do You Need One? 'Database' is one of the most commonly used terms that one encounters in web site design. Yet, what they really are and whether they're essential is often not clear to novices. A database is a collection of organized data, stored in files that have a specific structure. It's that organization and structure that allows for easy and rapid storage and retrieval. The need for a database generally only arises when you have a certain amount of information and that information needs to have some structure. If you have a half-dozen names and addresses to store, a database is usually overkill. If you have a blob of data with no relationships between any of the items in that blob, maintaining a database is usually more trouble than it's worth. Maintain a database? Yes, like other complex systems a database, to be effective, needs to be designed properly at the outset then kept 'tuned' for good performance. The alternative is to gradually allow the database to become more and more disorganized. That leads to difficulty in use, poor speed of retrieval and more frequent failures. With MySQL, Access or MS SQL Server, the three most common choices of database product for web sites today, setting up a database is relatively simple. Even those with limited technical skill can get one up and running just by following some simple instructions. But some thought should be given to how you want the information organized, and to maintaining the system during its lifetime. Suppose you have a set of names, addresses, email addresses, products purchased, date purchased and amount. If you have only a few dozen records it matters very little how these pieces are arranged and related. A database usually isn't even warranted in this scenario. Once you have several thousand or more records, it matters a lot. Speed, the ease of expanding the set of attributes (like adding, say, product category), and other issues come into play. Even those with little technical expertise, but a willingness to exert logical thought and invest some time, can build a very robust database. Think about how you would organize a set of data (called 'tables'). Should Name, Address, and Product be in the same table? Or should the personal information be stored in one table and any product information (product, price, ...) in another? Some experimentation may be needed to get it right, but the choices have an impact on how easy the tables are to maintain. It also affects the speed with which programs can fetch old data and store the new. Having a database also introduces new maintenance issues for the server administrator, since backups usually need to be done differently. Recovering a failed database is usually more complicated than simply re-copying files from yesterday. Ask your hosting company what tools and skills they have for dealing with any database system you consider. It's true that introducing a database creates more complexity and the need for additional thought and administrative effort. At a certain level, professional expertise will be needed. But clearly the advantages outweigh the costs in many cases. Companies large and small eventually use databases to store and organize data. At some point, you may be fortunate enough to be one of them.

Web Hosting - Why Backups Are Essential One thing most web site owners have little time for is... anything! Anything other than focusing on their site content and the business or service it supports and the information it provides, that is. That means that administration often suffers, as it frequently must. There's only so much time in the day. But the one thing that you should never let slide are backups. They are like insurance. You rarely need it (you hope), but when you do you need it very badly. Performing regular backups - and testing them - doesn't have to be a nightmare. A little bit of forethought and effort and they can be automated to a high degree. And, they should be tested from time to time. Even when a backup appears to have gone without a hitch, the only way to know whether it's of any value is to attempt to restore the information. If it can't be restored, the backup is worthless. Even when the web hosting company provides the service, there is still some planning involved for the site owner. Hosting companies often rely on one or both of two methods. They backup everything (called a full backup), then backup anything which has changed since the last full backup (called an incremental backup). Of special interest are any configuration files that have been tailored. If you've modified the default installation of a software package, you want to be able to recapture or reproduce those changes without starting from scratch. Network configuration files, modifications to basic HTML files, CSS style sheets and others fall into the same category. If you have XML files, databases, spreadsheets or other files that carry product or subscriber information - about items purchased, for example, or people who signed up for a newsletter - those should get special attention, too. That's the lifeblood of your business or service. Lose them and you must start over. That can break your site permanently. It should go without saying that all HTML and related web site files that comprise visible pages should be backed up regularly. It isn't necessary to record every trivial change, but you can tailor backup software to exclude files or folders. Usually they're so small it isn't worth the trouble. But in some cases those small changes can add up in scenarios where there are many thousands of them. Here again, the backups are worthless if they can't be used. Even if the hosting company charges for doing so, it's worthwhile to test once or twice a year at least to ensure the data can be restored. That's especially true of database backups, which often involve special software and routines. Database files have a special structure and the information is related in certain ways that require backups be done differently. Developing a backup strategy can be straightforward. Start simply and review your plan from time to time, modifying it as your site changes and grows. But don't neglect the subject entirely. The day will come when a hard drive fails, or you get hacked or attacked by a virus, or you accidentally delete something important. When that day comes, the few minutes or hours you spent developing and executing a backup plan will have saved you days or weeks of effort.

Web Hosting - Free vs Paid Web Hosting Options Everyone likes to get something for free. But as the existence of spam shows, free isn't always good. Sometimes, it's downright harmful. Deciding whether it's worth the cost to pay for hosting involves a number of complex considerations. Hosting companies that offer free services obviously can't stay in business from the money they make from you, since there isn't any. So why do they offer free hosting and how do they make money? Why should you care, so long as you get yours? Because, in reality, there's a price of some kind for everything, even something that's free. Free hosting may come from a company doing a promotion to attract business. They expect to demonstrate their value, then charge an existing customer base fees to make up for what they lost by the (short term) offer. It's in essence a form of advertising. But free hosting is offered by lots of companies that are not dedicated to managing servers for websites. Google, Yahoo and thousands of others provide a modest amount of disk space and a domain name on a server for free. Users are free to do anything they like with it, though if the load becomes excessive you can be shut down. That introduces one of the more obvious drawbacks to free hosting: resource limitations. Typically free hosting offers a relatively small amount of space. That's often enough to host a few dozen pages. But an active site can quickly run out of room. A more serious limitation is load. Free hosting often places strict limitations on the allowed amount of bandwidth consumed. If you become a well-visited site, when users start banging away on the server, you can be asked to leave or simply be blocked for the rest of the month. Or, you may be permitted a certain quantity of total bandwidth use per month. Once it's reached, no one else can reach your site until the beginning of a new month. At the same time, you will certainly be sharing equipment with thousands of other sites. Their load can affect your performance, prompting you to move. Migrating an established site brings with it a number of thorny issues that might be better avoided in the first place. Free hosting has another potential downside: lack of support. When you pay for hosting you typically get, at least in theory, a certain level of support. Backups in case of disaster recovery from a hack or server failure, assistance in analyzing connection problems... the variety is endless. With free hosting you usually get none of that. A company or site that offers free hosting will usually recover a disk or server that fails completely and you'll be back up when they do. But if only selected portions of the drive fail, or you lose a few files through a virus attack or accidental deletion, you have to rely on backups to recover. A free service will usually come with no such option. That may not be a problem if you have a small site. You can make copies of everything at another location and simply recover the site yourself - if you have the discipline to keep it current and the skills to make and restore the copy. Free hosting will typically come with a few email addresses, intended to be used for administration and other tasks. But if your needs grow beyond that, you'll need to seek another option. The email service also comes with minimal oversight. The server may be protected against spam attacks and provide virus scanning. But few free services will provide even minimal help with any issues that arise. But the most serious limitation may have nothing to do with any technical issues. Free hosting services often require that your site's pages carry some form of advertising that pays the host, not you. That may be fine for you, or it may not. Individual circumstances vary. On the other hand, if you're just starting out, a free hosting option can be a great way to learn needed skills and a few of the potential pitfalls. You can set up a site, learn how to maintain and improve it, and not care too much if it gets hacked. Freely hosted sites can be a great platform for learning the ropes. Free services don't usually offer any of the features that an active, commercial site will need sooner or later. So if you plan to grow, it may be reasonable to get the free service for a while, knowing you'll have to migrate when you become popular. But in the long run, you get what you pay for and you may need to pay for what you want.