[HyperDB] upgrading from normal database to HyperDB...
Beau Lebens
beau at dentedreality.com.au
Wed Jun 6 05:24:01 GMT 2007
Jeremy - try doing a "SHOW SLAVE STATUS\G" (run this on the slave) to
get details on it's status. Especially look for these lines;
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
You'll also want to check a "SHOW MASTER STATUS;" on the master, to
make sure it's doing the right thing.
That raises the question - did you definitely enable "logging" on the
master? because that needs to be on to get replication going. I have
this for my master;
log-bin=mysql-bin
HTH
Beau
(who's dealt with ugly, ugly MySQL replication for work :)
On Jun 5, 2007, at 8:07 PM, Jeremy Visser wrote:
> Matt Mullenweg wrote:
>> Jeremy Visser wrote:
>>> How long does the replication take? I waited a good few hours, and
>>> whatever tables I created, or rows I adjusted were not carried over.
>>
>> Well you have to copy the data over first, then start replication,
>> and
>> it is usually instant.
>
> I stopped my web server, did an SQL dump from the source, imported it
> into the destination server, did all the copying the log file names
> and
> all that, and ran START SLAVE; but nothing happened.
>
> I guess I'm too n00by to follow directions. :-D
> _______________________________________________
> HyperDB mailing list
> HyperDB at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/hyperdb
More information about the HyperDB
mailing list