Hi Dana,
(B
(Bthe tool might be free for developers, but is it also Open source ??
(BDoes it solve the issues described by the threat owner ?
(BIf not, can the owner easily adapt it to solve his problems with it ?
(B
(BI am just adding this question, to make it not look like your are
-table=db.table1
replicate-ignore-table=db.table2
...
replicate-ignore-table=db.tablen
And remove the other statements?
-Original Message-
From: Mike Lohman
To: [EMAIL PROTECTED]
Sent: 9/10/04 10:53 AM
Subject: Problem with Replication - Slave Option replicate-ignore-table and
replicate-wild
- Original Message -
From: Mike Lohmann [EMAIL PROTECTED]
To: Victor Pendleton [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, September 13, 2004 11:49 AM
Subject: Re: Problem with Replication - Slave Option replicate-ignore-tabl e
and replicate-wild-ignore-table
Yes. I also
Hi,
I've got a running Master-Slave environment with 8 Slaves and 1 Master.
The problem is not the replication itself, but to exclude some tables out of
it. Excluding databases runs without problems. All server are of the same
version:
mysql --version
mysql Ver 12.22 Distrib 4.0.18, for
: 9/10/04 10:53 AM
Subject: Problem with Replication - Slave Option replicate-ignore-table and
replicate-wild-ignore-table
Hi,
I've got a running Master-Slave environment with 8 Slaves and 1 Master.
The problem is not the replication itself, but to exclude some tables
out of
it. Excluding
SQL
Hi!
Does anybody have any solution?
I change time where query run.
Each new day where query run first ones in day replication crash.
Slave start on slave server restore replication.
How can it be?
I have no any ideas.
Both servers have 4.0.16
SQL
Hi all!
Nearly very night I have this
SQL
Hi all!
Nearly very night I have this problem.
This query is done every 3 hours. But problem is happened only at 3:00
Both master and slave are 4 CPU (2 with HTT) computers.
Both have mysql 4.0.16
And when I test table analit. There are many records which have the same
conditions as in WHERE
I still have this problem with replication, and i dont know how to fix it.
I have a slave that has been running for a long time without any problems,
but now its not replicating any more. So I tried to do a LOAD DATA MASTER;
which always gives me this error now:
Version: '4.0.15-standard-log
Quick question: Are the binlog and relaylog files the same format?
Initial tests seem to indicate that they are the same. Can I use
mysqlbinlog -o Relay_Log_Pos Relay_Log_File | mysql
to get the slave more up to date (without having the slave SQL thread
running)? I tried the above but the
Hi,
mysqlbinlog -j Relay_Log_Pos Relay_Log_File | mysql
works fine. I used -o instead of -j before. So I answered my last
question. When doing this:
mysqlbinlog -j Relay_Log_Pos Relay_Log_File | more
I see that it had advanced to the query after the one with the problem
in the trace file. In
Hi,
And fixed.
Sorry for the waste of time. Only 4 days before I was set to replace the
disk the database was on, and it is going bad. :(
-steve-
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php
An update. I'm now running the debug version on the slave. I could not trace
out 'info' since it wrote way too much to the trace file.
What I did find that was unique when the table crashed is this:
handle_slave_sql: query: insert into forums_posts_new_3 (
w_search: error: Got errno: 0 from
Below is a trace (--debug=d,enter,exit,info,error,query,general,where:
O,/tmp/mysqld.trace) of the slave thread. This is the best I can do as
far as a bug report. No other queries were running and the slave I/O
thread was idle (I firewalled its connection to the master/rest of the
world).
Without
Hi all,
I have a problem with replication, that while repeatable for me very
easily, I can not come up with a way for others to repeat it without all
our tables and binlogs (tens of gigabytes). So I'm simply going to
describe things here and see if anyone else has experienced anything
similar
Now is ok ... thank you very much!
--- Jeremy Zawodny [EMAIL PROTECTED] ha scritto:
On Wed, Dec 11, 2002 at 05:03:51PM +0100, Natale
Babbo wrote:
Hi all,
I have a problem with replication between two
servers.
I created user repl on the master, I restored the
master's dump
On Wed, Dec 11, 2002 at 05:03:51PM +0100, Natale Babbo wrote:
Hi all,
I have a problem with replication between two servers.
I created user repl on the master, I restored the
master's dump on the slave, I changed both my.cnf
settings but I got this error from slave .err file:
MySql
On Wednesday 11 December 2002 18:03, Natale Babbo wrote:
I have a problem with replication between two servers.
I created user repl on the master, I restored the
master's dump on the slave, I changed both my.cnf
settings but I got this error from slave .err file:
MySql: ready
: problem with replication
Hi ... i have just tried by nothing's changed!
... i mean ... now in the show slave status i can
see the right master_log_filename, log_position etc.
but the error persists!
What's wrong? help me please!
Thanks and bye
--- Maxime LEMAIRE [EMAIL PROTECTED] ha
scritto: hi
Any suggestion about this error?
Thanks to all.
--- Natale Babbo [EMAIL PROTECTED] ha
scritto: Data: Wed, 11 Dec 2002 17:03:51 +0100 (CET)
Da: Natale Babbo [EMAIL PROTECTED]
Oggetto: problem with replication
A: [EMAIL PROTECTED]
Hi all,
I have a problem with replication between two
]]
Envoyé : jeudi 12 décembre 2002 16:27
À : [EMAIL PROTECTED]
Objet : Fwd: problem with replication
Any suggestion about this error?
Thanks to all.
--- Natale Babbo [EMAIL PROTECTED] ha
scritto: Data: Wed, 11 Dec 2002 17:03:51 +0100 (CET)
Da: Natale Babbo [EMAIL PROTECTED]
Oggetto: problem
: jeudi 12 décembre 2002 16:27
À : [EMAIL PROTECTED]
Objet : Fwd: problem with replication
Any suggestion about this error?
Thanks to all.
--- Natale Babbo [EMAIL PROTECTED] ha
scritto: Data: Wed, 11 Dec 2002 17:03:51 +0100
(CET)
Da: Natale Babbo [EMAIL PROTECTED]
Oggetto
Hi all,
I have a problem with replication between two servers.
I created user repl on the master, I restored the
master's dump on the slave, I changed both my.cnf
settings but I got this error from slave .err file:
MySql: ready for connections
021211 16:56:12 InnoDB: Started
021211 16:56:12
SHOW GRANTS FOR 'repluser'@'replmachine';
yes there is file grant on *.* - i used a simple password to avoid writing
it wrong. as i said, if i connect with mysql client tool from the slave
machine, i CAN login into the master server!
Only the slave can't login into the master server (with the
hello,
i wanna setup replication, everything works so far, but the slave
can'tconenct to the master, access denied. but if i connect with the 'mysql'
program from slave machine to master machine, it works!
going crazy .. both mysqld's are 3.23.53 !
what is going wrong here ahh?
regards,
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, November 24, 2002 11:53 AM
Subject: problem with replication
hello,
i wanna setup replication, everything works so far, but the slave
can'tconenct to the master, access denied. but if i connect with the
'mysql'
program from slave machine
After much stress, I finally found the answer to my problem. Here is the
error message that I was getting:
020322 11:54:29 Slave: Failed reading log event, reconnecting to retry, log
'bend149-bin.002' position 2407727
020322 11:54:29 Slave: reconnected to master
'[EMAIL
On Sun, Mar 11, 2001 at 06:16:22PM +0100, Rick Jansen - Tweakers.net wrote:
Hi there,
I'm trying to set up replication. But it's not working, for some
strange reason. This is the error out of the slave log: 010311
18:11:25 Slave thread: error connecting to master:Access denied for
user:
]
**
-Original Message-
From: Jeremy D. Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 11, 2001 8:09 PM
To: Rick Jansen - Tweakers.net
Cc: [EMAIL PROTECTED]
Subject: Re: Problem with replication
On Sun, Mar 11, 2001 at 06:16:22PM +0100, Rick Jansen -
Tweakers.net
On Sun, Mar 11, 2001 at 09:02:57PM +0100, Rick Jansen - Tweakers.net wrote:
Thanks for your time.
I disabled replication (slave stop), removed the master.info file
(it did contain a wrong/old password), stopped the mysqld
(mysqladmin -p shutdown), and restarted it (safe_mysqld ). The
]
**
-Original Message-
From: Jeremy D. Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 11, 2001 9:15 PM
To: Rick Jansen - Tweakers.net
Cc: [EMAIL PROTECTED]
Subject: Re: Problem with replication
Hmm...
Anything relevant in the server's error log?
--
Jeremy D. Zawodny, [EMAIL
It's amazing. Configuration is fine (same as our test machines here). We
are trying to use it on production machines now. These are the errors I
get:
010208 12:35:29 Slave thread: error re-connecting to master:Binary log
is not open, last_errno=0, retry in 0 sec
I also have got this one:
Greetings-
I have been experiencing an unusual issue with replication in 3.23.32. We
are using a dual-master setup on two FreeBSD4.2-STABLE machines. I am able
to initially set up the replication, and issue simple updates from one or
the other machine, but in certain circumstances we receive
Hi,
I'm running linux, mysql 3.23.32 (latest stable)
I have 2 servers running a circular master-slave.
Server1 has:
log-bin=/var/lib/mysql/binary_log
master-host=server 1 host
master-user=user
master-password=password
log-slave-updates
Server2 has:
log-bin=/var/lib/mysql/binary_log
33 matches
Mail list logo