openSUSE admin

Any chance they were meant to be a fallback cluster, in case we wanted to run download.o.o in Provo in an emergency ?

I don't think it stores any MirrorCache related databases, that's what mirrorcache-us-db is for, no?

The databases on provo-galera seem similar to the ones we have in Nuremberg:

provo-galera1 (mariadb):~ # find /var/lib/mysql -mindepth 1 -maxdepth 1 -type d -not -name '*schema' -not -name mysql -not -name sys -printf '%f '
boosters_elgg conference_osem etherpad limesurvey matomo moodle opensuse_request_tracker redmine redmine_test suse_hackweek webforums webforums2 wiki_cn wiki_cs wiki_de wiki_el wiki_en wiki_en_test wiki_es wiki_fr wiki_hu wiki_it wiki_ja wiki_languages wiki_nl wiki_old_de wiki_old_en wiki_pl wiki_pt wiki_ru wiki_sv wiki_tr wiki_zh wiki_zh_tw wsrep xbttracker

galera1 (Galera node (MySQL)):~ # find /var/lib/mysql -mindepth 1 -maxdepth 1 -type d -not -name '*schema' -not -name mysql -not -name sys -printf '%f '
redmine_test suse_hackweek webforums wiki_cs wiki_de wiki_en wiki_en_test wiki_fr wiki_hu wiki_ja wiki_languages wiki_old_de wiki_old_en wiki_pt wiki_ru wiki_tr wiki_zh xbttracker conference_osem etherpad limesurvey matomo redmine wiki_cn wiki_el wiki_es wiki_it wiki_nl wiki_pl wiki_sv wiki_zh_tw webforums2 wsrep members mirrorcache

And without a third node, Galera isn't of much use anyways.

crameleon wrote:

I don't think it stores any MirrorCache related databases, that's what mirrorcache-us-db is for, no?

I don't know :-)
Has download.o.o completely stopped using the galera cluster?

And without a third node, Galera isn't of much use anyways.

I have no issue with removing them, I was only offering a possible reason for their presence. If we have no contingency plans that include running download.o.o in provo, there certainly does not seem to be much use for a galera cluster either.

pjessen wrote:

crameleon wrote:

I don't think it stores any MirrorCache related databases, that's what mirrorcache-us-db is for, no?

I don't know :-)
Has download.o.o completely stopped using the galera cluster?

Of course, it uses mirrordb1 / mirrordb2.

Do you know when these databases were last modified?

If they are several years old, they might be a leftover from a planned power outage in Nuremberg years ago (we temporarily served the wikis and some other services from Provo back then). However, some of the databases (I'd guess at least etherpad, limesurvey, moodle, webforums2) did not even exist back then...

I seem to remember that there was an idea to have the databases mirrored to Provo, but I'm not sure if this was really implemented. Lars and/or Darix might know more.

(Oh, and sorry for all the "might"s ;-)

cboltz wrote:

If they are several years old, they might be a leftover from a planned power outage in Nuremberg years ago

Yes, they were part of big plan having Geo cluster, but since it wasn't accomplished - Lars suggested me to reuse one node to improve performance of mirrorcache-us.o.o

So I agree we can delete 1 and 2 and rename 3 as Georg suggested.

pjessen wrote:

Has download.o.o completely stopped using the galera cluster?

Of course, it uses mirrordb1 / mirrordb2.

Currently download.o.o uses standalone MariaDB server on mirrorcache-stats.infra.o.o there is related MR in salt, I hope to merge it this week

https://gitlab.infra.opensuse.org/infra/salt/-/merge_requests/2124