0
votes
1answer
86 views

Client to use the slave when the master is down in MySQL replication

Is it possible for the client to use the slave when the master is down in mysql replication? I have already set up a simple MySQL replication having a master and a slave. The client connects to the ...
2
votes
1answer
407 views

error setting up replication from mssql to mysql

I'm trying to setup replication from SQL Server 2005 to MySql 5.1.53. I am able to add the publication without any problem. However, when I go to add the subscription I get this error: OLE DB or ...
2
votes
1answer
235 views

Full, Differential and Log backups of databases, MSSQL an MYSQL

Best I give a back story so you get the full picture. I am in the process of setting up a new business, which hopefully will start in April 2012, and as such I am preparing every aspect of it. One ...
3
votes
1answer
1k views

One way replication from MSSQL2005 to MYSQL 5.x

I have a mysql database acting as our websever backend. We have our production mssql server that we would like data pushed from, to our mysql server. I have successfully made the mysql server an ...
1
vote
2answers
80 views

Is it possible to replicate/cluster two different databases

I would like to know if it's possible to replicate or cluster a table between mssql and mysql. That could be usefull during a migration process.