Re: fastest way to duplicate production server?

From: Gustavo A. Baratto (gbaratto_at_superb.net)
Date: 07/13/05

  • Next message: Mark Bucciarelli: "Re: fastest way to duplicate production server?" 
    Date: Tue, 12 Jul 2005 15:28:32 -0700
To: RC <rubbishcollector@yahoo.com>, freebsd-isp@freebsd.org

    - 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"
    >

    _______________________________________________
    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"

  • Next message: Mark Bucciarelli: "Re: fastest way to duplicate production server?"

    Relevant Pages

    • Re: ASPX Page loads slowly
      ... then I'd suggest caching it to avoid that 7 second wait. ... When I test the page against the test server DB, the page loads pretty fast. ... When I test the page against the production server DB, ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Odd message from cron daemon
      ... > Roland Smith writes: ... >> command and fails. ... > files are identical on my production server and on my test server: ...
      (freebsd-questions)
    • Re: Odd message from cron daemon
      ... > command and fails. ... files are identical on my production server and on my test server: ... mysterious message is being mailed to me only on the test system. ...
      (freebsd-questions)
    • Strange Occurance on Live but not on Test Server
      ... I have a fairly simple ASP.Net app that is a Business Card order form. ... This works perfectly on my test server. ... However, on my production server, ... the first time I, or anyone, clicks on that Show Me button, it refreshes the ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: web.config ignored!?!?!
      ... <configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"</a>;> ... that will eliminate the error message. ... When debug is set to true, it telles the browser never to cache the ... flag always should be set to false in a production server. ...
      (microsoft.public.dotnet.framework.aspnet)