[Bug 56706] New: AppDB does not properly separate the Bugzilla DB

[WineHQ Bugzilla]

https://bugs.winehq.org/show_bug.cgi?id=56706

Bug ID: 56706
           Summary: AppDB does not properly separate the Bugzilla DB
           Product: WineHQ Apps Database
           Version: unspecified
          Hardware: x86-64
                OS: Linux
            Status: NEW
          Severity: normal
          Priority: P2
         Component: appdb-unknown
          Assignee: [e-mail]
          Reporter: [e-mail]
      Distribution: ---

We would like to split the AppDB and Bugzilla databases onto different hosts.
But right now this is impossible due to some queries doing a joins between
bugzilla and the appdb.

These will need to be re-written to do it in a different way.

The worst offender is testData.php ShowVersionsTestingTable method on line 685.

I'm sure there are other places as well.

[Bug 56706] AppDB does not properly separate the Bugzilla DB

[WineHQ Bugzilla]

https://bugs.winehq.org/show_bug.cgi?id=56706

Jeremy Newman  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|normal                      |major

--- Comment #1 from Jeremy Newman  ---
Bumping this up in priority.

If I could split the databases for appdb and bugs into different servers then
that will surely help the performance of both sites.

[Bug 56706] AppDB does not properly separate the Bugzilla DB

[WineHQ Bugzilla]

https://bugs.winehq.org/show_bug.cgi?id=56706

Ken Sharp  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
             Blocks|                            |57151

[Bug 56706] AppDB does not properly separate the Bugzilla DB

[WineHQ Bugzilla]

http://bugs.winehq.org/show_bug.cgi?id=56706

[e-mail] changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[e-mail]

--- Comment #2 from [e-mail] ---
(In reply to Jeremy Newman from comment #1)
> Bumping this up in priority.
>
> If I could split the databases for appdb and bugs into different servers
> then that will surely help the performance of both sites.

In case this is still has bumped priority, please see:

https://gitlab.winehq.org/winehq/appdb/-/merge_requests/13

[Bug 56706] AppDB does not properly separate the Bugzilla DB

[WineHQ Bugzilla]

http://bugs.winehq.org/show_bug.cgi?id=56706

Jeremy Newman  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
           Assignee|[e-mail]        |[e-mail]
             Status|NEW                         |ASSIGNED

--- Comment #3 from Jeremy Newman  ---
With AppDB MR 13 live, there are no blockers against splitting the DB. I will
work on dumping the AppDB DB onto a new VM and switching over to that.

[Bug 56706] AppDB does not properly separate the Bugzilla DB

[WineHQ Bugzilla]

http://bugs.winehq.org/show_bug.cgi?id=56706

Jeremy Newman  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|ASSIGNED                    |RESOLVED
         Resolution|---                         |FIXED

--- Comment #4 from Jeremy Newman  ---
I've split the database VMs. The AppDB and Bugzilla MariaDB instances are now
on separate hosts. Load on one will no longer affect the other.

This can now be closed out.

[Bug 56706] AppDB does not properly separate the Bugzilla DB

[WineHQ Bugzilla]

http://bugs.winehq.org/show_bug.cgi?id=56706

Ken Sharp  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |CLOSED

--- Comment #5 from Ken Sharp  ---
Closing