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

DB Creation Script: Port 3306 set for all rows in tsacommon.databaseInstances table

          Details

          • Type: Bug
          • Status: Closed
          • Priority: Minor
          • Resolution: Fixed
          • Affects Version/s: 1.1.1
          • Fix Version/s: 1.1.1
          • Component/s: Installation Scripts
          • Labels:
            None
          • Environment:

            Server: optus-qa-mysql

            DB Instace: tsacommon-01-write

            Database: tsacommon

            Table: databaseInstances

            Description

            Steps:

            1. Log into tsacommon global database and execute following query

            select id,name,'database',host,port,access from databaseInstances;

            ------------------------------------------------------------------------+

            id name database host port access

            ------------------------------------------------------------------------+

            1 global-tsacommon-master database tsacommon-01-write 3306 rw
            2 global-sesystem database sesystem-01-write 3306 rw
            3 global-staging database staging-01-write 3306 rw
            4 global-logging database logging-01-write 3306 rw
            5 global-tmp database tmp-01-write 3306 rw
            6 global-reportservice database reportservice-01-write 3306 rw
            7 global-cluster database cluster-01-write 3306 rw
            8 dwh-1 database dwh-01-write 3306 rw
            14 acct-tsacommon-repl-1 database acctdb-01-write 3306 ro
            15 acct-st-tracker-1 database acctdb-01-write 3306 rw
            16 acct-warehouse-1 database acctdb-01-write 3306 rw
            17 acct-logging-1 database acctdb-01-write 3306 rw
            18 acct-tmp-1 database acctdb-01-write 3306 rw
            19 global-ccc database ccc-01-write 3306 rw
            20 global-bidmanagerservice database bidmanagerservice-01-write 3306 rw
            33 global-alertservice database alertservice-01-write 3306 rw
            34 global-thresholdservice database thresholdservice-01-write 3306 rw
            39 global-keywords database keywords-01-write 3306 rw
            41 global-clients database clients-01-write 3306 rw
            61 acct-content-google-1 database acctdb-01-write 3306 rw
            62 dwh-2 database dwh-02-write 3306 rw
            63 acct-tsacommon-repl-2 database acctdb-02-write 3306 ro
            64 acct-st-tracker-2 database acctdb-02-write 3306 rw
            65 acct-warehouse-2 database acctdb-02-write 3306 rw
            66 acct-logging-2 database acctdb-02-write 3306 rw
            67 acct-tmp-2 database acctdb-02-write 3306 rw
            68 acct-content-google-2 database acctdb-02-write 3306 rw

            ------------------------------------------------------------------------+

            The database ports should not be 3306 by default. Each database instance must use the port assigned.

              Attachments

                Activity

                  People

                  • Assignee:
                    rgardner Ross Gardner
                    Reporter:
                    gurpreet.singh Gurpreet Singh
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    0 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: