Uploaded image for project: 'AdMaxLocal'
  1. AdMaxLocal
  2. AML-345

DB Creation: Slave tsacommon database have to be manually updated for replication to work

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: Aquidneck
    • Component/s: Database/Schema
    • Labels:
      None
    • Environment:

      QA Server: Optus-QA-Mysql (192.168.70.81)
      Database: tsacommon

    • Sprint:
      Sprint 6, Sprint 7

      Description

      Since we use the same global tsacommon master database configuration to create all the slave tsacommon databases as well, the slave tsacommon databases have replication triggers and few additional logging tables in them.

      For replication to work fine, these triggers and tables need to be removed manually. If this task can be automated by using a different db structure, user will not have to do the task manually.

      Attaching the drop trigger and drop tables sql files.

        Attachments

        1. drop_logging_tables.sql
          0.3 kB
          Gurpreet Singh
        2. dropTriggers.sql
          3 kB
          Gurpreet Singh

          Activity

            People

            • Assignee:
              nasiruddin.shaikh Nasiruddin Shaikh (Inactive)
              Reporter:
              gurpreet.singh Gurpreet Singh
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: