Uploaded image for project: 'Infrastructure'
  1. Infrastructure
  2. INFRA-1762

Confluence Database latency is to big

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Component/s: azure, wiki
    • Labels:
      None
    • Similar Issues:

      Description

      Since we moved the confluene database on Azure, database performance drastically reduced
      https://confluence.atlassian.com/doc/performance-tuning-130289.html

        Attachments

          Activity

          olblak Olivier Vernin created issue -
          Hide
          olblak Olivier Vernin added a comment - - edited

          From previous database (OSUOSL)
          mysql> select 1 ;
          1 row in set (0.00 sec)

          From Azure (EAST2)
          mysql> select 1 ;
          1 row in set (0.07 sec)

          Show
          olblak Olivier Vernin added a comment - - edited From previous database (OSUOSL) mysql> select 1 ; 1 row in set (0.00 sec) From Azure (EAST2) mysql> select 1 ; 1 row in set (0.07 sec)
          olblak Olivier Vernin made changes -
          Field Original Value New Value
          Status Open [ 1 ] In Progress [ 3 ]
          Hide
          olblak Olivier Vernin added a comment - - edited

          From Azure(WEST2)
          1 row in set (0.03 sec)

          Show
          olblak Olivier Vernin added a comment - - edited From Azure(WEST2) 1 row in set (0.03 sec)
          Hide
          olblak Olivier Vernin added a comment -

          Same results between AZURE(WEST2) and WEST

          Show
          olblak Olivier Vernin added a comment - Same results between AZURE(WEST2) and WEST
          Hide
          olblak Olivier Vernin added a comment -

          There aren't a lot of solution
          1) We need a newer mysql server than the previous one in the Osuosl network
          2) We move confluence on azure in the same region than the database but it also means that the mail configuration should be moved to sendgrid and we may have other side effect that I don't know at the moment
          R. Tyler Croy any thought on this?

          Show
          olblak Olivier Vernin added a comment - There aren't a lot of solution 1) We need a newer mysql server than the previous one in the Osuosl network 2) We move confluence on azure in the same region than the database but it also means that the mail configuration should be moved to sendgrid and we may have other side effect that I don't know at the moment R. Tyler Croy any thought on this?
          Hide
          olblak Olivier Vernin added a comment - - edited

          We could restore the database in the WEST region https://docs.microsoft.com/en-us/azure/mysql/howto-restore-server-cli.
          We'll have to stop confluence, restore the database, and update confluence configuration with new database endpoint

          Show
          olblak Olivier Vernin added a comment - - edited We could restore the database in the WEST region https://docs.microsoft.com/en-us/azure/mysql/howto-restore-server-cli . We'll have to stop confluence, restore the database, and update confluence configuration with new database endpoint
          Hide
          rtyler R. Tyler Croy added a comment -

          I think moving Confluence into Azure and using Sendgrid is a very reasonable option, but I'm unsure if the scope of work is small enough.

          If that's viable, I say go for it

          Show
          rtyler R. Tyler Croy added a comment - I think moving Confluence into Azure and using Sendgrid is a very reasonable option, but I'm unsure if the scope of work is small enough. If that's viable, I say go for it
          Hide
          olblak Olivier Vernin added a comment -

          As a first iteration, I'll move the database in WEST region, it shouldn't take too long since the mysql database is already georedundant

          Show
          olblak Olivier Vernin added a comment - As a first iteration, I'll move the database in WEST region, it shouldn't take too long since the mysql database is already georedundant
          Hide
          olblak Olivier Vernin added a comment -

          Since I moved the database to WEST, to latency reduced to 0.2ms which is better but atlassian recommande to have a latency below 0.1.
          So I keep the ticket open for the time being

          Show
          olblak Olivier Vernin added a comment - Since I moved the database to WEST, to latency reduced to 0.2ms which is better but atlassian recommande to have a latency below 0.1. So I keep the ticket open for the time being
          olblak Olivier Vernin made changes -
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          olblak Olivier Vernin made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

            People

            Assignee:
            olblak Olivier Vernin
            Reporter:
            olblak Olivier Vernin
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: