Design & Development of a Social Networking & Blogging Web site.

Details Type of Website : Social networking & Blogging. Requirement: Complete redesigning and restructuring of Website with the given templates and designs and present database to be restructured and imported to the new website. This new website will be divided in to two websites like social-networking with the present user database and separate blogging website linked with the existing website user database. user will only log into 1st website and when they choose blogs they will be moved to new website with connection . Present content size around 60 GB (15 gb content + 45 GB aprox Database) present Database is in Mysql. Proposed plan of Action: Database to be clustered so as to enable the database to load quick either basing on the user IP address or country based records . The clustered database can be fetched from different / multiple database servers . Database Architecture should be flexible like it should reduce the load on the server and load balance to be taken care at the time of Designing itself. Existing Database only to be used . Structuring modifications can be done . When the website goes live, the existing database should be available on the website. Support for database management / database administration is required for some time. Proper incremental backup design to be designed for regular backups instead of fullbackup every time either basing on the date or userid based. Develop A Prototype Split database structure into multiple tables Use understandable field names Avoid illegal file names Ensure Consistency Avoid blank fields Use standard descriptors for date and time Use currency fields if appropriate Avoid proprietary extensions Avoid the use of field dividers Project or Ongoing work: Ongoing work API Integration Required: Other, Cloud Storage, Payment Processor