CHANGELOG.md

@powersync/service-module-mysql

0.12.5

Patch Changes

• Updated dependencies [9add445]
• Updated dependencies [17503d1]
• Updated dependencies [cdb8993]
• Updated dependencies [824e229]
  • @powersync/service-core@1.20.6
  • @powersync/service-sync-rules@0.35.1
  • @powersync/lib-services-framework@0.9.4

0.12.4

Patch Changes

• Updated dependencies [41875f7]
• Updated dependencies [afc9890]
• Updated dependencies [2b72c2a]
• Updated dependencies [4611a49]
• Updated dependencies [b6a7896]
• Updated dependencies [2b72c2a]
• Updated dependencies [756746c]
  • @powersync/service-types@0.15.1
  • @powersync/service-core@1.20.5
  • @powersync/lib-services-framework@0.9.3
  • @powersync/service-sync-rules@0.35.0

0.12.3

Patch Changes

• 11b4deb: Restructure powersync_replication_lag_seconds metric.
• Updated dependencies [df451c6]
• Updated dependencies [dea1e00]
• Updated dependencies [ada86f2]
• Updated dependencies [11b4deb]
  • @powersync/service-core@1.20.4
  • @powersync/service-sync-rules@0.34.1
  • @powersync/lib-services-framework@0.9.2

0.12.2

Patch Changes

• @powersync/service-core@1.20.3

0.12.1

Patch Changes

• Updated dependencies [224c35e]
• Updated dependencies [acf1486]
• Updated dependencies [391c5ef]
• Updated dependencies [7ee87d4]
• Updated dependencies [99de8be]
• Updated dependencies [9daf965]
• Updated dependencies [4c92c24]
• Updated dependencies [3d230c2]
• Updated dependencies [206633f]
• Updated dependencies [3a0627e]
• Updated dependencies [275fd5f]
• Updated dependencies [7ce1b8e]
  • @powersync/service-sync-rules@0.34.0
  • @powersync/service-core@1.20.2
  • @powersync/lib-services-framework@0.9.1

0.12.0

Minor Changes

• 8c5bb3b: [Internal] Allow using multiple BucketStorageBatch instances concurrently.
• c15efc7: [Internal] Track and propagate source on buckets and parameter indexes to storage APIs.

Patch Changes

• Updated dependencies [8c5bb3b]
• Updated dependencies [dcddcf1]
• Updated dependencies [c15efc7]
• Updated dependencies [e7152ce]
• Updated dependencies [e150c5c]
• Updated dependencies [b410924]
  • @powersync/service-core@1.20.1
  • @powersync/lib-services-framework@0.9.0
  • @powersync/service-sync-rules@0.33.0

0.11.0

Minor Changes

• 54bf7f5: [MySQL] Add check for binlog_row_image=FULL.
• 8bd83e8: Introduce storage versions.
• 54bf7f5: [MySQL] Avoid storing a copy of all replicated data - we do not need this for MySQL.

Patch Changes

• 15aea77: Support connection parameters via database URL query string. PostgreSQL supports connect_timeout. MongoDB supports connectTimeoutMS, socketTimeoutMS, serverSelectionTimeoutMS, maxPoolSize, maxIdleTimeMS. MySQL supports connectTimeout, connectionLimit, queueLimit.
• Updated dependencies [0998251]
• Updated dependencies [65f3c89]
• Updated dependencies [1c45667]
• Updated dependencies [8785a3f]
• Updated dependencies [8a4c34e]
• Updated dependencies [b440093]
• Updated dependencies [d7ff4ad]
• Updated dependencies [c683322]
• Updated dependencies [8bd83e8]
• Updated dependencies [83989b2]
• Updated dependencies [79a9729]
• Updated dependencies [5edd95f]
  • @powersync/service-core@1.20.0
  • @powersync/service-types@0.15.0
  • @powersync/service-sync-rules@0.32.0
  • @powersync/lib-services-framework@0.8.3

0.10.2

Patch Changes

• Updated dependencies [a04252d]
  • @powersync/service-sync-rules@0.31.1
  • @powersync/lib-services-framework@0.8.2
  • @powersync/service-core@1.19.2

0.10.1

Patch Changes

• Updated dependencies [0e99ce0]
• Updated dependencies [479997b]
• Updated dependencies [d1c2228]
• Updated dependencies [1a1a4cc]
  • @powersync/service-sync-rules@0.31.0
  • @powersync/service-core@1.19.1
  • @powersync/lib-services-framework@0.8.1

