Skip to content

VIP Platform: Data Sync and SQL Import Improvements


04 November 2021

18:50:26 GMT+0000

Data syncs (production -> child env) will now run wp vip data-cleanup datasync directly inline during the sync job. This happens both before cron is re-enabled and before maintenance mode is lifted, helping better ensure the the cleanup hooks have run before any requests hit the application. A new hook has been introduced to perform actions during this cleanup: vip_datasync_cleanup (note that vip_go_migration_cleanup still runs, though there are plans to deprecate in the future).

SQL Imports (any env) will also run a similar wp vip data-cleanup sql-import directly inline as well. There is a new WP hook that can be used to perform actions during this cleanup: vip_sqlimport_cleanup.

Alongside those new cleanup processes, the WP options below are backed up before a data sync or SQL import takes place, then restored afterwards. The main reasoning behind this is to prevent production environments from sharing this data with their child environments, as they need to remain unique per environment.

    'jetpack_options',
    'jetpack_private_options',
    'vaultpress',
    'vip_jetpack_connection_pilot_heartbeat',
    'wordpress_api_key',
    'vip_search_index_versions',
    'vip_search_global_index_versions',