can sync if i have frequent transaction?

[Ritesh]

Whenever there is a conflict of primary keys between the source and target server, the data from the source will overwrite target.

[peterlaursen]

there is no chance that you can build another PK than one based upon an autoincrement integer ??

[warrence]

that means for my case this SQLyog is not suitable for me? or there is any way to tweak around with this SQLyog?

and i want to ask that is the synchronization is REAL-TIME?

[peterlaursen]

It seems to me that in this case you should use the built-in replication feature of the MySQL server itself.

[johll]

Does your product support setting up MySQL's built-in replication between 2 servers?

Thanks.

[peterlaursen]

Quote:

Does your product support setting up MySQL's built-in replication between 2 servers?

There is no need to! This is controlled by the MySQL server configuration files. There is a whole section in the MySQL manual describing replication with MySQL. Start here: http://dev.mysql.com/doc/mysql/en/replication.html

The main reason issue that you must understand here is that SJA is not AT ALL any sort of “daemon� running with the MySQL server “supervising� or “over viewing� what the server is doing. As any MySQL client it starts (when you or some application or some scheduling feature starts it), it does its job, it finishes and it closes down when it is done! It is not permanently running.

[johll]

I understand it's a client… I've read through the docs and even:

http://dev.mysql.com/books/hpmysql-excerpts/ch07.html

I'm running the win32 5.0.7 beta of MySQL and got the master configured but the slave doesn't want to connect (from what I can tell), so I was just curious if this product would setup the config files. The other features of this tool look great.

Disclaimers: newbie, windows server a requirement – not a choice.

[peterlaursen]

Then you will probably know more about it than I !

If the setup of accounts and the bin-log is done correctly I have no more ideas …

[Author]

Posts