l i n u x - u s e r s - g r o u p - o f - d a v i s
Next Meeting:
July 7: Social gathering
Next Installfest:
Latest News:
Jun. 14: June LUGOD meeting cancelled
Page last updated:
2009 May 12 14:21

The following is an archive of a post made to our 'vox-tech mailing list' by one of its subscribers.

Report this post as spam:

(Enter your email address)
Re: [vox-tech] NIS and MySQL migration
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [vox-tech] NIS and MySQL migration


I haven't done this personally, but depending on the version of mysql  
you are running, you may be able to bring up a second mysql database  
as a slave, replicate all the data to the slave and then promote that  
slave to be master. Something to check out for sure.


On May 12, 2009, at 10:47 AM, Ken Bloom wrote:

> About a year ago, I inherited system administration of my research
> lab's 4 linux workstations from the previous student who was leaving
> to take a job at Google. The 4 machines ran Gentoo, and maintenence
> (particularly upgrades) was a pain becuase upgrades would need to be
> nursed along, taking days of my time, and having very brittle
> dependency logic. I have been crossgrading the machines to Debian
> stable since Lenny's release, and have now moved 3 of the 4 machines.
> The fourth machine, which I haven't touched yet, runs a MySQL
> database, and is the NIS server for the other three machines. I now
> need to upgrade these machines subject to 3 constraints:
> 1. The mysql database must not be lost, and I must be able to move the
> data reasonably quickly. (Downtime is OK since it's not public facing,
> and gets sporadic use, but forcing me to dump/reload would be a royal
> pain because one of the databases contains 15GB of linguistic data.)
> 2. The login information from the NIS server must not get lost.
> Creating new accounts, or asking users to recreate their passwords
> would be BAD.
> 3. The NIS server must be moved over without creating downtime on the
> other lab machines. (This is a problem because if I have to disconnect
> one of the machines from the network, as I had problems with Network
> Manager last week, it becomes difficult to do anything to fix the
> machine because the machine can't contact its authentication server.)
> Is there a way to move the MySQL server without dumping/reloading?
> Is there a way to replicate the the logins and passwords from the NIS
> server to the other machines in the lab so that the machines are still
> useful if the NIS server is unreachable? (Ideally I'd like to use
> relatively standard tools for this, and have this replication be an
> ongoing process.)
> --Ken
> _______________________________________________
> vox-tech mailing list
> vox-tech@lists.lugod.org
> http://lists.lugod.org/mailman/listinfo/vox-tech
vox-tech mailing list

LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
LUGOD Group on Facebook
'Like' LUGOD on Facebook:

Hosting provided by:
Sunset Systems
Sunset Systems offers preconfigured Linux systems, remote system administration and custom software development.

LUGOD: Linux Users' Group of Davis
PO Box 2082, Davis, CA 95617
Contact Us

LUGOD is a 501(c)7 non-profit organization
based in Davis, California
and serving the Sacramento area.
"Linux" is a trademark of Linus Torvalds.

Sponsored in part by:
EDGE Tech Corp.
For donating some give-aways for our meetings.