hi every1
ive got 2 mssql 2005 and 2 mysql 4.1 servers which have to be mirrored.
mssql - mssql and mysql - mysql
the problem is, both db's can be accessed which implies that changes
on db1 have to be written to db2 and changes on db2 have to be written to db1
and this has to be done on server level.
what i found through some googling is "bi-directional mirroring"
but can you guys tell me, is this reliable for what im intending to do?
can 1 db go offline, leaving the otherone running and when the other db comes online again, update its information?
and can you provide me a good tutorial? (doing both on windows - ms and mysql)
ive got 2 mssql 2005 and 2 mysql 4.1 servers which have to be mirrored.
mssql - mssql and mysql - mysql
the problem is, both db's can be accessed which implies that changes
on db1 have to be written to db2 and changes on db2 have to be written to db1
and this has to be done on server level.
what i found through some googling is "bi-directional mirroring"
but can you guys tell me, is this reliable for what im intending to do?
can 1 db go offline, leaving the otherone running and when the other db comes online again, update its information?
and can you provide me a good tutorial? (doing both on windows - ms and mysql)