1. Welcome to TechPowerUp Forums, Guest! Please check out our forum guidelines for info related to our community.

Good site or book on database management and scaling

Discussion in 'Programming & Webmastering' started by xbonez, Oct 3, 2011.

  1. xbonez New Member

    Joined:
    Nov 29, 2010
    Messages:
    1,182 (0.83/day)
    Thanks Received:
    315
    Location:
    Philly, PA (US)
    Ok, here's the deal. I'm working on a website right now that serves as the face for a online service. The service is going to be heavily database driven with a lot of read / write cycles and a lot of information being stored on the databases.

    We're using MySQL. Currently, for the sake of setting up the website, I'm using a single database with multiple tables depending on the information being stored and purpose being served. If things go right, this service could attract a lot of traffic and our database could blow up significantly fast.

    I'm really interested in setting up the database schemas right from the get go so later down the line we don't need to carry out a major overhaul of the backend resulting in downtime.

    Long story short, could you please recommend me some books / websites that teach / talk about building scalable databases. I don't need the basics of DBMS or SQL. I'm looking primarily for sources that discuss the architecture of high volume databases - normalizing, sharding etc.
     
  2. Easy Rhino

    Easy Rhino Linux Advocate

    Joined:
    Nov 13, 2006
    Messages:
    13,463 (4.64/day)
    Thanks Received:
    3,264
    any textbook on database design you can find on amazon.com should be helpful. also, go to the bookstore and look around in the computer section.
     
  3. Jacko28 New Member

    Joined:
    Sep 23, 2008
    Messages:
    67 (0.03/day)
    Thanks Received:
    10
    As Easy Rhino said most of the database systems books on amazon will cover what you need. I've got a book which I used at University, it went into alot of detail regarding subjects such as normalization and other methodoligies, it's an information systems dev book rather than purley database management but still good. I'm at work right now but when I get home I'll find out what it's called.
     

Currently Active Users Viewing This Thread: 1 (0 members and 1 guest)

Share This Page