Hi, We're running a hosting infrastructure with currently 36000 application websites that we'd like to upgrade. The application upgrade requires massive db schema changes and could take a very long time on so many instances.
All the dbs are hosted on a dedicated host + replication on a slave. We're on EC2 so we can use as many spare servers as needed for the upgrade. I was wondering what would be our best bet to upgrade with a minimum user downtime. For example we could launch a new DB instance with a backup and upgrade it, but then we'd still need to catch up with the operational DB and convert the updates to the new schema. Maybe there a way to add a "schema conversion" script in the replication process ? Any thoughts, suggestions or feedback about such an upgrade would be appreciated. Thanks. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "mysql" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/mysql -~----------~----~----~----~------~----~------~--~---
