DB table structure on Multisite (GDPR compliance)

  • Resolved janthiel

    (@janthiel)


    5 years, 5 months ago

    Hey Milan,

    we run several multisite installations and gave your plugin a try.
    First thing we were a bit irritated by is the database design. Is it correct and intentional that all sites will share the same four databse tables?

    wp_gdmaq_emails
wp_gdmaq_log
wp_gdmaq_log_email
wp_gdmaq_queue

    As we run seperate clients on one multisite installation, we have to enforce logical data separation following GDPR requirements when working with personal information. Having all data stored in one table will not comply with these legal requirements.

    In addition to the legal aspect the single table approach makes housekeeping quite hard. In particular deleting a site and all its prefixed tables will not prune all the related entries from your global tables. As the plugin deactivation routines will not run on site deletion.

    Is there any way to run your plugin in a “one set of tables per site” mode?

    Which would then use a table structure like this:

    wp_2_gdmaq_emails
wp_2_gdmaq_log
wp_2_gdmaq_log_email
wp_2_gdmaq_queue
wp_3_gdmaq_emails
wp_3_gdmaq_log
wp_3_gdmaq_log_email
wp_3_gdmaq_queue

    Thanks and best regards,

    Jan

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Milan Petrovic

    (@gdragon)

    5 years, 5 months ago

    Hi,

    Right now there is no way to do that. The initial plan was to have global control for multisite available, so single set of tables would be used, and it was left like that. Making global settings possible has proven quite difficult, but the database structure remained as it is now. The problem is that even if the plugin is changed for each site to use its own tables, there would be no way to easily migrate data from centralized tables.

    I will implement the change of structure to individual site tables in one of the future versions, but I can’t promise when that will exactly happen, it requires quite a lot of changes and migration path too.

    Regards,
    Milan

    Thread Starter janthiel

    (@janthiel)

    5 years, 5 months ago

    Hey Milan,

    thank you very much for your detailed explanation and your open mind.

    I will keep an eye on the changelog and re-evaluate the plugin once it’s an appropriate timing. If you don’t mind, feel free to drop a note here when the time is right. I would highly appreciate it.

    Have a great evening!

    Jan

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘DB table structure on Multisite (GDPR compliance)’ is closed to new replies.