Read/write separation

[dtdionne]

I’m still researching this but I figured I’d ask. Does or can solidus easily support a high availability Postgres patroni cluster? I’ve got a little cluster that can read from replicas on port 12000 and read/write to the master on port 12001.

I’m not a developer so please forgive me if this is a silly question.

[kennyadsl]

@dtdionne Solidus is basically a Rails application, so you can configure multiple database within a Solidus application. I suggest to study this page of the Rails documentation, which also apply to the Active Record classes (all the models) we have in Solidus: https://guides.rubyonrails.org/active_record_multiple_databases.html.

[dtdionne]

Yeah nothing went over the read port. But it did the read/write port. Double dukes.

[dtdionne]

We tried adding to application_record.rb as that doc explains but it doesn’t appear the app uses that file. I deleted it as a test and the app still appears to run fine.

[dtdionne]

I'm sorry, i don't know what GET/HEAD means nor exactly how to test for it. A rails routes -E | grep -i head doesnt return any hits...but idk what that means.

[jarednorman]

HTTP requests have a method. Don't worry to much that there are specific HEAD routes in the app. That's normal and not worth spending time worrying about.

I will offer the friendly advice that if you are not pretty familiar with Rails development specifically and web development in general, operating a Solidus store will likely be very difficult for you. Getting multi-DB support working on a complex app like a Solidus store is not for the faint of heart. It would be cool if it was something we officially supported, but that's not currently the case. All the stores I've worked that have support rolled their own and it's optimized for their specific use cases (like offloading certain very expensive queries to the read replicas.)

[dtdionne]

Thanks Jared