Posts Tagged ‘ Replication ’

Synchronization of slaves in MySQL replication

When I started to use replication (on few tables) I encountered some problems with discrepancy on slave – it was mainly due to filters on slaves. I had to change some queries and everything was almost fine. Soon, I expanded my topology and started to replicate all databases from master. Simultenously, I read in the book “High […]

Read more...

2010
11/19
CATEGORY
MySQL
RDBMS
TAGS
Write comment

My Sphinx Search replication (master and slaves)

One instance and one storage with indices is neither secure nor effective.  That is why I created my replication for Sphinx Search . To put it shortly, my Sphinx’s architecture constists of tree indices and MVA (multivalue attributes stored in mva_updates_pool) – that is why I cannot use RT index. My first idea was to create independent Sphix index + […]

Read more...

2010
10/01
CATEGORY
NoSQL
Sphinx
TAGS

Write comment