Is Weewx working with MariaDB?

[Luc Heijst]

Hello all,

I'm about to install weewx on the Debian 8 (Jessie) platform. 

On this platform the MySQL database still is supported, but I think it is better in the near future to migrate to MariaDB.

Some sources say MariaDB is fully compatible with MySQL, but right now I can't get MariaDB working with weewx.

My question to all is: has anybody got weewx working with database MariaDB?

If yes, we would like to know what has to be done to achieve this.

Thanks in advance.

Luc

[Shaggy]

Luc,

I run Weewx 3.1.0 on an RPi, writing to a MariaDB database on a Synology NAS.  When transferring the data from a MySQL database running on a QNAP NAS to MariaDB on the Synology, I didn't have to make any configuration changes (other than IP address and login details) and it worked straight off.

Magnus.

[Luc Heijst]

Thanks Magnus,

A remote database, another possibillity. I own two Synologies on which I can install MariaDB.

Currently I run weewx on my Synology NAS with MySQL, PhpMyAdmin and Apache. 

To learn a bit about debian linux I will try to run weewx on a RPI with MariaDB, Adminer and lighttpd.

When that works I will try to get it done on the Synology. But from experience I know that linux plastform is much harder.

Luc

[Luc Heijst]

Update

I experimented a week with weewx on my new Raspberry Pi 2B. 

Installing MariaDB wasn't a problem, but I couldn't get Adminer work (neither with Apache2 nor with Lighttpd).

At last I had a working combination of MariaDB, Apache2 and phpMyAdmin.

Tests with the storage of all 50,000+ historical records of my KlimaLogg Pro showed storage times of 9 hours for a MariaDB and 2 hours for a SqLite database.

This made me switch to Sqlite databases.

On my RPI 2B I now run Weewx 3.2.1, ws28xx and klimalogg drivers, Sqlite3, lighttpd and phpLiteAdmin

On my Synology DS209+II I run weewx 3.2.1, ws28xx and klimalogg drivers, Sqlite3, Apache2 (part of the Synology web services) and phpLiteAdmin

Luc