Sync data with online ubuntu server and Raspberry pi

[kidNeo]

Hi guys im newbie and i do not know if it can be done or not but it worth to ask.

I installed partkeepr on online ubuntu server , but i need another version (same database and .. ) on my raspberry pi for local use.

but i need to know how to sync data between ubuntu server (Online) with raspberry pi (Local)

[Gasman2014]

Can you not access the server hosted PartKeepr database from the pi via a web browser - after all, that is kind of the point of PartKeepr? Otherwise you can dump the sql data from the server instance and import it into the pi. server$ mysqldump -u root -p path_to_datbase > output.txt And the re-import I into the pi. pi$ mysql -u root -p ‘partkeeprDatabase’ < output.txt The instances will obviously not remain in sync unless you re-sync them back again. Also, it will not sync the ‘ancillary stuff - like images/datasheets etc. For that, you need to synchronise the ‘data’ directory. See here for more info. https://wiki.partkeepr.org/wiki/Direct_Database_Access <https://wiki.partkeepr.org/wiki/Direct_Database_Access>

…

On 19 May 2021, at 11:22, aMirpA3c0de ***@***.***> wrote: Hi guys im newbie and i do not know if it can be done or not but it worth to ask. I installed partkeepr on online ubuntu server , but i need another version (same database and .. ) on my raspberry pi for local use. but i need to know how to sync data between ubuntu server (Online) with raspberry pi (Local) — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#1215>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACADFONAKFSN5FTOWYPNLPTTOOGPXANCNFSM45EK7HYA>.

[christianlupus]

I do not get the point here as well. Why do you need the local mirror, @jaheshyafte?

If it is a speed issue, you might think of a caching proxy between you and the server.

Apart from that it highly depends on the setup of the server (what database, do you have root rights, ...?). You could (but this is not trivial!) created a shared file system (like e.g. glusterfs) for the file storage of partkeepr and a replicated database (see here). But as I already wrote, this is no trivial task to achieve.

[ambiamber]

One reason for having a mirror is fault-tolerance. If one system goes down the other can still function.
Mariadb supports replication
The data can be replicated using Syncthing.