Hi there,
Thanks for reaching out to DigitalOcean Support. I understand you are trying to import large database to managed database and having issues with sqlrequireprimary_key.
We currently have the variable sqlrequireprimary_key turned on to enable user create primary key on tables to avoid replication issue, node replication, etc. This has worked in the past and was not enforced but experience, time, and the information we have gathered from frequent issues ex. time it takes to create a new node for a service from a backup with large tables.
Primary keys are essential for certain management operations also for services that do not have standby or read replica service; any node replacements are performed by first bringing up a standby to which all data from old master is replicated and without primary keys this process may take exceedingly long or fail, Also failed nodes are replaced by restoring backup, which requires playing back binary logs and that may not work if large tables without primary keys have had recent changes.
If you decide you to proceed without Primary Key, you can proceed with
SET SESSION sqlrequireprimary_key = 1;
Note this is for a single session though. Once you log out, you would need to run this again before you could do an import again without it being required.
The below URL has more information
https://www.digitalocean.com/docs/databases/mysql/how-to/create-primary-keys/#how-digitalocean-uses-primary-keys%3Chttps://www.digitalocean.com/docs/databases/mysql/how-to/create-primary-keys/%3E
Please let us know if you have additional questions/concerns. We would be happy to assist you.
Regards
Priyanka
DigitalOcean Support
Question
