Help... Idea or guide needed..

[chaiwei]

Hi,

 

I would like to ask for you all's opinion.

My company want to co-locate our server and let other hosting company to host.

Let say currently I have one job portal system.

Got two user. 

1) internal staff(our management staff) ---management 

2) customer -- ppl who looks for job ,  company who look for outsourcing staff 

 

i want to seperate this two to two side: 

 

1) own hosting side -> internal staff use

2) co-locate side -> customer use

 

(two same database and two same script but they must be sync together) 

eg. When we update xx in co-locate server, our own hosting will also be update.

    When we update zz in our own hosting, co-locate server will also be being 

    updated.

 

 

QUESTIONS,

Is replication works(database)? I think was using master to master right?

Is there any other idea/way to archieve my goal?

 

REASON two side:

1) In case our hosting server down , customer still can get the information from co-locate server.(main reason)

 

2) currently internal staff and customer are sharing one same database and every day our staff done a lot of complex insert and delete query. My superior was worry about the it will slow down the performance of website.(optional)

 

3) site hit modules. If internal staff also  using the same site. It will affect the accuracy of the site hit. (optional)

 

PS: Sorry if I am post in wrong forum. I need some idea or way to move on. I am totally lost.

[chaiwei]

Any one can give me some idea??