0.10.0

Minor Changes

• e578245: [Internal] Refactor sync rule representation to split out the parsed definitions from the hydrated state.

Patch Changes

• Updated dependencies [05b9661]
• Updated dependencies [eaa04cc]
• Updated dependencies [781d0e3]
• Updated dependencies [e578245]
• Updated dependencies [3040079]
• Updated dependencies [3b2c512]
• Updated dependencies [a02cc58]
  • @powersync/service-core@1.19.0
  • @powersync/service-sync-rules@0.30.0
  • @powersync/lib-services-framework@0.8.0
  • @powersync/service-types@0.14.0

0.9.16

Patch Changes

• bdfd287: Add the timestamp_max_precision option for sync rules. It can be set to seconds, milliseconds or microseconds to restrict the precision of synced datetime values.
• Updated dependencies [8fdbf8d]
• Updated dependencies [bdfd287]
  • @powersync/service-core@1.18.2
  • @powersync/service-sync-rules@0.29.10
  • @powersync/lib-services-framework@0.7.14

0.9.15

Patch Changes

• Updated dependencies [21b3a41]
  • @powersync/service-sync-rules@0.29.9
  • @powersync/lib-services-framework@0.7.13
  • @powersync/service-core@1.18.1

0.9.14

Patch Changes

• b77bb2c: - First iteration of MSSQL replication using Change Data Capture (CDC).
  • Supports resumable snapshot replication
  • Uses CDC polling for replication
• Updated dependencies [dc696b1]
• Updated dependencies [b77bb2c]
  • @powersync/service-core@1.18.0
  • @powersync/service-types@0.13.3
  • @powersync/lib-services-framework@0.7.12

0.9.13

Patch Changes

• Updated dependencies [57f7660]
• Updated dependencies [c050acd]
• Updated dependencies [0156d10]
• Updated dependencies [6eee0b3]
  • @powersync/service-core@1.17.0
  • @powersync/service-types@0.13.2
  • @powersync/service-sync-rules@0.29.8
  • @powersync/lib-services-framework@0.7.11

0.9.12

Patch Changes

• Updated dependencies [fff0024]
  • @powersync/service-sync-rules@0.29.7
  • @powersync/service-core@1.16.3
  • @powersync/lib-services-framework@0.7.10

0.9.11

Patch Changes

• d889219: Fix memory leaks when retrying replication after errors.
• Updated dependencies [b364581]
• Updated dependencies [d889219]
• Updated dependencies [0ace0d3]
• Updated dependencies [7eb7957]
• Updated dependencies [b364581]
  • @powersync/service-core@1.16.2

0.9.10

Patch Changes

• Updated dependencies [c6bdb4f]
  • @powersync/service-core@1.16.1

0.9.9

Patch Changes

• 80fd68b: Add SDK usage reporting support.
• 88982d9: Migrate to trusted publishing
• Updated dependencies [b4fa979]
• Updated dependencies [80fd68b]
• Updated dependencies [c2bd0b0]
• Updated dependencies [0268858]
• Updated dependencies [88982d9]
  • @powersync/service-sync-rules@0.29.6
  • @powersync/service-core@1.16.0
  • @powersync/lib-services-framework@0.7.9
  • @powersync/service-types@0.13.1
  • @powersync/service-jsonbig@0.17.12

0.9.8

Patch Changes

• Updated dependencies [a98cecb]
• Updated dependencies [da7ecc6]
• Updated dependencies [5328802]
• Updated dependencies [704553e]
  • @powersync/service-sync-rules@0.29.5
  • @powersync/service-core@1.15.8
  • @powersync/lib-services-framework@0.7.8

0.9.7

Patch Changes

• Updated dependencies [d976830]
  • @powersync/service-core@1.15.7

0.9.6

Patch Changes

• 221289d: Correctly handle custom types in primary keys.
• Updated dependencies [221289d]
  • @powersync/service-core@1.15.6
  • @powersync/service-sync-rules@0.29.4
  • @powersync/lib-services-framework@0.7.7

0.9.5

Patch Changes

• Updated dependencies [f34da91]
  • @powersync/service-sync-rules@0.29.3
  • @powersync/lib-services-framework@0.7.6
  • @powersync/service-core@1.15.5

0.9.4

Patch Changes

• Updated dependencies [17aae6d]
• Updated dependencies [a2b8bb0]
• Updated dependencies [f400b0f]
  • @powersync/service-sync-rules@0.29.2
  • @powersync/service-core@1.15.4
  • @powersync/lib-services-framework@0.7.5

