4 ms·
Can someone more versed in the current state of Postgres chime in on something for me? > "One use case that has historically been challenging in database manag
by adrianpike 14y ago
Can someone more versed in the current state of Postgres chime in on something for me?
> "One use case that has historically been challenging in database management is setting up a read replica, often referred to as a read slave."
Having only inherited MySQL stuff in production, this is pretty trivial in MySQL land - I was under the impression that Postgres also had a solution for this, with Slony and recently as a part of Postgres core. Is my info wrong on this?
I thought master/slave replication was a pretty solved problem at this point, am I wrong?
- hgimenez 14y agoPostgres, as of 9.0, has binary log streaming replication built in, truth. Slony ad other logical replication solutions out there are quite hard to set up and come with their gotchas. A rock solid one command (cli)/click (web) is a whole different story though, making it super easy to form more complex DB topologies and adapting them as your needs change.