Hi,
Currently I am on Ubuntu 18.04, CQRlog 2.5.2(001) and MariaDB 10.5.11 and I am planning to upgrade to Ubuntu 20.04.
My cqrlog database on laptop replicate to database on raspberrypi in both directions.
CQRlog on latop is configured to use ip address and port 3306 instead of 'Save log data on local machine'.
As I am not any kind of coder it cost me some effort and time to get it worked. AFAIK default sql for Ubuntu 20.04 is MySQL, not MariaDB.
So, the question is: Is any safe way to save my current MariaDB configuration including replication to raspberrypi and later restore it after upgrade to 20.04? Or is nothing to worry about?
Slaveck, SP3RXO
HI !
In case of Fedora linux upgrading to higher version is done with upgrading tool. If a program like MariaDB was installed to previous system it will be upgraded to new one. Unless you are doing a clean new install of new version everything is kept as it is.
I mean if you had MariaDB it does not change to Mysql.
I do not know how Ubuntu upgrade works. I guess it could work similar way, but you have to check that.
Do not do a clean new install with Ubunto 20 if you do not have to. Upgrading, if it is possible, should preserve also all other settings from old system than just MariaDB.
If you have to make a new clean install you should replace default Mysql with MariaDB. Then make full sql server backup from old MariaDB and export it to new one. Be sure that export has every table and view etc. Then I assume the replication settings are also transferred.
I have never done this kind of backup/restore, but I have done several Fedora version upgrades and they all have kept all settings. Including replication routines as I do have same two direction replication between two PCs like you describe.
Do a proper whole HD backup first, then you can try what happens and return back to old system and try again if upgrading fails at first go.
--
Saku
OH1KH
Hi Saku,
Thanks for all advices and comments. I will do a full backup before the upgrade.
<p>SlaveckM, SP3RXO</p>