Our NT enterprise backup solution offers Unix client software to
stream
to an NT tape, but there is a very viable open source solution, SAMBA.
Samba makes a UNIX machine a very good facsimile of (perhaps better
then?)
NT. Samba share a directory from UNIX, dump MySQL tables there, use said
directory
SMB mounted on NT machine with tape, run backup. Samba 2.0.4 actually has
the ability
to map UNIX<->NT ACL's.
As for performance, I'm running Samba on a Solaris x86 Dual PPro 200
Dell
PowerEdge 4100 server with 128 MB RAM and Ultra-Wide SCSI hardware RAID 5.
In addition
to Samba file and print services, this machine is my MySQL server, is
running Oracle,
Apache/PHP3, NFS File services, lp print services, and is a router.
Despite all of this load (I know, I know . . . I need RAM
desperately ;) this machine
runs NetBench with a 20 client simulated load nearly half again faster then
a similar machine
running NT file and print services (and nothing else) with 256 MB RAM.
I can't complain!
John
> -----Original Message-----
> From: sinisa@stripped [SMTP:sinisa@stripped]
> Sent: Wednesday, July 28, 1999 5:50 AM
> To: vanboers@stripped
> Cc: mysql@stripped
> Subject: Re: the best way to back up...
>
> Van writes:
> > sinisa@stripped wrote:
> > >
> > > Denis Voitenko writes:
> > > > I am in a process of moving four databases from Access to MySQL.
> The Linux
> > > > box that I am moving the database to has no backup device except a
> floppy
> > > > drive :-) so I've been thinking about copying files nightly to a
> NT server
> > > > that has a tape drive over SMB. Now, which files would I need to
> backup? Do
> > > > I mysqldump the databases before I back them up?
> > > >
> > > > Denis Voitenko
> > > > denis@stripped
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > > Try to run mysqldump (with -e and -q options at least) through gzip
> > > stream to the tape.
> > >
> > > I never heard that tape devices can be exported by Windoze .......
> > >
> > > There are other methods.
> > >
> > > Sinisa
> > Another thought: Hook up to the MySQL dbase through ODBC from the NT
> > box via Access, do a mysqldump, and use WinAT to backup up the Access
> > DBase. Not very elegant, but, in lieiu of a UNIX solution, this should
> > provide something somewhat adequate. I'm currently replicating MySQL to
> > MSSQL 6.5 over ODBC to an NT Server that backups to Tape. Much
> cleaner,
> > but, Access should suffice.
> > Regards,
> > Van
>
>
> Hi Van!
>
> Very cute solution.
>
> There are better ones:
>
> 1. NT backup software accepts streams (why not ?). You than run
> mysqldump from NT, through gzip to backup software.
>
> 2. NT backup software has a client for Linux (why not ?). You run
> mysqldump on linux through gzip to backup client on Linux.
>
> 3. You transfer tape device to Linux. The best solution !!!! You do
> backups on Linux with a pleasure, and on NT you run some backup
> client, like BRU or some other, there are a few around,, for example.
>
>
> Sinisa
>
> +----------------------------------------------------------------------+
> | TcX ____ __ _____ _____ ___ == mysql@stripped |
> | /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
> | /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped|
> | /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus |
> | /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
> | ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
> | /*/ \*\ Developers Team |
> +----------------------------------------------------------------------+
>
