-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 25, 2003 8:28 AM
To: [EMAIL PROTECTED]
Subject: re: Replication problem (alter table fails)
On Tuesday 25 February 2003 14:17, Kirill Peskov (WEB-EU) wrote:
> Coud you, please, give an advice to solve follow
On Tuesday 25 February 2003 14:17, Kirill Peskov (WEB-EU) wrote:
> Coud you, please, give an advice to solve following problem:
>
> I've got two Mysql Servers:
>
> * Master: Sparc Solaris 8, MySQL 3.23.32
> * Slave: RedHat Linux 7.2, MySQL 3.23.32
>
> Replication of data runs fine, all "in
I've narrowed it down a lot. We have two different PHP interfaces for the
database. One is for employees to access the data, and the other is for
customers. The UPDATEs and INSERTs on the system that customers use is not
being replicated, but the one that employees is working perfectly.
Th
> Check the user 'repl' has REPLICATION SLAVE privilege.
Ah. that fixed it. Actually, the real reason was that I had not
yet updated the mysql tables and the new privileges did not take
effect as a result.
mysql_fix_privilege_tables , followed by the 'GRANT' command
and 'flush privileges' fixed
On Thursday 13 February 2003 16:43, Johannes Ullrich wrote:
> I am having problems setting up replication between two 4.0.10
> servers.
>
> What I did so far:
>
> - generate a dump of the current state of the server using
> 'mysqldump' (its a mix of mostly innodb tables and some MyISAM
> tab
Hi "Oliver Schlag" <[EMAIL PROTECTED]>,
I'm not sure if you have checked the manual yet, but following
links seem to be somewhat related to your query:
* http://www.mysql.com/doc/en/Replication_FAQ.html
* http://www.mysql.com/doc/en/Replication.html
* http://www.mysql.com/
Hi "goth" <[EMAIL PROTECTED]>,
I'm not sure if you have checked the manual yet, but following
links seem to be somewhat related to your query:
* http://www.mysql.com/doc/en/Commands_out_of_sync.html
* http://www.mysql.com/doc/en/Replication.html
* http://www.mysql.com/doc/
Hi [EMAIL PROTECTED],
I'm not sure if you have checked the manual yet, but following
links seem to be somewhat related to your query:
* http://www.mysql.com/doc/en/Replication.html
* http://www.mysql.com/doc/en/Replication_FAQ.html
* http://www.mysql.com/doc/en/Replication
003 03:05
À : RAHARD Matthieu
Cc : mysql
Objet : Re: Replication question
On Wed, Feb 05, 2003 at 10:37:29AM +0100, RAHARD Matthieu wrote:
> Hello everybody,
>
> Is it possible to set up this kind of replication and what parameters I
have
> to set in the my.cnf file ?
>
> Tab
On Wed, Feb 05, 2003 at 10:37:29AM +0100, RAHARD Matthieu wrote:
> Hello everybody,
>
> Is it possible to set up this kind of replication and what parameters I have
> to set in the my.cnf file ?
>
> Table A own by server A and replicated to server B and C
> Table B own by server B and replicated
Hello everybody,
Is it possible to set up this kind of replication and what parameters I have
to set in the my.cnf file ?
Table A own by server A and replicated to server B and C
Table B own by server B and replicated to server A
Table C own by server C and replicated to server A
The mysql leve
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
-Ursprüngliche Nachricht-
Von: Guddack Thorsten ICM MP SCM GO 21
Gesendet: Freitag, 31. Januar 2003 20:51
An: 'Gelu Gogancea'; '[EMAIL PROTECTED]'
Betreff: Re: Replication Problems/Questions
Hi,
thank you for you're response,
but in the mysql-manual > ve
Hi,
- Original Message -
From: "Guddack Thorsten ICM MP SCM GO 21" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 30, 2003 3:44 PM
Subject: Replication Problems/Questions
> Hi List
>
> I'm using 2 WinNT-Servers, Sp6 with mysql 4.0.5. max-nt.
>
> I ve setup a replicati
Hi list,
My original post concerning this issue is below - it was a week or so ago. No replies
were forthcoming, but I'm pleased and a bit embarrassed (so simple) to say that I have
figured it out, and my slave is now replicating from the master.
The problem was that the mysql data directory wa
Look into a product called SQLPorter.
http://www.realsoftstudio.com
I used it once for a MySQL to MSSQL migration project, but you could go
in the other direction. If I remember correctly, I think it includes a
scheduling feature.
-bill
On Tue, Jan 21, 2003 at 01:15:01PM -, John Lodge wrot
Kris,
- Original Message -
From: ""Krzysztof Karski"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, January 21, 2003 11:35 AM
Subject: replication problems with InnoDB tables...?
> So I have been reading a lot lately about replication but I can't find a
> good sum
On Thursday 16 January 2003 12:16, CheongMeng wrote:
> is it possible to ignore all sql delete statement while doing
> mysql replication?
Nope.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___
You could do something like have a process periodically run the non-delete
queries in the logs against another database and replicate the second
database. Wouldn't be automatic, but you'd have as much control as you like
over what goes in the other db.
Depending on what you're trying to do, it ma
Hi Martin,
Replication definitely does not ignore CREATE DATABASE all the time,
just every now and then :) I had 93 databases that made it through
replication, and the 94th failed. There aren't any binlog-ignore-db
paramaters. I've dumped the binlog out, and CREATE DATABASE did make
it into the
- sql,query
On Tue, 2003-01-14 at 23:55, Jeremy Zawodny wrote:
>
> What do the relevant sections of the my.cnf files on the master and
> slave look like?
> --
Hi,
I've had the same issue - but always assumed that
replication was meant to ignore "create database ...".
I've looked into it furth
On Tue, Jan 14, 2003 at 05:26:25PM -0500, David Nedved wrote:
> I've been doing a lot of poking around...
>
> the actual database is what didn't get created. The CREATE DATABASE
> statement did make it into the log file, and the slave got past that
> point without ever creating the database.
Tha
I've been doing a lot of poking around...
the actual database is what didn't get created. The CREATE DATABASE
statement did make it into the log file, and the slave got past that
point without ever creating the database.
Go figure...
On Tue, Jan 14, 2003 at 02:06:39PM -0800, Jeremy Zawodny wrot
On Mon, Jan 13, 2003 at 02:16:23PM -0500, David Nedved wrote:
>
> We keep having issues where we create a new table on the master, and
> a short while later the slave will crash because it starts trying to
> perform queries which insert into the new table, but it looks as if the
> query to create
I don't think I have anything that should cause this. Here is my my.ini
from the the slave. The tables that are being excluded are not listed.
[mysqld]
basedir=C:/mysql
datadir=C:/mysql/data
set-variable=max_allowed_packet=16M
log-slave-updates
log-bin
# Replication variables
master-host=x.
Message -
> From: "Ross Davis - DataAnywhere.net" <[EMAIL PROTECTED]>
> To: "'Jason Brooke'" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Monday, January 13, 2003 9:16 AM
> Subject: RE: Replication bug?
>
t;
Sent: Monday, January 13, 2003 9:16 AM
Subject: RE: Replication bug?
> Did you ever get any confirmation that it will be added to the official
> bug list?
>
> -Original Message-
> From: Jason Brooke [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, January 12, 2003 3:14 AM
&g
From: Frederick R. Doncillo [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 11, 2003 10:58 PM
To: Ross Davis - DataAnywhere.net
Cc: [EMAIL PROTECTED]
Subject: Re: Replication bug?
Are the slaves doing the replication process? If not, you may try it
that way. Slaves should do the updating and
Did you ever get any confirmation that it will be added to the official
bug list?
-Original Message-
From: Jason Brooke [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 12, 2003 3:14 AM
To: Ross Davis - DataAnywhere.net
Cc: [EMAIL PROTECTED]
Subject: Re: Replication bug?
Yes this is
Yes this is the same issue I've reported previously. Unless literally
'select' the database, the query is never written to the binary log.
- Original Message -
From: "Ross Davis - DataAnywhere.net" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, January 12, 2003 12:38 PM
Subject
Are the slaves doing the replication process? If not, you may try it
that way. Slaves should do the updating and must request from the
server and not the server to the slave. :-)
Fred.
Ross Davis - DataAnywhere.net wrote:
I think I have found a replication bug. We are using Mysql-Max 3.23.53
Remi, Michael,
On Fri, Jan 03, 2003 at 11:39:44AM -0500, Michael T. Babcock wrote:
> Fred van Engen wrote:
>
> >SET TIMESTAMP=1039489014;
> >
> >Each time with the current timestamp of course. I haven't checked
> >if it is actually used by the slave however.
> >
> >
>
> If it is used, I would i
Remi,
n Fri, Jan 03, 2003 at 10:56:21AM -0500, Remi Lanteigne wrote:
> I would like to know if there is a way of telling mysql to transfer the
> value of the function now() in it's replication, as it is now (from what I
> see in the binlog file) mysql passes the now() to the slave instead of the
>
> MyTOP says this particular slave has been up 47 days, 2 hours... It's had
> 56M queries, of those 4,559 were "slow"... Not being a MySQL expert, I'm
> not sure how to get slow queries/hour directly from MySQL.
You would use SHOW STATUS, but mytop did it for you :-)
> Do you mean using a load
Or, alternatly, is there a way to limit the slave thread to only "X"
bin-log transactions per second?
>>>
>>> There is not.
>>
>> Any plan to add this feature? I would think it'd be useful...
>
> Wouldn't it be better to *solve* your problem instead of going
> around it?
Well, as this i
my Zawodny" <[EMAIL PROTECTED]>
> To: "Maxime LEMAIRE" <[EMAIL PROTECTED]>
> Cc: "Mysql" <[EMAIL PROTECTED]>
> Sent: Monday, December 30, 2002 10:56 AM
> Subject: Re: replication
>
>
> > On Mon, Dec 30, 2002 at 08:37:13AM +0100, M
On Mon, Dec 30, 2002 at 10:16:07PM -0600, Dan Nelson wrote:
> Bah. sql, query, queries, smallint
>
> In the last episode (Dec 30), Rick Faircloth said:
> > Aaaa, that's how the auto_increment id problem is solved.
> >
> > I wonder why they can't do something like Access with its
> > Replicati
Bah. sql, query, queries, smallint
In the last episode (Dec 30), Rick Faircloth said:
> Aaaa, that's how the auto_increment id problem is solved.
>
> I wonder why they can't do something like Access with its
> ReplicationID or whatever it's called...
Access just used a random 32-bit integer,
On Mon, Dec 30, 2002 at 05:45:07PM -0500, Rick Faircloth wrote:
> Aaaa, that's how the auto_increment id problem is solved.
>
> I wonder why they can't do something like Access with its ReplicationID
> or whatever it's called...
They can (and probably will) but it's all a matter of developmen
In the last episode (Dec 30), Matt Sturtz said:
> Hello, Jeremy, et al-- Thanks for the reply before... Further questions:
> >> Is it possible to set either set the priority ('nice') of the
> >> Slave thread down so it doesn't do that?
> >
> > The slave thread only? No, not really. You could ni
:52 PM
To: Rick Faircloth
Cc: [EMAIL PROTECTED]
Subject: Re: replication
On Mon, Dec 30, 2002 at 12:15:49PM -0500, Rick Faircloth wrote:
> Hi, Jeremy.
>
> What if one is the master and one is a slave, but both are used in
> production environments?
That's safe. It avoids the proble
>>> Or, alternatly, is there a way to limit the slave thread to only "X"
>>> bin-log transactions per second?
>>
>> There is not.
>
> Any plan to add this feature? I would think it'd be useful...
Wouldn't it be better to *solve* your problem instead of going
around it?
> MyTOP says our key effic
On Mon, Dec 30, 2002 at 12:15:49PM -0500, Rick Faircloth wrote:
> Hi, Jeremy.
>
> What if one is the master and one is a slave, but both are used in
> production environments?
That's safe. It avoids the problem.
> Is it possible for a slave to be used as a live production database
> or is it si
On Mon, Dec 30, 2002 at 03:48:30PM -0600, Dan Nelson wrote:
> In the last episode (Dec 30), Matt Sturtz said:
> > Hello, Jeremy, et al-- Thanks for the reply before... Further questions:
> > >> Is it possible to set either set the priority ('nice') of the
> > >> Slave thread down so it doesn't do
On Mon, Dec 30, 2002 at 01:21:49PM -0700, Matt Sturtz wrote:
> Hello, Jeremy, et al-- Thanks for the reply before... Further questions:
>
>
> >> Is it possible to set either set the priority ('nice') of the Slave
> >> thread down so it doesn't do that?
> >
> > The slave thread only? No, not re
On Mon, Dec 30, 2002 at 02:55:19PM -0500, Arthur Fuller wrote:
>
> Is there in *nix an implementation of GUIDs? If the MS math is too
> be believed, GUIDs are guaranteed unique for the next century. No
> matter how many monkeys are at the typewriters. Supposing a) that
> there is a *nix GUID implem
Hello, Jeremy, et al-- Thanks for the reply before... Further questions:
>> Is it possible to set either set the priority ('nice') of the Slave
>> thread down so it doesn't do that?
>
> The slave thread only? No, not really. You could nice MySQL when you
> start it up. But I'm not sure how m
OTECTED]>
Sent: Monday, December 30, 2002 10:56 AM
Subject: Re: replication
> On Mon, Dec 30, 2002 at 08:37:13AM +0100, Maxime LEMAIRE wrote:
> > Hi,
> >
> > I would like to know how mySQL manage the identity (auto increment
> > counter) in a replication environment whe
?
Rick
Rick Faircloth,
Prism Productions
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 10:57 AM
To: Maxime LEMAIRE
Cc: Mysql
Subject: Re: replication
On Mon, Dec 30, 2002 at 08:37:13AM +0100, Maxime LEMAIRE wrote:
> Hi,
>
>
On Mon, Dec 30, 2002 at 08:37:13AM +0100, Maxime LEMAIRE wrote:
> Hi,
>
> I would like to know how mySQL manage the identity (auto increment
> counter) in a replication environment when 2 servers are both master
> on the same database.
In that situation, you really need to generate your own prima
On Thu, Dec 26, 2002 at 12:17:28PM -0700, Matt Sturtz wrote:
> Hello,
>
> We run several frontend servers (Linux/Apache/PHP) behind a load
> balancer. Each frontend is also a MySQL slave, and all queries are
> done locally (all changes go directly to the master). The problem
> is, whenever someb
On Monday 23 December 2002 13:11, Ganesh Rajan wrote:
> iam facing a problem or situation that i have installed mysql 3.23.52 on
> Windows 2000 server..which will be my master... i want to setup my slave
> server which will be on RedHat Linux 7.1 with mysql 3.23.49...
>
> can anyone help me out on
On Wednesday 18 December 2002 17:18, you wrote:
> At 16:57 18-12-02 +0200, you wrote:
> >On Wednesday 18 December 2002 11:36, Wico de Leeuw wrote:
> > > I've setup replication with a master-slave.
> > > But i only want to replicate some databases so i'd put in my.cnf on the
> > > slave (it's being
goal of this architecture is to prevent to lose data
i don't know if it's possible with mysql
(that depends of internal auto_increment id management)
-Message d'origine-
De : gerald_clark [mailto:[EMAIL PROTECTED]]
Envoye : jeudi 19 decembre 2002 16:59
A : [EMAIL PROTEC
Dan wrote:
not attempting to write to the index field. I also attempted to have it skip
the entry with the SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; command. This
command failed. It did not fail when I eliminated the GLOBAL word in the
command like so: SET SQL_SLAVE_SKIP_COUNTER=1; However, still n
On Wednesday 18 December 2002 11:36, Wico de Leeuw wrote:
> I've setup replication with a master-slave.
> But i only want to replicate some databases so i'd put in my.cnf on the
> slave (it's being used, checked that)
> replicate-wild-do-table=adb.% (it has to catch cross updates to)
> I also trie
anyone please?
hmm according to the manual comments somone also has the same problem with 4.04
http://www.mysql.com/doc/en/Replication_Options.html
Is it a bug?
At 10:36 18-12-02 +0100, Wico de Leeuw wrote:
Hiya
I've setup replication with a master-slave.
But i only want to replicate some data
I know it runs on 3306 :)
I can telnet to the host on port 3306.
- Chris
On Sat, 14 Dec 2002, Grant Cooper wrote:
> Mysql works on port 3306 by default.
>
> for example, my mysql server is on 10.10.10.1 so you would use this command
> to test your mysql server.
>
> telnet 10.10.10.1 3306
>
> yo
Mysql works on port 3306 by default.
for example, my mysql server is on 10.10.10.1 so you would use this command
to test your mysql server.
telnet 10.10.10.1 3306
you will get special garbage or host not allowed if testing a remote server.
But at least you know your mysql server is open.
You co
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sun, 8 Dec 2002, shawn xu wrote:
> We have an application software which uses MSSQL 7.0
> or 2000 server on Windows. Now we want to use the
> MSSQL as a master, and MYSQL on UNIX as a slave. How
> can we configure Windows MSSQL and UNIX MYSQL both
Did you read the Replicatoin Manual?
http://www.mysql.com/doc/en/Replication.html
At 09:15 PM 12/8/2002 -0500, shawn xu wrote:
We have an application software which uses MSSQL 7.0
or 2000 server on Windows. Now we want to use the
MSSQL as a master, and MYSQL on UNIX as a slave. How
can we confi
Once server 1 is down you should be able to set server 2 master and then
point dns to server 2 and all should be good for server 1 to come back as
slave.
If you did not set server 2 as slave it would still work as a master the
only problem is how to point the questions to server 2! Dynamic DNS?
Si
On Mon, Nov 25, 2002 at 06:02:19PM -0600, Andy Bakun wrote:
> I have successfully configured two mysql instances to replicate to each
> other (According to /doc/en/Replication_Features.html, it is possible to
> do it in a A->B->C->A relationship, but I only did it with two servers
> and I don't hav
puckman,
Thursday, November 28, 2002, 12:46:15 PM, you wrote:
patdc> A website we recently built contains a highscore table. People play a game, and
can then submit their name and score to the table.
patdc> When viewing the table, I then need to rank the scores using an "order by"...
However si
NEWEST**
I am now getting this error while trying to Replicate to a second MySQL
server.
021125 0:41:01 Slave: Failed reading log event, reconnecting to retry, log
'bsd1-bin.001' position 73
021125 0:41:01 Slave: reconnected to master
'[EMAIL PROTECTED]:3306',replicatio
On Friday 22 November 2002 17:19, RAHARD Matthieu wrote:
> I set up replication on my servers since the version 3.23.43. Recently I
> upgrade all my servers to version 4.0.3.
> The replication work fine for insert and delete queries (also alter table)
> but doesn't take care of update queries.
re
Jeremy Zawodny wrote:
I hate to ask this, bug did you change anything? :-)
In the data? Heck ya :-) ... the versions of the software? No --
although either of them has restarted / flushed logs from time to time
as necessary (I don't have a log rotation program yet for the binary
logs mind
On Mon, Nov 18, 2002 at 11:47:48AM -0500, Michael T. Babcock wrote:
> Any suggestions? This is a live DB ...
>
> 021118 10:43:47 InnoDB: Started
> /usr/libexec/mysqld: ready for connections
> 1254 021118 10:43:49 Slave: connected to master
> '[EMAIL PROTECTED]:3303', replication started in lo
That was meant to read 'the slave position has NOT updated since the last
upgrade.' Sorry =/
Quoting [EMAIL PROTECTED]:
> Hello,
>
> A while back I upgraded our slave mysql database from 3.23 to 4.04, it
> accepted replication coming from a 3.23 machine fine for several weeks. Last
>
> night
Jon,
- Original Message -
From: "Jon Frisby" <[EMAIL PROTECTED]>
To: "'Heikki Tuuri'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, November 09, 2002 12:17 AM
Subject: RE: Replication and temp tables...
> Hrm, upon furt
into that table that happen each day...
-JF
> -Original Message-
> From: Heikki Tuuri [mailto:Heikki.Tuuri@;innodb.com]
> Sent: Friday, November 08, 2002 12:22 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Replication and temp tables...
>
>
> Jon,
>
>
Jon,
- Original Message -
From: ""Jon Frisby"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, November 07, 2002 9:39 PM
Subject: Replication and temp tables...
> Using 4.0.2 for both server and client, replicating the following query
> seems to have caused a crash
Jon,
- Original Message -
From: ""Jon Frisby"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, November 07, 2002 9:39 PM
Subject: Replication and temp tables...
> Using 4.0.2 for both server and client, replicating the following query
> seems to have caused a crash
Alexander,
Friday, November 01, 2002, 9:48:50 PM, you wrote:
AB> I did the configuration below but the server doesn´t make the replication.
AB> I tryed some commands.
AB> start/stop slave
AB> status master
AB> but they didn´t.
AB> What else do I have to do?
Is there anything in the error log?
]>
> To: "Alexander Burbello" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Thursday, October 31, 2002 9:33 PM
> Subject: Re: Replication
>
>
> > On Thu, Oct 31, 2002 at 05:02:49PM -0300, Alexander Burbello wrote:
> > > I am try to make rep
On Thu, Oct 31, 2002 at 05:02:49PM -0300, Alexander Burbello wrote:
> I am try to make replication between two servers.
>
> I configurated the master and slave servers with the follow parameter in
> my.ini
>
> MASTER
> server-id=1
>
> SLAVE
> master-host=
> master-user=
> master-password=
> mast
Okan,
Thursday, October 17, 2002, 3:33:41 PM, you wrote:
OC> I am working on the replication feature of MySQL. I am managed to replicate
OC> the servers(both versions are 3.23.52 on Win 2K). Ay yhe my.ini file, the
OC> bin-log files are declared as log-bin=c:\mysql\log_files.bin and as I FLUSH
OC>
Have you looked at using the Microsoft DTS tool with the MyODBC? Setting
this up should be straightforward.
I hope this helps
-Original Message-
From: Gator [mailto:gator@;acs.bz]
Sent: Tuesday, October 29, 2002 12:34 PM
To: [EMAIL PROTECTED]
Subject: Replication from MS SQL to MySQL
Do
The only thing that is not published to the replication logs are 'flush'
statements.
-Original Message-
From: Jeremy Zawodny [mailto:Jeremy@;Zawodny.com]
Sent: Monday, October 28, 2002 1:00 PM
To: Michael T. Babcock
Cc: '[EMAIL PROTECTED]'
Subject: Re: Replication and
On Mon, Oct 28, 2002 at 12:17:20PM -0500, Michael T. Babcock wrote:
> Say I have a database that is being properly replicated to
> another server and I want to alter it on both machines (say, add a new
> column). Will this also be sent with the SQL update log to the second
> server, or must I d
On Thu, Oct 24, 2002 at 12:14:44PM +0530, Akash wrote:
> Hi,
> I have prepared a RING Architecture in MySQL using three MySQL servers.
> I name these MySQL servers as A, B and C.
> My configuration is like this :
> A is the Master to B, B is the Master to C, and C is the Master to A.
>
> I set up two-way replication with two servers, A and B.
> Since all queries go to only one server, it seems not to matter.
>
> Anyway.
>
> When A starts it registers itself to B, and vice versa.
> I thought query "SHOW SLAVE HOSTS" to A should shows only about
> B and B should do about A, but bot
- Original Message -
From: "walt" <[EMAIL PROTECTED]>
To: "Lewis Watson" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, October 22, 2002 2:08 PM
Subject: Re: Replication Error
> Lewis Watson wrote:
>
> > A
;Jeff Kilbride" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Lewis Watson" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, October 22, 2002 2:45 PM
Subject: Re: Replication Error
> RESET MASTER
> RESET SLAVE
>
> Thi
t;mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, October 22, 2002 12:08 PM
Subject: Re: Replication Error
> Lewis Watson wrote:
>
> > Also, I am intersted in a way to reset the entire replication thing. In
> > other words, just remove all hints of replication an
Lewis Watson wrote:
> Also, I am intersted in a way to reset the entire replication thing. In
> other words, just remove all hints of replication and start over... Is there
> a way I can do this?
> Thanks.
> Lewis
>
> - Original Message -
> From: "Lewis Watson" <[EMAIL PROTECTED]>
> To: "m
Also, I am intersted in a way to reset the entire replication thing. In
other words, just remove all hints of replication and start over... Is there
a way I can do this?
Thanks.
Lewis
- Original Message -
From: "Lewis Watson" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesd
> Lothar Jenisch wrote:
>
> >Hello,
> >
> >I have a problem with replication and LOAD DATA INFILE.
> >I use version 3.23.37 on Liunx distribution.
> >
> >1. I check the replication with a manual i.e. insert and
> > delete of one record. This works fine without problems.
> >2. I do a
> > LOA
Lothar Jenisch wrote:
>Hello,
>
>I have a problem with replication and LOAD DATA INFILE.
>I use version 3.23.37 on Liunx distribution.
>
>1. I check the replication with a manual i.e. insert and
> delete of one record. This works fine without problems.
>2. I do a
> LOAD DATA INFILE 'file.
CP,
Tuesday, October 01, 2002, 11:29:30 AM, you wrote:
C> I stopped both mysql in master and slave. Then I put in the server id for
C> both master and slave, start the master then the slave. Is it okay?
Yes.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This ema
CTED]>
Sent: Monday, September 30, 2002 10:37 PM
Subject: re: Re: Re: Replication
> CP,
> Monday, September 30, 2002, 3:48:31 AM, you wrote:
>
> C> The Master's server id is 1 while the slave's server id was set to 5.
There
> C> is no problem for the slave to establ
CP,
Monday, September 30, 2002, 3:48:31 AM, you wrote:
C> The Master's server id is 1 while the slave's server id was set to 5. There
C> is no problem for the slave to establish connection to the master. However,
C> the slave complains that error reading packet from server, the reason is
C> misco
That would be a great way to keep your website up to date.
The slave can handle loss of connection (though some data may not make sense if part
of it is missing), and resume where it has left of previously.
Or you could also manually start and stop the slave process when you know there is a
li
Alexander,
Saturday, September 28, 2002, 12:47:19 PM, you wrote:
AS> Is it feasible to use replication to keep the database which powers my
AS> website up-to-date? The database itself is on the hosting companies server
AS> and contacted via dialup so the connection isn't there all of the time.
AS
t and this messages keep on
repeating.
Any idea?
Thanks,
Chee Peng
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 27, 2002 9:16 PM
Subject: Re: Re: Replication
> Hello CP,
> Friday, September 27,
Hello CP,
Friday, September 27, 2002, 3:11:14 AM, you wrote:
C> hi Victoria, thanks for the reply. I have set server id in the very
C> beginning, but its still not working. I don't understand why the MySQL would
C> not let me change its server id accordingly. The server id was set to 1.
You must
CP,
Thursday, September 26, 2002, 11:00:10 AM, you wrote:
C> I am trying to do a master-slave replication on mysql-3.23.42. My master is
C> sitting on a FreeBSD machine and the slave is running in a Red Hat Linux 7.1
C> machine.
C> From the log, the master-slave connection is okay, but the slave
Piasecki
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 24, 2002 8:34 AM
To: [EMAIL PROTECTED]
Subject: re: replication problem
David,
Monday, September 23, 2002, 6:03:58 PM, you wrote:
DP> We are having a problem which seems to h
David,
Monday, September 23, 2002, 6:03:58 PM, you wrote:
DP> We are having a problem which seems to have appeared recently with
DP> replication on our mysql servers.
DP> - We have 3 servers set up with mysql 3.23.52 (they were running .49 but
DP> we upgraded in an attempt to fix this problem,
701 - 800 of 1084 matches
Mail list logo
