What are some steps to scale a database?

Discussion in 'Databases' started by UCDaZ, Jun 23, 2010.

0
  1. #1
    From what I know when the mysql server is having scaling issues, the admin/programmer should do the following steps:

    *start using memcache
    *see what columns can be indexed.
    *use innodb
    *partition the database
    *shard the database

    Anything else I can help scale my database?
     
    UCDaZ, Jun 23, 2010 IP
  2. netload

    netload Member

    Messages:
    105
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    28
    #2
    Usually innodb-tables require more CPU resources.

    1. Optimize indexes and tuning my.cnf. Tool mysqltuner.pl can help you in this step.
    2. Optimize sql queries (see slow-queries log to detect slow queries)
    3. Maybe try to migrate to a more powerfull single deducated server or increase memory size in the exist server.
     
    netload, Jun 23, 2010 IP
  3. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #3
    In my experience partitioning and sharding are well after "Upgrade hardware".
     
    jestep, Jun 23, 2010 IP
  4. UCDaZ

    UCDaZ Active Member

    Messages:
    180
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #4
    jestep:
    When do I know I need to upgrade my hardware?
     
    UCDaZ, Jun 24, 2010 IP