Is it possible to set up replication on a shared mySQL server, i.e.
have the replication only concern the databases that I have access to,
without changing the entire server setup? (This will probably be in a
shell account on a Linux box)
I basically have 2 server, one which I have full controll over and a
second (backup) that I will share with other people. I want to set up
a two-way replication between these, so that server 1 can go down at
any time. But as its just a backup, I would like to buy server 2 as
cheaply as possible, ex. a webhotel (where the mySQL is shared).
Can this be done? Or do I have to buy a second standalone server? Is
there some possible workaround (the replication does not have to be
continous, only every minute or so)
Any help and suggestions greatly appreciated
regards
have the replication only concern the databases that I have access to,
without changing the entire server setup? (This will probably be in a
shell account on a Linux box)
I basically have 2 server, one which I have full controll over and a
second (backup) that I will share with other people. I want to set up
a two-way replication between these, so that server 1 can go down at
any time. But as its just a backup, I would like to buy server 2 as
cheaply as possible, ex. a webhotel (where the mySQL is shared).
Can this be done? Or do I have to buy a second standalone server? Is
there some possible workaround (the replication does not have to be
continous, only every minute or so)
Any help and suggestions greatly appreciated
regards