There's a lot of good suggestions here, maybe you could also justify maintaining a separate instance for the American customers. That would at least allow at a minimum to roll out changes specific for them, conform to their maintenance time :P. Yes I do realize it would be a replication of code in terms of releases but it is something to think about.
On Thu, Sep 18, 2008 at 5:05 AM, Bill Davidson <[EMAIL PROTECTED]> wrote: > My company's main webapp is used around the world (Europe, North America, > Australia, etc.). > > We're using Tomcat as our app server and Oracle (10g) for our database. > > When we want to do an upgrade, that usually involves DDL changes to the > database as well as corresponding changes to the webapp which means we > have to make our users log out so we can shut down the app, update the > DDL and restart the updated webapp. The changes are interdependent. > It's all or nothing. > > This was not a big problem when we were just doing business in the U.S. > We'd do upgrades late at night when nobody (or hardly anyone) was using > the system. The problem now is that late at night here is middle of > the day in other places and downtime in the middle of the day is a real > problem. Our customers use our app to run parts of their business so > downtime in the middle of the day is very very bad. They understandably > don't like telling their customers: "I'd like to help you but I need to > wait for the Americans to upgrade their systems." > > I'm not sure how to deal with this. I've been trying to think of a way > to use multiple servers and multiple databases but that seems like a > synchronization nightmare. Losing data consistency is not an option. > > I'm sure that plenty of others on this list have had to deal with this > problem. Any suggestions? How have others dealt with it? > > > > --------------------------------------------------------------------- > To start a new topic, e-mail: users@tomcat.apache.org > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >