Re: Moving dbs to new server
Posted by:
ed ziffel
Date: April 03, 2012 12:17PM
Mr James,
> The partition layout is different on the machines.
Elaborate.
In particular, if files are symbolically linked, then the table is ALTERed, the links may be lost and the table will move to a different location.
Old raid 0, 2 phsy drives, all lvm, mbr, individual partition for boot root usr home tmp var stor1(main archive) and svr (where the location of the data dir and mysqldbs/<mydatabases>)
New is raid 5, 5 phsy drives guid, (boot r1 r2 r3 r4) lvm on md0 -boot on small non-raid partiton dev/sda hardware issue could not boot to disk past /dev/sdb, using software raid. The mother board has all sata 3 ports recoginzed before sata 2 the sata connector for the OS drive, which was partitioned manually, swap, root, tmp, var, home, usr, mbr. Mysql data dir on r3.
chown (and maybe chmod) is needed after certain flavors of machine-to-machine copies. Also it depends on who you are when you tar/untar (or zip/unzip). I would use scp or netcat (nc), as root, to copy the files and not lose the ownership and permissions. tar/zip are not necessarily of much benefit if the machines are on a gigabit ethernet.
Will check that out. Noted that my net work only trasfered at under 10meg/sec. Have 100/10 equipemnt. 9 machines on lan. Switch box between old server (direct cable to router, lynksys 100/10), new behind switch box (supposedly 100/10). Other mnachines not active at transfer time.
OFF TOPIC: but hoping to sneak it in just this once.
Going to redo. Dumping Ubuntu for CentOS (redhat community enterprise edition), need current Amanda and Squid, ubuntu repositories are way out dated and no ppa for Ubuntu on Amada site. Options are deb and RPM. Also going with Fedora (redhat community). Also will probably go with latest community release of MySQL. Currently using 5.1.
1. Aside form lossing the ability to cut and paste the data dir, do you have an opinion with respect to the choice of Mysql, OS/Server, backup(Amanda) or Firewall/Proxy(Squid)? Am/will be setting up server for remote access as required. What would you use with the ceavet that it needs to be opensource. Even just "no, use a, b, c" would be tremdously helpful, no explaination needed.
2. Also SSL/VPN/BOTH for remote?
Thanks
Ed
Edited 2 time(s). Last edit at 04/03/2012 01:16PM by ed ziffel.