does synch between DB lock source DB ?

[rhialto]

Hello,

Have large amout of data to backup (table with around 100 M entries).

Only few pourcent of this data change each day.

So syncronise only data updated or deleted and not backup all this seems to be a good idea.

But :

I made a test with small table ( 500 K entries) with small data. the datafile on the drive is 14 Mo.

it take 245 s to copy first time the 500 K entries and 86 s after to check there's no change on second tries (between 2 bi-xeon 700)

So i'am little disapointed because normal backup seems to be more adequat.

But the thing wich can make me use synchronisation is :

Does syncronise Lock DB source ?

if not it's an advatage over normal backup.

Tks

[Ritesh]

SQLyog does not issue any “explicit” lock commands during DB Sync.

The SJA algorithm in mainly designed to sync data using “minimal” data transfer. That means incredible performance gains if network is a bottleneck.

[rhialto]

Ok !

Understood 🙂

Tks

Rhialto

[Author]

Posts