0.9.3

Patch Changes

• Updated dependencies [9681b4c]
• Updated dependencies [f1b4cef]
  • @powersync/service-sync-rules@0.29.1
  • @powersync/service-core@1.15.3
  • @powersync/lib-services-framework@0.7.4

0.9.2

Patch Changes

• Updated dependencies [bec7496]
  • @powersync/service-core@1.15.2

0.9.1

Patch Changes

• Updated dependencies [6352283]
• Updated dependencies [6352283]
  • @powersync/service-core@1.15.1

0.9.0

Minor Changes

• 6d4a4d1: Create a persisted checksum cache when compacting buckets.
• d49bebe: - Hooked up the MySQL binlog heartbeat events with the bucket batch keepalive mechanism. Heartbeat events will now update the latest keepalive timestamp in the sync rules.

Patch Changes

• 060b829: Update license abbreviation to FSL-1.1-ALv2.
• Updated dependencies [6d4a4d1]
• Updated dependencies [b0b8ae9]
• Updated dependencies [d2be184]
• Updated dependencies [29a368e]
• Updated dependencies [c27e1c8]
• Updated dependencies [5284fb5]
• Updated dependencies [18435a4]
• Updated dependencies [5284fb5]
• Updated dependencies [f56acce]
• Updated dependencies [6fd0242]
• Updated dependencies [6315334]
• Updated dependencies [86807d0]
• Updated dependencies [060b829]
• Updated dependencies [d49bebe]
  • @powersync/service-core@1.15.0
  • @powersync/service-sync-rules@0.29.0
  • @powersync/service-types@0.13.0
  • @powersync/lib-services-framework@0.7.3
  • @powersync/service-jsonbig@0.17.11

0.8.0

Minor Changes

• d56eeb9: Delay switching over to new sync rules until we have a consistent checkpoint.
• d4db4e2: MySQL:
  • Added schema change handling
  • Except for some edge cases, the following schema changes are now handled automatically:
    • Creation, renaming, dropping and truncation of tables.
    • Creation and dropping of unique indexes and primary keys.
    • Adding, modifying, dropping and renaming of table columns.
  • If a schema change cannot handled automatically, a warning with details will be logged.
  • Mismatches in table schema from the Zongji binlog listener are now handled more gracefully.
  • Replication of wildcard tables is now supported.
  • Improved logging for binlog event processing.

Patch Changes

• Updated dependencies [b1add5a]
• Updated dependencies [2378e36]
• Updated dependencies [4a34a51]
• Updated dependencies [4ebc3bf]
• Updated dependencies [2378e36]
• Updated dependencies [1aafdaf]
• Updated dependencies [d56eeb9]
• Updated dependencies [d4db4e2]
  • @powersync/service-core@1.14.0
  • @powersync/service-sync-rules@0.28.0
  • @powersync/lib-services-framework@0.7.2

0.7.4

Patch Changes

• 71cf892: Add 'powersync' or 'powersync-storage' as the app name for database connections.
• Updated dependencies [a60f2c7]
• Updated dependencies [71cf892]
• Updated dependencies [ba1ceef]
• Updated dependencies [60bf5f9]
• Updated dependencies [f1431b6]
  • @powersync/service-core@1.13.4
  • @powersync/service-types@0.12.1
  • @powersync/lib-services-framework@0.7.1

0.7.3

Patch Changes

• Updated dependencies [3e7d629]
• Updated dependencies [e8cb8db]
  • @powersync/service-core@1.13.3

0.7.2

Patch Changes

• Updated dependencies [c002948]
  • @powersync/service-core@1.13.2

0.7.1

Patch Changes

• Updated dependencies [1b326fb]
  • @powersync/service-core@1.13.1

0.7.0

Minor Changes

• 0ccd470: Add powersync_replication_lag_seconds metric
• e11754d: Added a configurable limit for the MySQL binlog processing queue to limit memory usage. Removed MySQL Zongji type definitions, they are now instead imported from the @powersync/mysql-zongji package. Now passing in port for the Zongji connection, so that it can be used with MySQL servers that are not running on the default port 3306.

Patch Changes

• 1907356: Cleanly interrupt clearing of storage when the process is stopped/restarted.
• 951b010: Implement resuming of initial replication snapshots.
• Updated dependencies [08b7aa9]
• Updated dependencies [0ccd470]
• Updated dependencies [1907356]
• Updated dependencies [951b010]
• Updated dependencies [d235f7b]
• Updated dependencies [f9e8673]
  • @powersync/service-core@1.13.0
  • @powersync/service-types@0.12.0
  • @powersync/lib-services-framework@0.7.0

