popo63301

popo63301

Should I stop my application to run a DB migration in prod?

Hello !

Should I stop my application to run a DB migration in prod ?

What is the good practice ?

Thanks !

Most Liked

evadne

evadne

I think given how the question was asked, I will recommend reviewing 12factor.net and if you could deliberate each point with personal experience.

Otherwise make the decision based on the trade-offs.

dbern

dbern

“good practice” generally means running migrations that don’t affect your end-users. In some applications that means going into “maintanence mode” (turn app off) in the middle of the night since no one’s using the app at that time, and running migrations. Or it means using some database techniques to avoid any downtime at all, which what I see more often.

The article Safe Eco Recipes is a resource that collects no-downtime migration techniques (thanks com for the reference!). If you’d rather watch a video there’s some of it here: https://m.youtube.com/watch?v=mOeONt6Hkf8

If you’re migrating a table with 10 rows in it, there’s virtually no downtime regardless of you using “good” or “bad” techniques. If you’re migrating a table with 10 million rows you’ll need to consider no-downtime techniques more seriously.

Maybe more important than any of that ^ is having a boot-up process that can successfully run migrations, checking for success, and if success then booting the rest of the app, and lastly shifting traffic to the new nodes. (see part 2 of the Safe Ecto Migrations guide)

cjbottaro

cjbottaro

It depends on many factors. I think you should Google “migrations and downtime” or something similar.

For example, lets say you want to rename a database column. Well, if you deploy code first, then things will crash because that column doesn’t exist. If you migrate first, well things will still crash because the currently running code will be trying to use the old column.

From personal experience, we’ve mostly opted to let our application crash for 1-2 minutes while we’re deploying/migrating. But if that’s not acceptable, then you gotta do things like deploy defensive code first (that can handle both situations), then migrate, then deploy again to remove the defensive code.

Where Next?

Popular in Questions Top

sergio
In Ruby, I can go: User.find_by(email: "foobar@email.com").update(email: "hello@email.com") How can I do something similar in Elixir? ...
New
lessless
I believe there are people here who are dealing with CSV files import on the daily basis, and since Excel is a really popular tool there ...
New
tduccuong
Hi, is there any work on GUI with Elixir, that is similar to Electron/Javascript? My idea is to bundle Phoenix and BEAM into a single se...
New
minhajuddin
I have seen a lot of code which picks the first element from a list using Enum.at(0) instead of List.first. Is there a reason why people ...
New
johnnyicon
Hi all, I’ve just started learning Elixir and Phoenix Framework, so please pardon my n00bness at this stage. I’m trying to use Postgres...
New
stefanchrobot
What’s the safe way to decode a JSON string into a struct? I want to avoid calling String.to_atom. Jason.decode can give me a map with st...
New
JDanielMartinez
Hi! May someone helps me, please! I have two apps into an umbrella project: the first one is Database, which manages queries, and the se...
New
svb
Hi! Currently I want to submit a form by pressing the Enter key. However, since my input field is of type “textarea” this is just adds a...
New
lanycrost
Hi everyone! I need implement if…else if…else condition from my elixir code, and anymore of this control flow structures not work proper...
New
vonH
In asking this question I am more interested about the expressiveness of the language itself and less concerned about the availability of...
New

Other popular topics Top

siddhant3030
Hi, I have to write a raw query for one of my project. But till now I have used ecto queries and don’t have much experience writing raw ...
New
WestKeys
Currently suffering from paralysis by [HTTP client] analysis. This is rather unusual in Elixirland as there tends to be consensus on the ...
New
stefanluptak
Hello everybody, usually, I use a 29" ultra-wide monitor for VSCode which can easily accomodate explorer (files panel) + file with code ...
New
gausby
I asked this very same question on twitter and got some interesting feedback, but I thought it would be a good question to ask here as we...
1207 39467 209
New
joeerl
Hello again - after a longish gap I’ve decided I really must dig into Elixir and see what’s been happening here - so I have a few questio...
New
vrod
I am using the Starship cross-shell prompt – it seems pretty nice, but I get some errors: [WARN] - (starship::utils): Executing command ...
New
SoCreat
i’m a new one to elixir which editor can i use vs code? or atom? Thanks! :smiley:
New
Brian
What is the proper way to load a module from a file in to IEX? In the python world, doing something like this pretty standard: from ....
New
hariharasudhan94
I would like to know what is the best IDE for elixir development?
New
hariharasudhan94
Lets say I have map like this fetching from my database %{"_id" => #BSON.ObjectId<58eb1a7a9ad169198c3dXXXX>, "email" => ...
New

Latest on Elixir Forum

Elixir Forum

We're in Beta

About us Mission Statement