Thanks to my colleague Linas Virbalas, Tungsten Replicator has just taken the next step to support full logical replication for PostgreSQL. Linas posted an article today on his new blog describing PostgreSQL logical replication using SLONY triggers. I saw a demo of his implementation and was really impressed. For more information you should read the article, which provides an excellent description of how Tungsten replicates from SLONY logs.
It is pretty exciting whenever Tungsten replicates data to or from a new DBMS type, but PostgreSQL logical replication is really special. Tungsten Replicator has been able to manage native warm standby and log streaming replication more than a year using a script-based plugin. This is fine for offering copies for failover but rather limited for problems beyond simple availability. Logical replication opens up a whole new set of solutions that include multi-master replication, heterogeneous data transfer, and large-scale read scaling on replicas. It is also a key building block for advanced clustering capabilities like zero-downtime upgrade as well as for building multi-tenant systems for SaaS applications. After years of working on these problems for MySQL we are glad to finally attack them head on for PostgreSQL as well.
There is still a lot of work to achieve fully functional, easy-to-use PostgreSQL logical replication, but the work that Linas described gives Tungsten a clear path forward. I expect we will make rapid progress, because so many of the other parts of Tungsten Replicator are already in place. Meanwhile, Linas has put together a very readable blog that should make interesting reading for years to come.
Blog Archive
-
▼
2011
(793)
-
▼
May
(26)
- Weave Hairstyles Ideas
- Weave Hairstyles Girls
- Easy Weave Hairstyles
- Weave Hairstyles Extensions
- Weave Hairstyles Curly Hair
- Weave Hairstyles Color
- Sew in Weave Hairstyles Braids
- Weave Hairstyles African American Hair
- Black Weave Hairstyles
- Quick Weave Hairstyles
- Weave hairstyles photos with Hair Extensions
- Weave Hairstyles with Bangs
- Weave Hairstyles for black women 2011
- Weave hairstyles 2011
- The World Innovation Forum - Landmark Event
- Reinvention at 2 Months: Warrior in Hiding
- Can an "eCoach" Solve Your Health Issues?
- Fighting Hyperglycemia and Type II Diabetes with T...
- Innovative Inoculations
- Cloud Business : Some Perspectives
- The Game Changers
- Dr. Gopal Chopra....Game Changer
- Introducing MySQL to MongoDB Replication
- In Honor of Missing and Exploited Children
- Time for a SQL/NoSQL Group Hug
- Tungsten Supports Logical Replication on PostgreSQL
-
▼
May
(26)