Check out replication... this will accomplish what you need on the database side. Potentially clustering can help as well if this is a heavy load project in any geographic location... nothing to hard to understand/accomplish.
In terms of design, you should brush up on that before writing a large scale ap... bad database design can really cripple a system!