Re: Lua Questions

[Nakoa McCullough]

Russell,

Thanks for the response. The behavior you describe is actually exactly what I want. The process I have in mind is for an active-passive master-master setup and looks like this:

1. You would start proxy pointing to both servers with a script that would direct all traffic to the current production server

2. You would point the site to proxy

3. You would check that replication is caught up and there were no processes that will run for an extended period of time (In our environment these should all come from specific hostnames)

4. Once all of the above conditions are satisfied. On the file system you would swap the original script out with a new script that slept till the original server had no connections from the site on it, then directed traffic to the passive server. (this is essentially a way to queue connections without dropping them)

5. You would then point the site to the original passive server.

This should prevent key collision that we have scene in the past (note due to the way our product determines its keys it is not possible to use auto-inc. columns.)

Also what about the millisecond time resolution?

Anyhow thanks for the help.

--Koa