Navigation
- FAQ Home
- All categories
- About Webyog support and about this FAQ
- About the SQLyog program

- Connection issues

- Using the GUI
- Managing your MySQL Database Systems

- Database Schema Synchronization
- MySQL DATA synchronization
- SQL Scheduler and Reporting Tool
- Importing external data
- Backup/Restore
- SQLyog Job Agent (SJA)

- Working with Views, Stored Procedures and Triggers
- Character Set and Localization Issues
- MySQL bugs that affect SQLyog
- Questions on Open Source and Compiling
- Sitemap
Most popular FAQs 
- I get error 1130 "Host is not allowed to ... (168933 views)
- Error no. 2003: Can't connect... (86025 views)
- SQLyog Version History (63786 views)
- Error no. 1045: "Connection denied..." (61203 views)
- Error no. 1251: "Client does not support authentication..." (58270 views)
- Error No. 2005: Unknown MySQL server host... (50036 views)
- What is HTTP-tunneling? (42201 views)
- What Is SSH and SSH-tunneling? (37964 views)
- Can I use SQLyog with the WINE Windows emulator ... (34821 views)
- Why are Stored Procedures not created when I import ... (34230 views)
Latest FAQs 
- SQLyog Version History (2012-01-26 08:20)
- SQLyog is a client for the MySQL server - ... (2011-11-04 04:48)
- I get error 1130 "Host is not allowed to ... (2011-11-01 05:21)
- Problems on Ubuntu 11.x (2011-10-29 13:02)
- Problems creating a functional DSN on 64 bit Windows. ... (2011-09-15 14:34)
Sticky FAQs
MySQL DATA synchronization
What is the difference between MySQL server replication and SQLyog synchronization?
Technically they are completely different. MySQL server replication basically operates in the way that the server defined as the 'slave' reads the binary log of the 'master' and replicates operations performed by the master. SQLyog/SJA synchronization uses SQL to query the servers, compares the data using advanced checksum algorithms and performs the INSERTS, UPDATES and DELETES needed to bring databases in sync.
Both methods have their advantages and drawbacks. The most important aspect in favour of the method used by SQLyog synchronization is, that it is possible even if one or both of the databases are in a "shared environment" such as an ISP. You don't need any special privileges to use SQLyog synchronization - only simple SELECT, INSERT, UPDATE and DELETE privileges. And you won't need your own dedicated hardware.
When the SQLyog Job Agent (SJA) connects to the databases that should be synchronized, it does so as any client does. There is no downtime for other users/connections and all data are available for other users while the sync process is running. In that respect SQL server replication and SQLyog synchronization are similar. And as far as the end result goes: having identical databases (if that was what you specified) at both servers they are identical.
Tags: -
Related entries:
- Do I need PHP to use SQLyog with MySQL?
- SQLyog gives you the most options for connecting to MySQL
- Welcome to the SQLyog FAQ
- Installation and upgrading
- Buying and Licensing SQLyog
Last update: 2005-10-03 08:26
Author: Peter Laursen
Revision: 1.0
You can comment this FAQ