How to setup a Postgres streaming replica with Kamal

Подписаться 551

50% 1

Setting up a Postgres streaming replica has a lot of advantages: hot backup, offloading analytics queries, and piece of mind. Using a simple bash script combined with Kamal, it's not too difficult to setup.
--------------------------------
Reference Links
Official Docs: www.postgresql...
Code sample: github.com/sam...
--------------------------------
Kamal Handbook by Josef Strzibny (affiliate link) → gumroad.com/a/...
Check out twitter for more: / samcraigjohnson
#rubyonrails #webdevelopment #postgresql #devops

Опубликовано:

12 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 8

@muronuck 6 месяцев назад

Super informative, well spoken and very useful video! Subscribed for more!

@devscoach 6 месяцев назад

Thank you for watching!

@marekpietrucha839 4 месяца назад

Thank you for a great video! Did you do a video on setting up a read replica with Kamal for postgresql? :)

@devscoach 4 месяца назад

Not yet , but the streaming replica will work as a read replica. There is only one postgres setting you need to change to allow it to

@hendrikmartina3552 6 месяцев назад

Nice video m8. Only one question, do you think this configuration is production ready in case it isn't what is missing to get to that point?

@devscoach 6 месяцев назад

Thank you. I think its production ready. The only thing I would make sure is you have backups setup. I covered that here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5AMLVUPrL0w.html. But if you already have your own backup system setup, it should be good to go.

@hendrikmartina3552 6 месяцев назад

@@devscoach awesome I will check it out. Another question I have , do you work for Basecamp or hey?

@devscoach 5 месяцев назад

@@hendrikmartina3552 Nope, I used to work for Atlassian but now I do Rails consulting