i currently have 2 servers hosted on 2 different networks w/2 different providers so, i want to implement ha ;)

now, i know mysql supports some replication however you can only insert, update, etc into the master database.

what i wanna do then is to have both servers contain their own database. server1 is master, server2 slave.

i want users to be able to read pages from either server but only makes posts on one server.

so, is there an easy way to force all posts to go to server1???

that way if server2 ever goes down, big deal use server1 but if server1 ever goes down, i could just make server2 master and send all posts to it...

does this make any sense???

#If you have any other info about this subject , Please add it free.#

Your name: E-mail: Telphone: Your comments: If you have any other info about use database replication??? , Please add it free.