Uploaded image for project: 'Artifactory Binary Repository'
  1. Artifactory Binary Repository
  2. RTFACT-27152

Adding Primary keys on all Mysql Tables

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Database
    • Labels:
      None

      Description

      We want to enable Group Replication (https://dev.mysql.com/doc/refman/8.0/en/group-replication-summary.html) for our MySQL database cluster that hosts artifactory database. Group replication provides MySQL-native means for achieving high availability and data consistency. However one of the requirement for Group replication is having a primary key for tables https://dev.mysql.com/doc/refman/8.0/en/group-replication-requirements.html

       

      We noticed that node_events_tmp and tasks table in the database do not have a primary key. This prevents us from moving our replication to use Group replication. Could you please be able to add primary key for existing tables and also future ones?

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            abshaheed Abdul Shaheed
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated: