SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Jul 2004
    Location
    bahamas
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Mysql newbie needs advice

    Hi,
    I am new to mysql and have been asked to create a database to achieve maximum speed . The website involves sharing of images and has recieves over a million hits every day.
    My questions are as follows. Kindly take some time fof to offer valuable suggestions.
    1-) Should i go for more databases less tables ( i personally don't think it can help)
    I need roughly 50 table fields for each user.
    2-) The user activity is extensively tracked . I believe creating a new databse and storing legacy data over there is a solution to keep the main database size to a minimum possible. Is that a right approach
    3-) I do not know if mysql ( free version) is capable of handling this much load..though if google is using it there must be a good reason.
    4-) How can i achieve maximum security for my database.
    5-) I wish to create affilitates and offer them the access to database ... is xml the way to go...
    6-) The website involves travel pictures and is very traffic intensive. There is also a demand for an extensive admin module...should i create new tables for the admin or try to process the adata from existing database tables.

    Please advice of these issues and if there are other sugegstions i could avail of. Any examples would be great.
    cheers
    sharp

  2. #2
    SitePoint Enthusiast
    Join Date
    Feb 2003
    Posts
    76
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Go to B&N and buy some MYSQL books. That's the best advise I can give you.

  3. #3
    SitePoint Addict pointbeing's Avatar
    Join Date
    Jun 2004
    Location
    London, UK
    Posts
    227
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by micron
    Go to B&N and buy some MYSQL books. That's the best advise I can give you.
    Very Good Advice Indeed.


    Well, here's my two cents anyway.

    1) You only need 1 database. 50 fields in a table is absolutely fine.

    2) Yeah, that's a reasonable approach. We're looking at doing things the same way - keep anything over 24 hours old off-site, maybe shift it across in a batch job overnight.

    3) Is Google using MySQL? Fine, so is Slashdot. So, yes, MySQL can cope, if your database design skills and indexing are up to scratch. That's the real question.

    4) No easy answers here. Hire a team of security specialists, or do a shedload of reading.

    5) Possibly. XML-based Web Services are frequently used for this sort of thing, but the learning curve is steep. So if your affiliates are just muppets you found online, they may struggle with it. If they're bluechips they'll love you for it.

    6) Impossible to say. Completely depends on the specific tasks your admin system will perfom.

    I'm gonna post the normalization link again, btw. Everyone should read this before going anywhere near a database, ever again ;-)

    http://www.oreilly.com/catalog/javad...apter/ch02.pdf

    Best of luck...


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •