Conversation

Notices

1. Carlos A. Escobar (carlosjs23@mastodones.club)'s status on Tuesday, 23-May-2017 10:39:23 UTC Carlos A. Escobar

   • Eugen 💀

   @Gargron can you give some recommendation about master-master replication on postgresql?, I'm deploying a multi-regional instance. Ty.

   • Eugen 💀 (gargron@mastodon.social)'s status on Tuesday, 23-May-2017 10:41:58 UTC Eugen 💀

     in reply to

     @carlosjs23 I haven't done that before. It might involve integrating https://github.com/thiagopradi/octopus

   • Carlos A. Escobar (carlosjs23@mastodones.club)'s status on Tuesday, 23-May-2017 10:48:45 UTC Carlos A. Escobar

     in reply to

     • Eugen 💀

     @Gargron mm but it's code-dependend, maybe can be hard to maintain it, I'm thinking about db level replication, but in postgresql it's a bit hard to find it. Thanks you again.

   • Eugen 💀 (gargron@mastodon.social)'s status on Tuesday, 23-May-2017 10:51:13 UTC Eugen 💀

     in reply to

     @carlosjs23 master to master replication.. is probably sharding, i.e. splitting db by some criteria like region or domain. replication is usually between read-write master and read-only replicas

   • Eugen 💀 (gargron@mastodon.social)'s status on Tuesday, 23-May-2017 10:53:30 UTC Eugen 💀

     in reply to

     @carlosjs23 in both cases i think the code must know which db to connect to, or there is no point. but i'd be willing to integrate this with the main codebase, as long as it's configurable

   • Carlos A. Escobar (carlosjs23@mastodones.club)'s status on Tuesday, 23-May-2017 10:57:26 UTC Carlos A. Escobar

     in reply to

     • Eugen 💀

     @Gargron Oh now I get it, oks I'l waiting for it, it's a good opportunity to learn how to scale web applications, I have a lot of doubts, but little by little I will solve them.

   • Carlos A. Escobar (carlosjs23@mastodones.club)'s status on Tuesday, 23-May-2017 11:00:00 UTC Carlos A. Escobar

     in reply to

     • Eugen 💀

     @Gargron You recommend me to put nginx in front of each server and then connect each one with the load balancer or just put it directly as a backends to the load balancer?.

   • Eugen 💀 (gargron@mastodon.social)'s status on Tuesday, 23-May-2017 11:01:17 UTC Eugen 💀

     in reply to

     @carlosjs23 load balancer -> (backend_1, backend_2, ...backend_n) and use a private network between lb and backends if possible (i.e. address using private IPs, firewall etc)

   • Carlos A. Escobar (carlosjs23@mastodones.club)'s status on Tuesday, 23-May-2017 11:05:51 UTC Carlos A. Escobar

     in reply to

     • Eugen 💀

     @Gargron mm so without nginx?, if yes, I'll need to put the ssl in the lb. yeah i can use ovh vrack for provide private network but is a bit slower.

   • Eugen 💀 (gargron@mastodon.social)'s status on Tuesday, 23-May-2017 11:06:13 UTC Eugen 💀

     in reply to

     @carlosjs23 nginx is the load balancer

   • Carlos A. Escobar (carlosjs23@mastodones.club)'s status on Tuesday, 23-May-2017 11:10:04 UTC Carlos A. Escobar

     in reply to

     • Eugen 💀

     @Gargron but doing that it's not useful for multi-regional load balancing, it's just for same-region, 'cause I'll need to redirect the users to a backend or another based in their locations.