https://bugzilla.wikimedia.org/show_bug.cgi?id=63382

--- Comment #15 from Tim Landscheidt <[email protected]> ---
(In reply to Alexandros Kosiaris from comment #14)
> It is expected that labsdb1005 is read-only. It is setup in a standby hot
> slave configuration. Should something bad happen to labsdb1004, we shall
> have labsdb1005 assume labsdb1004 "personality" (IP, hostname etc) and also
> switch it to read-write. 
> [...]

Could we perhaps use a generic (DNS) alias for that?  Having a "real" and a
"fake" labsdb1004 seems very confusing; I would expect "hostnames with numbers"
to always refer to the same hardware.  On Toolserver, there was a similar setup
for the MySQL DB servers: "rosemary", "daphne" & Co. always referred to
distinct physical hardware, while "sql-s1" & Co. were aliases that pointed to
the hosts (actually, to a HA distributor that forwarded the connections to the
hosts).

I don't know at the moment if PostgreSQL checks the server's hostname during
authentification, though.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to