> (e) If you had just a one way master->slave relationship and you delete
> data on the slave, that is very bad. The slave is now not the same as
> the master, the record will not be re-inserted, if you go to update the
> record on the master, when the command gets replicated to the slave an
> err
(a) You are mistaken. You can easily setup both as masters and then as
slaves to each other. Simply enable the neccesary binary logging on
both sides, then use the CHANGE MASTER TO command to set each to point
at the other. Now when you do an insert or delete on either it gets
replicated to the
Hi
i'm using MySQL version 4.0.20d.
I was able to set up a simple replication between a master and a slave.
To fully understand the replication mechanism of MySQL i would like to ask
some questions (the manual does not answer all my questions):
(a) in 4.0.20d there is no way for a kind of Mas
Hi list,
I'm trying to get mysql replication set up for a distributed development
environment. The master is the production server, whereas the slaves are
part of the developers' sandboxes (on their own machines).
The master machine is using MySQL 4.0.15, the slaves a nice mix of 4.0.15+
and 4.
Hi all,
I'm trying to setup a failover mysql server, and for that I need
replication. Now here's is how I would do it (3 servers, A and B are
located next to each other, C is off site):
A is master of B
B is master of A
B is master of C
Now I don't think this will cause much problems, as the doc
rsten ICM MP SCM GO 21
> Cc: '[EMAIL PROTECTED]'
> Subject: Re: Replication Questions 2
>
> Hi,
>
>
> Guddack Thorsten ICM MP SCM GO 21 wrote:
> > Hi List,
> >
> > again some Questions to replication in mysql:
> >
> > I test
Hi,
Guddack Thorsten ICM MP SCM GO 21 wrote:
Hi List,
again some Questions to replication in mysql:
I test the replication with following setup:
1 Server in Europe as the master, 2 servers in Asia and south america as
slaves.
Both slaves does the replication very fine.
Every insert, update
Hi List,
again some Questions to replication in mysql:
I test the replication with following setup:
1 Server in Europe as the master, 2 servers in Asia and south america as
slaves.
Both slaves does the replication very fine.
Every insert, update or delete is replicated very fine, even with bin
Sorry for the below questions: perhaps are obviously !
1) Which is the correct tool to administrate a remote mysql db in my
network ?
2) In my network I have:
server A = MASTER
server B,C as slaves running always
server D running sometimes used to develop.
Every night server A stop se
Hello.
On Mon 2002-07-29 at 10:06:50 -0400, [EMAIL PROTECTED] wrote:
> Hello everyone,
>
> The mysql documentation about replication is great at describing
> how to replicate fomr one master server.
>
>If i want to replicate many db servers to one replication server is
> there a way I
Hello everyone,
The mysql documentation about replication is great at describing
how to replicate fomr one master server.
If i want to replicate many db servers to one replication server is
there a way I can edit the my.cnf file to do this. Or would it be
better to have another conf fi
Hi Jeff,
On Tue, 2002-05-21 at 11:15, Jeff Field wrote:
> I think I understand how to set up replication but have a couple unanswered
> questions. I'm hoping the list can help.
>
> I have two servers with MySQL. Each server currently has completely
> different databases, except for the standard
Hi.
Disclaimer: I am not actively using replication currently, so take it
with a grain of salt.
On Mon, May 20, 2002 at 08:15:59PM -0500, [EMAIL PROTECTED] wrote:
> I think I understand how to set up replication but have a couple unanswered
> questions. I'm hoping the list can help.
>
> I have
I think I understand how to set up replication but have a couple unanswered
questions. I'm hoping the list can help.
I have two servers with MySQL. Each server currently has completely
different databases, except for the standard mysql permissions database.
Server 1 is in production and server 2
On Mon, Jan 21, 2002 at 10:50:10PM +0200, Heikki Tuuri wrote:
>
> this is a known 'feature' which is also mentioned in the
> manual. SHOW TABLE STATUS will set an exclusive lock to the end of
> table to look at the current auto-inc column value, which SHOW TABLE
> STATUS has in its output. Since
Chris,
>Hi there,
>
>I've been experimenting with InnoDB and replication and now have a few
>questions...Firstly, is it a known bug that "SHOW TABLE STATUS" screws up
InnoDB
>transactions? To insert data into my innoDB table I've been using:
>set autocommit=0;
>INSERT ...
>INSERT ...
>...
>comm
Hi there,
I've been experimenting with InnoDB and replication and now have a few
questions...
Firstly, is it a known bug that "SHOW TABLE STATUS" screws up InnoDB
transactions? To insert data into my innoDB table I've been using:
set autocommit=0;
INSERT ...
INSERT ...
...
commit;
In total
I've been reading the list and documentation, but haven't found
confirmation/denial of the following issues:
(Currently using ver 3.23.33 intel binary RPM from mysql.com)
1) Is it possible to have multiple instances of mysql updating the
_same_ binary log(same machine)? If so, this would allow a
On Mon, Feb 05, 2001 at 03:58:37PM +0100, Lukas Gruber wrote:
>
>
> chapter 11: "replication" doesnt mention any way of scheduling
> replication. it says after one configured and restarted the slave
> server it will connect to the master and then start replication. is
> there a way to schedule
hi list,
i am new to mysql. i have read through the reference-manual but still
there are some things i could not answer myself. please help, many
thanks in advance.
---
mysql-reference-manual describes longblob as a blob column with a
maximum length of 4294967295 characters but also says that o
On Mon, Jan 29, 2001 at 04:40:53PM -0800, Ricardo Kleemann wrote:
> Hi everyone,
>
> I have twice posted a problem with replication and have since seen 2
> or 3 others post with similar replication questions and problems.
You've certainly been on the list long enough to witn
nope sorry
On Mon, 29 Jan 2001, Ricardo Kleemann wrote:
> Hi everyone,
>
> I have twice posted a problem with replication and have since seen 2 or 3
> others post with similar replication questions and problems.
>
> However I have yet to see ANYONE respond to any of those p
Hi everyone,
I have twice posted a problem with replication and have since seen 2 or 3
others post with similar replication questions and problems.
However I have yet to see ANYONE respond to any of those posts.
I dont understand, it feels like we're being totally ignored. Can no one
I'm doing NIDS work as a small part of my job and have setup MySQL 3.22.32 for
logging of alerts. My problem is that when a user accesses the db it gets
locked and the NIDS hangs if the read takes too long, forcing a reboot of the
NIDS box. I'm trying to determine if I replicate the db and do th
24 matches
Mail list logo