Date: Tue, 12 Jul 2005 15:28:32 -0700 From: "Gustavo A. Baratto" <gbaratto@superb.net> To: RC <rubbishcollector@yahoo.com>, freebsd-isp@freebsd.org Subject: Re: fastest way to duplicate production server? Message-ID: <018801c58731$0929f8a0$0aae5218@garrincha> References: <20050712214555.42683.qmail@web53902.mail.yahoo.com>
next in thread | previous in thread | raw e-mail | index | archive | help
- install the new versions of Apache/MySQL/PHP in the test server - make sure apache and php are running with the same configuration of the production server (check httpd.conf, php.ini, etc). Just install mysql, no need to configure it now, as you gonna copy over the configuration and grant tables later. - use rsync to copy the html and php files from the production server to test server. - to copy over mysql data, you must do a " FLUSH TABLES WITH READ LOCK" then rsync the data directory over to the test server (/var/db/mysql is the freebsd default). Then you "UNLOCK TABLES" after rsync is done. Start mysql and you are done. Instead of a "flush tables with read lock", you could just stop mysql in the production server. This is just to make sure there is no updates in the tables while you are copying them over. Cheers ----- Original Message ----- From: "RC" <rubbishcollector@yahoo.com> To: <freebsd-isp@freebsd.org> Sent: Tuesday, July 12, 2005 2:45 PM Subject: fastest way to duplicate production server? > We have a production FreeBSD 4.10 server running old versions of > Apache/MySQL/PHP from ports. We'd like to upgrade Apache/MySQL/PHP > to the latest versions. Before upgrading we'd like to test on a > test box. > > What's the fastest way of duplicating the existing Apache/MySQL/PHP > (including user databases)? (The production server cannot go down > for more than a few seconds.) > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > _______________________________________________ > freebsd-isp@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-isp > To unsubscribe, send any mail to "freebsd-isp-unsubscribe@freebsd.org" >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?018801c58731$0929f8a0$0aae5218>