Column Changes

[mcolwill]

Hi

I have the 1st of several 2 site projects with 2 mysql DBs in seperate offices (joined by VPN 1MB DSL)

I need to implement 2 way synch and sqlyog looks perfect. I can see a column change in office A will trigger an update requirement for Office B, but will only that column be updated in Office B or or is the entire record updated from Office A over the top of Office B.

Other related questions if you dont mind

1) How does it perform over non LAN connections. ie lower bandwidth of 1MB not 100MB.

We plan to run update overnight so speed is not critical but it is relevant.

Thanks in advance, I so hope this works. I am deperate to use MYsql and not MS SQL and sqlyog looks like my best hope.

🙂

[Shadow]

1. Sja updates ALL monitored columns if a change is detected in any of them. Simply check out the binary logs to see what it does to the data.

2. We used to run updates to 15 remote offices every day over 128Kbit leased lines with sja and it worked fine for us (we switched to Oracle). However, none of the updates ever exceeded 2MBytes.

[mcolwill]

Hi

I seem to have this working but i have a problem with the source being too agressive, in 2 way synch. mode, in fact in either mode

-if i make a chnage to record 1 in target and not in record 1 in source, the source always overwrites record 1, ie changes never make it from target to source and worse than that, source resets the change in target if target makes one.

So it seems the changed record is correctly identified but that source always writes over target regardless of who changed it.

-even in one way synch, target cahnes record, source does not, at end of it i always end up with source record

Is thsi correct?

btw, I have only 1 index being primary key on the recordid (in this case personid).

thanks for your help once again.

[Author]

Posts