Working with millions or billions of records

Discussion in 'MySQL' started by xhanch, Oct 17, 2009.

0
Page 2 of 2
  1. wildogre

    wildogre Well-Known Member

    Messages:
    1,018
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    128
    #21
    I'll also suggest oracle or MSSQL. Because it can handle larger amount of data.
     
    wildogre, Oct 31, 2009 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #22
    That's so good to hear. It gets a little interesting trying to cluster when you have a 100Gb database. Is that > 5.1 or >6.0? Have you switched DP over to 5.1 yet, or are you still on 5.0?
     
    jestep, Nov 2, 2009 IP
  3. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #23
    MySQL 5.1.6 was the version they introduced disk-based NDB tables for MySQL Cluster.

    Still running 5.0.xx here, for what I need, I haven't seen anything in 5.1.xx that warrants an upgrade.
     
    digitalpoint, Nov 2, 2009 IP
  4. xhanch

    xhanch Member

    Messages:
    683
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    35
    #24
    I have a full confidence using MySQL. They provide free stuff that can compete with Oracle and MSSQL.
    Now, I am looking forward to Full Text Indexing feature for InnoDB. I hope I can be relieved to use InnoDB for all of my tables. :)
     
    xhanch, Nov 3, 2009 IP
Page 2 of 2