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:
Yes. I also tried that. Are there any other suggestions?
What's about the different sections in my.cnf?
Should these statements beeing written under [mysqld_safe], too?
Victor Pendleton wrote:
In the slave's my.cnf have you tried just expliciting statement what tables
to ignore?
replicate-ignore-t
In the slave's my.cnf have you tried just expliciting statement what tables
to ignore?
replicate-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:
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
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
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
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:
>
> MySq
: 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:
>
> MySql: ready for conne
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,
> try this :
>
>
hi,
try this :
mysql > SHOW MASTER STATUS;
+--++--+--+
| File | Position | Binlog_do_db | Binlog_ignore_db |
+--++--+- +
| some-file| XX | | |
> 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
Dear Soenke,
> 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!
Before you go crazy, check if the slave (user) has sufficient privileges.
Let's
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
23 matches
Mail list logo
