[TriLUG] MySql replication

Shawn Hood shawnlhood at gmail.com
Thu Jul 6 21:21:05 EDT 2006


The good news for you is that the MySQL documentation on replication
is excellent.  MySQL docs seem to be pretty well written.

On 7/6/06, Rick DeNatale <rick.denatale at gmail.com> wrote:
> On 7/6/06, Shawn Hood <shawnlhood at gmail.com> wrote:
> > It's been a while for me, but it's pretty easy, and works well.  I
> > think there are several tools out there that take snapshots of hot
> > MyISAM data without any problems.  I think they do this by utilizing
> > the binary log that MySQL creates if the option is enabled.  There is
> > some overhead associated with enabled the binlog.
>
> mysqlhotcopy perhaps?
>
> Most of the tables in my databases are myisam, mostly because when I
> got started on an old redhat system, I don't think that innodb was
> supported.  I have been thinking of converting most of the tables for
> my mediawiki database to innodb (one is a text search index and needs
> to be in myisam).
>
> > You can freeze the database using "flush tables with read lock"  and
> > copy the hierarchy over as long as the data file format is the same
> > among the versions of MySQL on the master and slave.  There is some
> > info out there about this.  Another option is to run mysqldump
> > (--all-databases?) > dumpfile.sql, and load that file using the mysql
> > utility on the slave.  There is also a command that will sync the
> > master and slave, starting from scratch.  This takes quite some time
> > on a large database.  I've had the best experience copying over the
> > file hierarchy and keeping the versions of MySQL similar.
> >
> > You will need to modify my.cnf, get the data moved, and then issue a
> > START SLAVE *AFTER* you issue some other commands telling the slave
> > what relay log to use, the offset, and authentication info, etc.
> >
> > There is plenty of good information available on the web on this as
> > well.  I consumed a lot of it when I was a db admin.
>
> I'd love to get pointers to good ones, I tend to read a lot of how-tos
> on things like this before I act.
>
>
>
> --
> Rick DeNatale
>
> IPMS/USA Region 12 Coordinator
> http://ipmsr12.denhaven2.com/
>
> Visit the Project Mercury Wiki Site
> http://www.mercuryspacecraft.com/
> --
> TriLUG mailing list        : http://www.trilug.org/mailman/listinfo/trilug
> TriLUG Organizational FAQ  : http://trilug.org/faq/
> TriLUG Member Services FAQ : http://members.trilug.org/services_faq/
>


-- 
Shawn Hood
(910) 670-1819 Mobile



More information about the TriLUG mailing list