Recursive Updates on large table
Your schema diagram is good. You should not put any total cost column either to Recipe or RecipeIngedient as it is not compliant to normalization. And so there is no need for triggers.
The total cost sum should be calculated on the fly in a query that you use to list recipes.