0.6.5

Patch Changes

• Updated dependencies [100ccec]
• Updated dependencies [b57f938]
• Updated dependencies [5b39039]
  • @powersync/service-core@1.12.1
  • @powersync/service-sync-rules@0.27.0

0.6.4

Patch Changes

• 94f657d: Add additional log metadata to sync requests.
• Updated dependencies [ca0a566]
• Updated dependencies [9dc4e01]
• Updated dependencies [94f657d]
• Updated dependencies [05c24d2]
• Updated dependencies [d154682]
• Updated dependencies [c672380]
• Updated dependencies [ca0a566]
• Updated dependencies [ca0a566]
• Updated dependencies [d869876]
  • @powersync/service-core@1.12.0
  • @powersync/lib-services-framework@0.6.0
  • @powersync/service-sync-rules@0.26.1
  • @powersync/service-types@0.11.0

0.6.3

Patch Changes

• Updated dependencies [08f6ae8]
• Updated dependencies [23ec406]
• Updated dependencies [64e51d1]
  • @powersync/service-core@1.11.3
  • @powersync/lib-services-framework@0.5.4

0.6.2

Patch Changes

• Updated dependencies [ac6ae0d]
  • @powersync/service-sync-rules@0.26.0
  • @powersync/service-core@1.11.2

0.6.1

Patch Changes

• Updated dependencies [08e6e92]
  • @powersync/service-core@1.11.1

0.6.0

Minor Changes

• d1b83ce: Refactored Metrics to use a MetricsEngine which is telemetry framework agnostic.

Patch Changes

• Updated dependencies [d1b83ce]
  • @powersync/service-core@1.11.0
  • @powersync/service-types@0.10.0

0.5.5

Patch Changes

• Updated dependencies [a9b79a5]
  • @powersync/service-core@1.10.2

0.5.4

Patch Changes

• a6dee95: Fixed mysql varchar column identification for binary encoded varchar columns
  • @powersync/service-core@1.10.1

0.5.3

Patch Changes

• Updated dependencies [833e8f2]
• Updated dependencies [833e8f2]
• Updated dependencies [bfece49]
• Updated dependencies [2cb5252]
  • @powersync/service-core@1.10.0
  • @powersync/service-sync-rules@0.25.0

0.5.2

Patch Changes

• 8601d6c: [MySQL] Fix errors being hidden by ROLLBACK failure
• Updated dependencies [f049f68]
• Updated dependencies [8601d6c]
  • @powersync/service-core@1.9.0

0.5.1

Patch Changes

• Updated dependencies [7348ea0]
  • @powersync/service-core@1.8.1

0.5.0

Minor Changes

• 698467c: Use bigint everywhere internally for OpId.

Patch Changes

• 698467c: Fix race condition when stopping replication immediately after starting it.
• Updated dependencies [0298720]
• Updated dependencies [698467c]
• Updated dependencies [ba7baeb]
  • @powersync/service-sync-rules@0.24.1
  • @powersync/service-core@1.8.0
  • @powersync/service-types@0.9.0

0.4.2

Patch Changes

• @powersync/service-core@1.7.2

0.4.1

Patch Changes

• 2f75fd7: Improve handling of some edge cases which could trigger truncating of synced tables.
• Updated dependencies [b4fe4ae]
• Updated dependencies [88ab679]
• Updated dependencies [2f75fd7]
• Updated dependencies [346382e]
• Updated dependencies [9b1868d]
  • @powersync/service-core@1.7.1
  • @powersync/lib-services-framework@0.5.3

0.4.0

Minor Changes

• 436eee6: Minor optimizations to new checkpoint calulations.

Patch Changes

• Updated dependencies [436eee6]
• Updated dependencies [15283d4]
• Updated dependencies [88d4cb3]
• Updated dependencies [f55e36a]
  • @powersync/service-core@1.7.0
  • @powersync/service-sync-rules@0.24.0
  • @powersync/lib-services-framework@0.5.2

0.3.1

Patch Changes

• ffc8d98: Fix write checkpoint race condition
• Updated dependencies [ffc8d98]
  • @powersync/service-core@0.18.1

0.3.0

Minor Changes

• 4b43cdb: Exit replication process when sync rules are not valid; configurable with a new sync_rules.exit_on_error option.

