Hello Jeetendra,
Jeetendra Mirchandani wrote:
Is it possible to replicate only DML statements? I don't want an
operator error of drop table to replicate to the slave
I use 5.0.x
ps: please cc me on the reply
Regards,
Jeetu
There is no good, there is no bad, there's just what happened. Dance
Is it possible to replicate only DML statements? I don't want an
operator error of drop table to replicate to the slave
I use 5.0.x
ps: please cc me on the reply
Regards,
Jeetu
There is no good, there is no bad, there's just what happened. Dance with it.
--
MySQL General Mailing List
For list
Hey guys,
I'm running a master/slave setup with v4.0.20. There are a hand full
of databases being replicated. For backups, we stop replication on the
slave and pull a text dump using mysqldump. I also record a 'SHOW
SLAVE STATUS' from the time of the backup.
My replica server crashed last night.
knowledge on the correct procedure.
Regards,
Scott Tanner
Systems Administrator
Rowe/AMi
Gary Richardson [EMAIL PROTECTED]
10/08/2004 01:01 PM
Please respond to Gary Richardson
To: [EMAIL PROTECTED]
cc:
Subject:Restarting Replication from Backup
Hey guys
PROTECTED]
10/08/2004 01:01 PM
Please respond to Gary Richardson
To:[EMAIL PROTECTED]
cc:
Subject:Restarting Replication from Backup
Hey guys,
I'm running a master/slave setup with v4.0.20. There are a hand full
Systems Administrator
Rowe/AMi
Gary Richardson [EMAIL PROTECTED]
10/08/2004 02:04 PM
Please respond to Gary Richardson
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
cc: [EMAIL PROTECTED]
Subject:Re: Restarting Replication from Backup
Hey,
The perl script
Hey guys,
I think I have this figured out. I'm just doing some testing. If I
manually recreate the master.info file, it sort of works, but I get
the following error from the IO thread:
Error reading relay log event: slave SQL thread aborted because of I/O error
So, instead of manually creating
On Friday 08 October 2004 19.01, Gary Richardson wrote:
Hey guys,
I'm running a master/slave setup with v4.0.20. There are a hand full
of databases being replicated. For backups, we stop replication on the
slave and pull a text dump using mysqldump. I also record a 'SHOW
SLAVE STATUS' from
Yeah, that's exactly what I figured out.. We do record the SHOW SLAVE
STATUS settings before each backup.
I find we need individual tables restored far more frequently than
whole databases. It's much easier using mysqldump and perl to dump
each table in text to its own file. This is especially
Hi there
I have a question regarding replication.
This is the situation:
Mysql-Max4.0.16
192.168.0.10 master
192.168.0.11 slave
I would like to use the slave as the backup server
and use it in case the master goes down for any reason.
I'm looking for a safe method to re-update the master
Hi
thanks a lot for your prompt reply. The second email
went out on accident - apologies.
I managed to fix it - I found localhost; EcolMod1
in user.myd.
Thanks again,
Rainer
On 13 Nov 2003 at 10:41, nm wrote:
Hi there
I have a question regarding replication.
This is the situation:
On Thursday 13 November 2003 10.41, nm wrote:
Hi there
I have a question regarding replication.
This is the situation:
Mysql-Max4.0.16
192.168.0.10 master
192.168.0.11 slave
I would like to use the slave as the backup server
and use it in case the master goes down for any reason.
I'm
Hi
I set a 2-way replication on 2 servers.
I made some test transactions and it is working.
I can make the clients go to any of my servers and the replication
is done in real time, or so. It looks great.
What are the potential problems I could have? Suggestions?
Do you have any experience?
13 matches
Mail list logo