MySQL

Two-way sync between MySQL and your other systems.

Introduction

MySQL is a widely-used, open-source relational database management system that uses SQL (Structured Query Language) for data manipulation. Known for its speed, reliability, and ease of use, MySQL is the foundation for many popular applications and websites. It powers critical backend systems and supports large-scale enterprise solutions.

Now you can seamlessly synchronize data across all your CRMs and database systems using Stacksync!

Things to keep in

During setup

• All MySQL tables must have a (single) primary key We use the primary key to keep your data in sync. The primary key must be a single column; composite primary keys are not supported. Check our MySQL snippets collection for additional hints.

• Primary keys must be auto-generated Ensure your primary keys are auto-generated by your database (e.g. use AUTO_INCREMENT for primary keys).

• Check user permissions Verify that the MySQL user used by Stacksync to connect to your database has sufficient privileges (e.g., SELECT, INSERT, UPDATE, and DELETE) on the tables you want to map.

If a table in your database does not appear in Stacksync, one of the above conditions is likely not met. Check our MySQL snippets collection for troubleshooting tips.

After setup

Renaming schema, tables, or columns will break Stacksync configuration. But don't worry, we've got you covered! Refer to our Update Sync Configuration guide for detailed steps to address this.