#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2013
    Posts
    1
    Rep Power
    0

    Lightbulb PostgreSQL database for Big Data


    Hello.
    I have application architecture, where using Master/Slave replication strategy. But slaves count about 1100. It's real big. Are there any problems and whether it is at all? Because I don't saw production application with slaves count.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Location
    Usually Japan when not on contract
    Posts
    240
    Rep Power
    12
    The problems will be whether your infrastructure can scale, not really anything about Postgres. You could chain the replication tasks to ease the bandwidth load if you have huge numbers of updates, but again, this is an infrastructure problem, not really a Postgres-specific problem.
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2013
    Posts
    158
    Rep Power
    11
    Theoretically you should be able to setup that many slaves,
    but I doubt that it's what you'd want.

    You can probably get away with it if the application that use the slaves are read-only. If the 1100 slaves also cause updates then the master will receive a huge amount of updates so it would have to be a gigantic server.

    Perhaps the real question is why you want 1100 slaves...

IMN logo majestic logo threadwatch logo seochat tools logo