Hy, I want to update my databases on my mysql server, but for now i usually take my server down before to the update.
I wonder if there is any solution to make the update without any disruption of the website disponibility ?
Thanks for your help.
Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up.Sign up to join this community
What do you wanna do, update the server software or update/alter tables on the DB? Let's tackle both cases:
Update the software: you will need a Master-Master replication setup and a floating IP. This floating IP stays on the first master during normal operations, then you can:
Update/alter tables: most of those actions can be done while the server is running, unless it's a very big table.
ALTER TABLE usually locks the table so while the command is running the app will not be able to access it (can't remember if `ALTER TABLE' is a full lock or just write lock, check the docs). If the migration is going to take too much, you will need to do something like the update above, doing it on the master first and then on the other master, but this is more delicate and the instructions are too complex to accomplish here.