Inbal,

a "snapshot" is simply a backup of the database at a well defined point
in time. A snapshot is essential for replication to work. Master and
slave are supposed to start with exactly the same set of data
("snapshot") in the beginning.

There are several ways to create a snapshot on the master and copy this
snapshot to the slave. If you can afford to take the master server down
for a moment, one convenient way to do this is:

(After having configured the master and slave for replication, i.e.
switching on the binlog etc.)
1. Take the master server down.
2. Copy the database(s) you want to replicate to the <datadir> of the
slave server.
3. Restart master and slave.

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

----- Original Message -----
From: "Inbal Ovadia" <[EMAIL PROTECTED]>
To: "'Stefan Hinz, iConnect (Berlin)'" <[EMAIL PROTECTED]>; "Inbal
Ovadia" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, February 03, 2003 12:43 PM
Subject: RE: database mirroring in mysql


Hi and thanks for the reply.
After I read all about replication, I have a little question.
In section 4.10.3 How To Set Up Replication, in step 3 it is written
"and
then take a snapshot of the data on your master server".
I am working on windows 2000 and I don't understand, how do I do the
snapshot???
And another thing. Before I am doing all this steps, do I need to create
the
slave database?
where do I need to create it?

Thanks


-----Original Message-----
From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 03, 2003 12:29 AM
To: Inbal Ovadia; [EMAIL PROTECTED]
Subject: Re: database mirroring in mysql


Inbal,

> Is there a possibility, in MySql, to define a "mirror" to my database,

Yes. In MySQL, it's called "replication", and it's quite easy to setup.

More info: http://www.mysql.com/doc/en/Replication.html

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

----- Original Message -----
From: "Inbal Ovadia" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, February 02, 2003 4:56 PM
Subject: database mirroring in mysql


> Hi all,
> Is there a possibility, in MySql, to define a "mirror" to my database,
> meaning that I define another database that will be a copy of my
database
> and every operation that I will make on my database, will be done
> automatically in the second database?
>
> Or if I define database that contain only part of the tables in my
database
> and when I will do some operations on one of those tables, the
operations
> will be done in the second database?
>
> Thanks, Inbal
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to