MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Biju Chacko Date:May 27 2003 2:01pm
Subject:Copying Data Files vs. Replication
View as plain text  
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello:

I have to setup a backup mysql server. This need not be a real-time
backup - a sync twice or thrice a day would be fine.

The server's would (probably) be 3.23.52. The data is currently a mix of
MyISAM and InnoDB data.

After superficially reading the manuals I came to the conclusion that I
have two options for doing this:

* Copying/rsync-ing the data files across.

* Setting up replication.

I was told that copying the data files across may be problematic with
recent versions of mysql. Is this correct?

What kind of overhead does replication place on the master server?

If I am missing something obvious, pls note that I am a sysadmin not a
dba. ;-)

- -- b

- -- 
- -----------------------------------------------------------------------
Biju 'botsie' Chacko                        biju_chacko at vsnl dot net
http://www.symonds.net/~botsie          Public Key available on request
- -----------------------------------------------------------------------
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE+02++u9EABfMBafoRAoy0AJsGjJOQej3FM/di66FIp4dWJRfAFgCeOMyB
A3eWMazRs61IiG2azY8u6ic=
=Ozy4
-----END PGP SIGNATURE-----
Thread
Copying Data Files vs. ReplicationBiju Chacko25 May
  • Select * where timestamp older than x daysScott Haneda26 May
    • Re: Select * where timestamp older than x dayscolbey26 May