Dear Nilnandan,
Thanks for the quick reply.
But this particular variable is not working in only one proc call...but
rest all procedures creating temporary tables, does not affect my
replication slaves.
So I am not able to identify the problem.
Here's the snapshot of my procedure which is
Hi Manasi,
Please try with this one.
Replicate_Wild_Ignore_Table = mydb\temp_.%
Regards,
Nilnandan Joshi
Manasi Save wrote:
Hi All,
I have kept
Replicate_Wild_Ignore_Table = mydb%.temp_%
this is temporary table which i want should not be replicated. But
still it is getting replicated an
Hi All,
I have kept
Replicate_Wild_Ignore_Table = mydb%.temp_%
this is temporary table which i want should not be replicated. But still
it is getting replicated and slave is getting crashed.
any input will be a great help.
--Thanks and Regards, Manasi Save Artificial Machines
Private Li
From: Dan Rogart [mailto:[EMAIL PROTECTED]
> On 11/14/07 4:01 PM, "Mike Johnson"
> <[EMAIL PROTECTED]> wrote:
>
> > Correction to a couple of replies I've seen -- a slave
> > server can have more than one master, but not to the same
> > database. That is, Slave reads Database1 and Database3
-Original Message-
From: Dan Rogart [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 14, 2007 1:07 PM
To: Mike Johnson; Baron Schwartz; bruce
Cc: mysql list
Subject: Re: MySQL - Replication (Master/Slave) Question
On 11/14/07 4:01 PM, "Mike Johnson" <[EMAIL PROTECTED]>
ible, can I get/see a sample my.cnf file illustrating
how this can be handled
thanks
-Original Message-
From: Dan Rogart [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 14, 2007 1:07 PM
To: Mike Johnson; Baron Schwartz; bruce
Cc: mysql list
Subject: Re: MySQL - Replication (Master
On 11/14/07 4:01 PM, "Mike Johnson" <[EMAIL PROTECTED]> wrote:
> Correction to a couple of replies I've seen -- a slave server can have
> more than one master, but not to the same database. That is, Slave reads
> Database1 and Database3 from Master1 and also reads Database2 from
> Master2.
>
>
Correction to a couple of replies I've seen -- a slave server can have
more than one master, but not to the same database. That is, Slave reads
Database1 and Database3 from Master1 and also reads Database2 from
Master2.
You may actually be able to get down to the table level, but I'd have to
check
On Nov 14, 2007 3:40 PM, bruce <[EMAIL PROTECTED]> wrote:
> Hi...
>
> I have a number of servers that I want to treat as Master Servers or the
> purpose of Replication..
>
> I'd like to have each of the Master, have the Slave DB on the same machine.
> Ie, a Slave server, might have 10 different Sla
bruce wrote:
Hi...
I have a number of servers that I want to treat as Master Servers or the
purpose of Replication..
I'd like to have each of the Master, have the Slave DB on the same machine.
Ie, a Slave server, might have 10 different Slave Databases/config files,
with each of the SlaveDB tie
Hi...
I have a number of servers that I want to treat as Master Servers or the
purpose of Replication..
I'd like to have each of the Master, have the Slave DB on the same machine.
Ie, a Slave server, might have 10 different Slave Databases/config files,
with each of the SlaveDB tied back to the M
esses
that would update the parent system with the local client information.
thoughts/comments...
-Original Message-
From: Baron Schwartz [mailto:[EMAIL PROTECTED]
Sent: Monday, November 05, 2007 9:55 AM
To: bruce
Cc: mysql@lists.mysql.com
Subject: Re: Replication - Master/Slave Issue...
Hi,
bruce wrote:
Hi...
I have a situation where I'm looking at multiple child servers, each of
which has it's own mysql/DB/Tbls... I want to be able to have all the
information that exists in these tbls, to be captured, and copied to a
single parent TBL on a separate machine.
So, I'm trying to
Hi...
I have a situation where I'm looking at multiple child servers, each of
which has it's own mysql/DB/Tbls... I want to be able to have all the
information that exists in these tbls, to be captured, and copied to a
single parent TBL on a separate machine.
So, I'm trying to figure out what's t
hi...
i have a project and i'm trying to figure out the best approach to architect
a solution to resolve the issues i'm facing. i'm open to whatever might be
the 'best' solution. keep in mind, this is a 'project' that's my own, kind
of a garage function!!
i'm creating a distributed web parsing/cr
Hi everbody!
I' m trying to do a replication, and this is the first time!!
My MySQL is running in Windows XP (master and slave).
Where are my errors?
Can I configure a Master in Linux and a Slave in Windows?
#Master Configuration
##
On Wednesday 27 August 2003 10:50, Hans van Harten wrote:
> Matthias Blaser wrote:
> > It's possible a server could act as master for one database with slave
> > server A and as a slave for another database which runs on master
> > server B?
>
> As in A - database1 -> S - database2- > B
Well,
Matthias Blaser wrote:
> It's possible a server could act as master for one database with slave
> server A and as a slave for another database which runs on master
> server B?
As in A - database1 -> S - database2- > B
AFAIK anything S logs will be red by B. Using 'replicate-do-db=database2' B
Hi,
I've read the replication section in the manual but i'm not quite sure about
the possibilities of the replication in mysql:
It's possible a server could act as master for one database with slave
server A and as a slave for another database which runs on master server B?
If yes: as far as
19 matches
Mail list logo
