databases features

Basic features

Fragmentation – spread data across servers by type, for example customer data on one server, items data on another.

Segmentation – spread data across servers by chunks.


 Replication

DRBD

  • filesystem block replication

streaming

  • doesn’t work in PostgreSQL with different versions

sync replication

  • slower
  • consistency

async replication

  • faster
  • some data loss during failover

cascading replication

  • slave download from slave and futher

logical replication

  • allow replicate some DB and tables between different servers

 

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>