Patch Changes

• Updated dependencies [e26e434]
• Updated dependencies [4b43cdb]
• Updated dependencies [9a9e668]
  • @powersync/service-sync-rules@0.23.4
  • @powersync/service-core@0.18.0
  • @powersync/service-types@0.8.0
  • @powersync/lib-services-framework@0.5.1

0.2.2

Patch Changes

• Updated dependencies [23fb49f]
  • @powersync/service-core@0.17.0

0.2.1

Patch Changes

• Updated dependencies [5043a82]
  • @powersync/service-sync-rules@0.23.3
  • @powersync/service-core@0.16.1

0.2.0

Minor Changes

• 8675236: Allow limiting IP ranges of outgoing connections

Patch Changes

• f049aa9: Introduce standard error codes
• Updated dependencies [f049aa9]
• Updated dependencies [8675236]
• Updated dependencies [f049aa9]
• Updated dependencies [8675236]
• Updated dependencies [8675236]
• Updated dependencies [f049aa9]
  • @powersync/service-core@0.16.0
  • @powersync/service-sync-rules@0.23.2
  • @powersync/service-types@0.7.1
  • @powersync/lib-services-framework@0.5.0

0.1.9

Patch Changes

• Updated dependencies [9d9ff08]
• Updated dependencies [9d9ff08]
• Updated dependencies [9d9ff08]
  • @powersync/service-core@0.15.0
  • @powersync/lib-services-framework@0.4.0

0.1.8

Patch Changes

• e25263c: Added a heartbeat mechanism to the MySQL binlog listener replication connection to detect connection timeouts.
• 318f9f9: Resolved excessive memory consumption during MySQL initial replication.
• Updated dependencies [fea550f]
• Updated dependencies [fea550f]
• Updated dependencies [48320b5]
• Updated dependencies [fea550f]
  • @powersync/service-core@0.14.0
  • @powersync/lib-services-framework@0.3.0
  • @powersync/service-sync-rules@0.23.1
  • @powersync/service-types@0.7.0

0.1.7

Patch Changes

• cb749b9: Fix timestamp replication issues for MySQL.
• cb749b9: Fix resuming MySQL replication after a restart.
• Updated dependencies [0bf1309]
• Updated dependencies [a66be3b]
• Updated dependencies [010f6e2]
  • @powersync/service-core@0.13.0
  • @powersync/service-types@0.6.0
  • @powersync/service-sync-rules@0.23.0

0.1.6

Patch Changes

• Updated dependencies [320e646]
• Updated dependencies [e3a9343]
  • @powersync/service-core@0.12.2

0.1.5

Patch Changes

• Updated dependencies [889ac46]
  • @powersync/service-core@0.12.1

0.1.4

Patch Changes

• Updated dependencies [ebc62ff]
  • @powersync/service-core@0.12.0
  • @powersync/service-types@0.5.0

0.1.3

Patch Changes

• Updated dependencies [62e97f3]
• Updated dependencies [a235c9f]
• Updated dependencies [8c6ce90]
  • @powersync/service-core@0.11.0
  • @powersync/service-sync-rules@0.22.0

0.1.2

Patch Changes

• Updated dependencies [2a4f020]
  • @powersync/service-core@0.10.1

0.1.1

Patch Changes

• Updated dependencies [2c18ad2]
• Updated dependencies [35c267f]
  • @powersync/service-core@0.10.0
  • @powersync/service-types@0.4.0

0.1.0

Minor Changes

• 57bd18b: Generate random serverId based on syncrule id for MySQL replication client Consolidated type mappings between snapshot and replicated values Enabled MySQL tests in CI
• 57bd18b: Introduced alpha support for MySQL as a datasource for replication. Bunch of cleanup

Patch Changes

• 57bd18b: Fixed MySQL version checking to better handle non-semantic version strings
• 57bd18b: Fixed mysql schema json parsing
• Updated dependencies [57bd18b]
• Updated dependencies [57bd18b]
• Updated dependencies [57bd18b]
• Updated dependencies [57bd18b]
• Updated dependencies [57bd18b]
• Updated dependencies [57bd18b]
• Updated dependencies [57bd18b]
• Updated dependencies [57bd18b]
• Updated dependencies [57bd18b]
• Updated dependencies [57bd18b]
  • @powersync/service-core@0.9.0
  • @powersync/lib-services-framework@0.2.0
  • @powersync/service-sync-rules@0.21.0
  • @powersync/service-types@0.3.0