On Thu, Jul 12, 2001 at 04:02:23PM -0700, Joe Taraba wrote:
> Jeremy;
>
> I've been following this thread, and what I am unclear about is why
> would I want to use replication?
Sorry for the late reply.
> Forgive me, I am very new to MySQL, and my point of reference at
> this juncture of understanding is as a new administrator of a MySQL
> server used for webhosting customers.
Not a problem.
> I found the manual references to replication while searching for
> solutions for backing up customer databases. The manual said not to
> use update functions, but to use replication.
I'm not sure quite what that last part means. Can you point me to the
page in the manual which says that.
> I am running an older (3.22.32) version, so replication is not
> available to me, nor is mysqlhotcopy. I am trying to talk my boss
> into upgrading our version. Presently, he feels that doing a
> periodic tar of the /var/lib/mysql directory is adequate, and that
> the customers should do a periodic mysqldump for their own
> protection.
That is probably sufficient for your needs. As long as your customers
know your backup policy, I suppose.
> Can you help me convince him to use replication, why replication is
> superior to what he is presently doing?
Replication is done in real-time. If you database server fails, the
replica will be just that--a replica of the data as it existed on the
master server before it died.
> He is of the mind; "If it ain't broke, don't fix it!!"
I can understand that, but it's also important to realize that
3.22.32, while stable, is old and quickly becoming unsupported. If
you run into a problem, the first response that you're likely to get
is "upgrade to the latest 3.23.xx and let us know if you can repeat
the problem".
You'll probably find that 3.23.xx is faster and just as stable. Plus,
your customers can take advantage of some of its new features if they
need/want them.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 <-- NEW
MySQL 3.23.29: up 31 days, processed 237,106,556 queries (87/sec. avg)
---------------------------------------------------------------------
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
