PostgreSQL Replication Options

Based on different parameters, reuirements etc you have the following popular options.

  • Block level replication – DRBD
  • PostgreSQL Streaming replication (SR)– only available 9.0 +
  • Slony Trigger based replication – Almost the gold standard for Master – Slave replication
  • Bucardo – Perl based multi master Async replication
  • pgPool- II – Load balancer, Query cache, connection pooller , Replication manager
  • pgCluster – multi-master synchronous replication

Continue reading

All you need to know about Search Engine Optimization

Your online businesses are ultimately only as profitable as they are accessible—if no one can find you online, your hard work in creating a useful architecture, providing interesting content, and coding them correctly will be for naught. This is where Search Engine Optimization (SEO) comes into play, and most of you know what it is.

Contrary to what you might hear from companies who try to sell SEO services to you, there are no magic secrets that guarantee you’ll be at the top of every list of search results. However, there is a set of free best practices that you can do on your own to make sure your site is as easy to find as possible.

Continue reading