BMail mailinglist
Subject: Re: SV: SV: [Dbmail] mirroring dbmail mySQL database
On Wed, Apr 28, 2004 at 11:32:23AM +0200, Jocke wrote:
> If you want to set it all up, just make sure you start an update-log
on your
> master server and connect the slave to it.. then if you're running
mysql 4.0
Hi,
From what I have read is MySQL cluster really fast. It is geared
toward telecom applications. There is only one drawback, the
complete database currently resides in the computer RAM.
Magnus
Christian G. Warden wrote:
On Wed, Apr 28, 2004 at 11:32:23AM +0200, Jocke wrote:
If you want t
Thanks Jocke and Christian for your reply, I appreciate it.
I tried "mysqldump --opt dbmail > backup-dbmail.sql" to backup the
dbmail and restore the database to the temporary server using "mysqldump
--opt dbmail > backup-dbmail.sql" but it errors with the error message:
ERROR 1064 at line 37
On Wed, Apr 28, 2004 at 11:32:23AM +0200, Jocke wrote:
> If you want to set it all up, just make sure you start an update-log on your
> master server and connect the slave to it.. then if you're running mysql 4.0
> or higher just issue the command "LOAD DATA FROM MASTER;" and the slave will
> becom
There is no problem mirroring databases between innoDB and MyISAM because
all the really happens is that the slave runs the same queries as the master
does.
When replicating from innodb to MyISAM you will have no problem at all and
you often gain some speed, which means that you have the safety of
