MySQL Forums
Forum List  »  Backup

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
3028
March 31, 2012 05:25PM
1384
April 01, 2012 11:32PM
1392
April 02, 2012 08:32AM
1429
April 03, 2012 09:15AM
Re: Moving dbs to new server
1693
April 03, 2012 12:17PM
1352
April 04, 2012 09:00AM
1301
April 05, 2012 02:25PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.