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
On Thu, Jun 21, 2007 at 01:12:19PM +0200, Christian Parpart wrote:
> this statement indeed is a feature.
> but why has it been marked obsolete?
>
> it would be sooo easy instanciate master-slave replication.
It's marked obsolete because it doesn't really work well (such as only
supporting MyISAM)
Hi all,
this statement indeed is a feature.
but why has it been marked obsolete?
it would be sooo easy instanciate master-slave replication.
Regards,
Christian Parpart.
signature.asc
Description: This is a digitally signed message part.
Hello List,
Has anyone seen any problems using LOAD DATA FROM MASTER on a second slave
using a secondary network interface?
I have:
mysql-master / {172.25.7.20 / eth0, 192.168.7.20 / eth1} / Red Hat EL V.4 /
MySQL 5.0.22
mysql-slave1 / 172.25.1.58 / Windows XP / MySQL 5.0.18
mysql-slave2
k 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 DATA
>> FROM MASTER only works for MYISAM.
&
> 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 load data from maste
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:
>
>
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:
B
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 tr
played around with load data from master (ldfm) and it worked fine
in test environment. Now I want to replicate our actual db to a slave.
When I issue the ldfm command, it starts the replication. I get Query
OK, but only about 5% of the db is replicated. Apparently all tables
that are on the slave in
load data from master (ldfm) and it worked fine in
test environment. Now I want to replicate our actual db to a slave. When
I issue the ldfm command, it starts the replication. I get Query OK, but
only about 5% of the db is replicated. Apparently all tables that are on
the slave in the end are
Greetings,
I played around with load data from master (ldfm) and it worked fine in
test environment. Now I want to replicate our actual db to a slave. When
I issue the ldfm command, it starts the replication. I get Query OK, but
only about 5% of the db is replicated. Apparently all tables
LOAD DATA FROM MASTER only works for MyISAM tables. Is
tracking.session an InnoDB table?
-Sheeri
On 5/4/06, Hunter Peress <[EMAIL PROTECTED]> wrote:
Hi. im trying to add a second slave using load data from master ,and
it seems to me that when i run this command on the
new slave th
Hi. im trying to add a second slave using load data from master ,and
it seems to me that when i run this command on the
new slave that its simply picking up from where the first slave is
replicating from. Does this make sense? Also interesting is that
when both the IO and SQL threads are No on
It would appear that LOAD DATA FROM MASTER processes databases and
tables alphabetically. When a merge table is being copied, and it's name
is alphabetically before some/any/all of it's components, the process
fails with a 1017 couldn't find file error.
Has this been fixed? If
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 ta
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
<[EMAIL PROTECTED]> wrote:
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
-
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 ?
-
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
t;[EMAIL PROTECTED]> wrote:
> Hi! I never saw a follow-up to the post about SHOW SLAVE STATUS
> hanging while LOAD DATA FROM MASTER is running as of about 4.0.20 on.
> (<http://lists.mysql.com/mysql/167238>)
>
> Is this a known bug? Or a feature?
>
> thanks!
Hi! I never saw a follow-up to the post about SHOW SLAVE STATUS
hanging while LOAD DATA FROM MASTER is running as of about 4.0.20 on.
(<http://lists.mysql.com/mysql/167238>)
Is this a known bug? Or a feature?
thanks!
chris
--
MySQL General Mailing List
For list archives
eload
* File
* Super
* Execute
* Replication client
* Replication slave
Now, if want to set up a new slave following these steps:
* Start mysql on the slave
* Run the following command to set up my slave LOAD DATA FROM MASTER;
Nothing happens ?.
What is going wrong ?
Than
TMD temporary table file, and the .MYD
> data file disappeared altogether. I did STOP SLAVE; RESET SLAVE; LOAD
> DATA FROM MASTER; and it reloaded the 18 replicated tables from the
> production server. However, it also wiped out the other 44 tables that
> existed on the dev server.
>
SLAVE; LOAD
DATA FROM MASTER; and it reloaded the 18 replicated tables from the
production server. However, it also wiped out the other 44 tables that
existed on the dev server.
I looked at the manual page for the LOAD DATA FROM MASTER command
(http://www.mysql.com/doc/en/LOAD_DATA_FROM_MASTER
shoutcast_manager
1 test
1097vbulletin
new install of 4.0.1 solaris sparc 7 binary, correctly configured for
slave operation. repl user given all rights to all dbs, since load
master does not appear to work with only file privelege activated
(update docs?). running LOAD DATA FROM MASTER
26 matches
Mail list logo
