I have asked the question at Serverfault but it was suggested to take it to the DB specific forum. So here goes.
I'm tasked with migrating a bunch of MariaDB databases as well as some PHP and WSGI intranet applications from a RHEL7 host to RHEL8. During the transition / testing period the apps will run on both hosts in parallel but of course must access the same DB in order to stay up to date. Since the apps currently just use "localhost" for their DB host it would be convenient if they could continue to do that when transferred to the RHEL8 host, but that requires the DB on both hosts to be in sync with read/rite access.
Now if this all were done right and professionally, the host would have a central config file or environment variable pointing to the correct DB, so the final migration step on the RHEL8 server would be as simple as transferring the DBs using mysqldump etc, setting the single central DB info to the new host and be done. Suffice it to say that the whole setup is the surprisingly stable work of a bunch of in-company hobbyists (because we lack the proper IT resources), which includes me as an administrator.
Changing the currently hard-coded DB connections in the apps from the old to the new servers wouldn't be that much work. I just have to tell the app owners that they will have to do that within a very specific short time frame at some point. I'm just looking for a possibly easier strategy.
All web apps and the MariaDB server are on the same host and will be moved together to a new host. As I mentioned, all apps refer to the DB on "localhost".
DB version 10.3.35 is simply what was installed on the server by IT when they initially set up the VM. Probably need to do a yum upgrade. Except for my Python venvs I'll just stick to whatever RHEL8 deems up-to-date.
Don't know yet if I will make all end users move to new URL or have IT do a DNS "rename" of the new host. From my experience our IT prefers to not make DNS changes.