Web form submissions to 311
Requests saved by an older city website into MySQL are read every 15 minutes and created in Sentra 311.
DatabasesConnector
MySQL and MariaDB integration
for city data
MySQL and MariaDB sit behind many city web applications, older department systems and vendor products. Some hold reporting copies of permit, license or request data that other teams query.
Pre-built connector
MySQL / MariaDB
- Tier
- Pre-built connector
- Category
- Databases
- Sign-in
- Database login over TLS
- Paging
- single response
- Default port
- 3306
§ Overview
What connecting MySQL does.
SentraBridge reads tables or a read-only query and writes with insert, update or upsert, including spatial columns. Flows can start when rows change, using a changed-time column. Behind the firewall, the relay reaches the database without opening inbound ports.
- Tables: Read a table or a single SELECT query; insert, update or upsert rows.
- Changed rows: Read only rows changed since the last run with a changed-time column.
- Spatial columns: Read and write point geometry.
What SentraBridge can do with MySQL / MariaDB
| resource | read | write | changes only | fields |
|---|---|---|---|---|
| Tables | read a table or a read-only query | insert, update, upsert | yes (changed-time column) | Any table you grant |
§ Use cases
What cities connect MySQL for.
Reporting copy of permits
Permits changed in OpenGov or Accela are upserted nightly into a MySQL reporting table.
Legacy app to a new system
Records from a department's in-house PHP app are moved into the new vendor system during a phased replacement.
Locations with spatial columns
Facility or asset points are written to a spatial column for a web map built on MySQL.
§ How it works
How to connect MySQL
- 01Get accessCreate a MySQL user for SentraBridge.
- 02Add the connectionGrant SELECT on read tables and INSERT/UPDATE on write tables only.
- 03Preview real recordsEnter host, port (3306 by default), database and password.
- 04Turn it onIf the server is internal, install the relay on the network first.
§ Often connected with
MySQL and the rest of city hall.
Systems cities commonly connect with MySQL, each with its own connector page.
Sentra 311§ FAQ
MySQL integration questions
Can SentraBridge connect to an internal MySQL server?
Yes. The relay runs on the city network, calls out to SentraBridge over HTTPS, and reaches only hosts you allow. No inbound ports are opened.
Does SentraBridge change our tables?
Only the tables you grant INSERT or UPDATE on, and only in steps that write. Read queries run in a read-only transaction.
Does it work with MariaDB?
Yes. The same connection works with MySQL and MariaDB.
§ Next
Related connectors
Connect MySQL / MariaDB to the rest.
We'll set up a workspace with your systems in a sandbox and build your first flow with you.