The test box doesn't have incoming data when he's taking the snapshot. Lock
the production database while taking snapshot and setting up replication or
you will have this problem. I've tried all the methods (snapshot, dump,
hotcopy etc) and the issue is always the same. You can't bootstrap
replicat
If it worked on your test box, but not in production, what is
different about those 2 boxes? Common sense says "If it worked on one
box but not another, it's not the software, but a difference between
the 2 boxes."
And you can always file a bug report with MySQL or get a consultant
(through MySQ
It seems nobody has a clue here :(
I've given up with MySQL replication...
Hope it will work in 5.1 ...
BTW: Any official info or estimate about the production release?
Bgs wrote:
Nope... pure myisam...
sheeri kritzer wrote:
yeah, I'd be willing to guess that you're mostly innodb. LOAD DA
sheeri kritzer wrote:
yeah, I'd be willing to guess that you're mostly innodb. LOAD DATA
FROM MASTER only works for MYISAM.
http://dev.mysql.com/doc/refman/5.0/en/load-data-from-master.html
-Sheeri
On 5/24/06, Dan Trainor <[EMAIL PROTECTED]> wrote:
Bgs wrote:
>
> No ideas?
>
> I tried playi
Nope... pure myisam...
sheeri kritzer wrote:
yeah, I'd be willing to guess that you're mostly innodb. LOAD DATA
FROM MASTER only works for MYISAM.
http://dev.mysql.com/doc/refman/5.0/en/load-data-from-master.html
-Sheeri
On 5/24/06, Dan Trainor <[EMAIL PROTECTED]> wrote:
Bgs wrote:
>
> No
Bgs wrote:
No ideas?
I tried playing around with read/write timeouts (even thought the
replication is fast), all size limits are greater than the whole
replicated db. The last table with accesses MYD and zero size is a small
one (a couple of dozens kBs).
Bgs wrote:
Greetings,
I played
No ideas?
I tried playing around with read/write timeouts (even thought the
replication is fast), all size limits are greater than the whole
replicated db. The last table with accesses MYD and zero size is a small
one (a couple of dozens kBs).
Bgs wrote:
Greetings,
I played around with
On Tue, 29 Mar 2005, Shamim Shaik wrote:
> Can I run load data from master on myisam tables where my table size is
> approx 30G?
>
> Is there a better way to do this ?
Hi,
1) LOAD DATA FROM MASTER: From the manual:
" It acquires a global read lock on the master while taking the
snapshot,
On Tuesday 29 March 2005 11:44, Shamim Shaik wrote:
> I cannot stop or lock tables on the master webapps write data to it
> constantly.
>
> I am copying over the binlogs and applying them to the slave.
>
> It is taking a long time so I just want to know if load data or copying
> tables over would b
On Tuesday 29 March 2005 11:26, Shamim Shaik wrote:
> Can I run load data from master on myisam tables where my table size is
> approx 30G?
- stop slave
- on master do:
- lock tables
- tar cpf - /var/lib/mysql/tbl | ssh -C slave tar xpf - -C /var/lib/mysql/tbl
- start slave
- on master again:
-
I cannot stop or lock tables on the master webapps write data to it constantly.
I am copying over the binlogs and applying them to the slave.
It is taking a long time so I just want to know if load data or copying tables
over would bring replication back to where it is.
I
Renato Golin <[E
11 matches
Mail list logo
