Action Network Help & FAQs

Does Action Network have a SQL mirror? What does it do?

Action Network offers a read-only, continuously updated SQL mirror to partners. It contains a full copy of absolutely all of the data we have on any groups you ask us to mirror, such as actions, activists, custom fields, tags, subscription status...everything. (We can mirror groups and their children, if they're in a Network.) The SQL mirror is useful for complex analysis, writing custom dashboards, data warehousing, moving data into other systems via SQL queries, or other database friendly tasks.

Because it is read-only, it's not useful for pushing data into our system, or for sync-type operations. For that, our API is a better choice.

The SQL mirror is available for an extra monthly fee, the amount of which depends on the size of the Action Network groups you ask us to mirror and the performance you require. The covers the cost of hosting a new, isolated database server for your mirror and the upkeep involved in keeping the mirror running.

The SQL mirror is a read-only MySQL copy of your data, running on an isolated database instance through our hosting environment. After it's set up, we will whitelist the IP addresses you want to use to connect to the database and you will receive connection credentials to access your data.

The SQL mirror is continuously updated. It is not updated in real time. Rather, we run queries against our production database to pull out data on groups being mirrored and dump the results of those queries into your SQL mirror.

The amount of time it takes for one cycle to complete and update the SQL mirror from the production database varies depending on how large the group is and how much data it contains. Smaller groups may take minutes, while larger groups may take hours.

If you're a partner, you can read the documentation for the SQL mirror here. To request a SQL mirror, contact us.

 

 

Have more questions? Submit a request