Pointing 3 Different servers to the same DB

  • cmunns

    (@cmunns)


    13 years, 1 month ago

    Hey everyone. Does anyone know how to properly point three different servers to a db on a completely different server?

    Or I guess the answer for all three would be how do I correctly point one server to an alternate db that exists elsewhere?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator cubecolour

    (@numeeja)

    13 years, 1 month ago

    as long as hostname resolution and routing is set up correctly you specify the target db server hostname in wp-config.php. You can use a single db for several separate wp instances by setting the table prefix to be unique in the wp-config.php for each. If the webserver and database are on separate networks you may experience poor performance compared to having both on the same box or on the same network. Also some web hosting companies don’t allow outside connections to their db server as a security measure.

    Thread Starter cmunns

    (@cmunns)

    13 years, 1 month ago

    How would this work if I want one wp db instance accessed by multiple hosts?

    The same way? I just want to clarify so you know exactly what I meant…

    Moderator cubecolour

    (@numeeja)

    13 years, 1 month ago

    Can you clarify what you mean by multiple hosts? Do you mean multiple WordPress installations?

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Pointing 3 Different servers to the same DB’ is closed to new replies.