can sync if i have frequent transaction?

[warrence]

ok lets say i have 2 server A and B………and my web application is actually an shopping cart system, and having very frequent transaction like one transaction in few minutes…….now currently im running one server so when one people do ordering he will get a autoincrement order no in the database……so how if in within few second there is one person order something from A-server and the other guy make the order from B-server, will they get the same autoincrement number when sync? please give some solution, if this can be solve, i dun mind paying alot for the mysql synchronization software from you 🙂

[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