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
(Bmissu
so, for having
a complete database-status view .
Best regards
Peter
- Original Message -
From: "Mike Lohmann" <[EMAIL PROTECTED]>
To: "Victor Pendleton" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, September 13, 2004 11:49 AM
Subject:
ate-ignore-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
repl
Sent: 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.
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 pc-linu
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
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 s
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.
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
Hi,
mysqlbinlog -j | mysql
works fine. I used -o instead of -j before. So I answered my last
question. When doing this:
mysqlbinlog -j | more
I see that it had advanced to the query after the one with the problem
in the trace file. In fact, the query succeeded and was there after a
REPAIR T
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 | mysql
to get the slave more up to date (without having the slave SQL thread
running)? I tried the above but the from 'show slave
status' seemed w
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
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
Today I added --myisam-recover=FORCE,BACKUP,QUICK
However, replication seems to not honor that setting.
I have a master that can average 7000qps and last forever, and a slave
that can only last 12 minutes at 1/10 the qps. :(
Next, I guess, is to download the debug version from MySQL and see what
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
simil
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
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 err
: RE: 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 <[
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:
>
#x27;,
> MASTER_LOG_POS=XX;
>
> then restart the slave.
>
> -Message d'origine-----
> De : Natale Babbo [mailto:[EMAIL PROTECTED]]
> Envoyé : jeudi 12 décembre 2002 16:27
> À : [EMAIL PROTECTED]
> Objet : Fwd: problem with replication
>
>
> Any sugge
ine-
De : Natale Babbo [mailto:[EMAIL PROTECTED]]
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
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,
>
&g
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:
> 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 sa
t.de>
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "Sönke Ruempler" <[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 to master machine, it works!
going crazy .. both mysqld's are 3.23.53 !
what is going wrong here ahh?
regards, soenke.
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 PROTECTED]:3306',replic
errors were there before i tried
to set up replication.
Rick
**
Server Administrator [Linux - FreeBSD]
Websites: www.shellz.nl www.tweakers.net
ICQ#: 37416519
E-mail: [EMAIL PROTECTED], [EMAIL PROTECTED]
**
> -Original Message-
> From:
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
CTED]
**
> -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 a
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
> use
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: 'repl@athena' (Using password: YES)(0), retry in 60 sec
When i try to connect "manu
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:
01020
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 erro
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=
master-user=
master-password=
log-slave-updates
Server2 has:
log-bin=/var/lib/mysql/binary_log
master-host=
master-user=
master-pas
35 matches
Mail list logo