[EDIT: I should have read closer the original post here, where it seems that DATABASE_URL should actually be used for primary based on the code. I’m going to go investigate what was going on with my set up that caused my primary to ignore the DATABASE_URL. Please ignore literally everything below here.]
I have a Documentation PR related to this already open… as I had production downtime due to this change when switching to SolidQueue.
It doesn’t mention anywhere in the rails guide that mulit-databases ignores DATABASE_URL. I think it’s fine for us to move away from that, but at least the guide should mention how to fix it!