Correct db-sync code for PHP version (correcting DbSync\Transfer error) about db-sync

[elielmathe]

@rutvij2292
For high trafic applications, I can suggest that you create a table in your MySQL Schema called Synchronised then you record the last synchronised id.
On the next synchronisation, get the last synchronised id for the table and add
--where idInTable>previousLastSyncedId
I assume that you work on INSERTS because this is a problem when dealing with UPDATE and DELETE.

[mrjgreen]

Thanks, I've updated the use statement in the readme: 0c50c46

[rutvij2292]

Thanks, @bakjanos Example is Helpful for a windows machine user. @mrjgreen Thanks for this awesome library. I am having a hard time to set up a master-slave replication in MySQL. This library is a time saver. Is this recommended for large traffic site as well?

Currently, I am planning to apply whereClause on the timestamp. Will it be problematic? Please let me know. Once again thanks, guys.

[elielmathe]

Thanks a lot.
I am not very good at composer and I could not troubleshoot the code on main README.
My suggestion is that they edit the code in the README.

[elielmathe]

Oh, sorry, this is related to the CLI.
For integration in PHP, use
$sourceTable->setWhereClause(new WhereClause("idInTable > ?", [previousLastSyncedId]));

[rutvij2292]

@elielmathe Make sense. Thanks for pointing that out. One last question Should I sync manually or should I go for the MySQL Master Slave replication? I am open to any suggestions.
Once again thanks for your input.