Change log
- Compatibility: Better compatibility with multisite parallel import and restore.
- Fixed: Uncaught TypeError mysqli_num_rows(): Argument #1 ($result) must be of type mysqli_result during search replace.
- Fixed: Missing or corrupted Freemius data after simultaneous restore.
Highlights and improvements
The latest release now has full and tested support for multisite parallel export and import. This means that you can now simultaneously export several subsites and import without running into errors.
The only limitation now is your server resources: disk space, CPU, and RAM. If you are on a shared host or a limited server resource, performing parallel export and import will consume a lot of these resources. For best results, limit these parallel/concurrent exports and imports to 5 sites at a time.
Errors fixed
To enable this compatibility, several controls have been added.
- During parallel restore, some processes are temporarily killed by other sites to make way for critical processes, such as renaming and dropping tables. These killed processes cause errors in parallel restore. This is handled by retrying queries if they are temporarily down, so all queries should be active and return results if the database instance is restored.
- Freemius data is temporarily backed up for each subsite during the import and then restored afterward. However, the way it is stored isn’t compatible with parallel import, so it has been updated to prevent collisions during Freemius data backup and restore.
Share your thoughts!
If you have something to comment on regarding this release, we are glad to hear it.