Just to point out that database replication might not be considered a good form of backup. It copes with something like a disc crash but if, for example, a user or bug were accidentally to delete large sections of the db then that deletion would be copied to the slave database. Unless I misunderstand how replication works.
Colin On 20 September 2017 at 04:27, DaveC49 <davidcous...@bigpond.com> wrote: > Hi Art, Roger > > Just a quick comment. If you are using the MYSQL backend you can sync > databases on different machines reasonably easily using MYSQL master-slave > replication (https://dev.mysql.com/doc/refman/5.7/en/replication.html) as an > alternative to maintaining a mobile copy. > > There is a bit of a learning curve in setting it up and some maintenance if > the databases do get out of sync. I use it on a Linux desktop and my Linux > laptop to keep a number of application databases synced using SSL over my > LAN. It syncs automatically whenever the laptop is connected to the LAN. I > haven't tried syncing from a Linux box to a Windows box but it shouldn't be > too much of a problem as it is all done in MYSQL configuration as long as > the basic underlying network connectivity is there. There can be timing > issues if the databases on different machines are updated at the same time > which are not generally a problem for a single user. > > You can use the TinyCA (https://tinyca.alioth.debian.org/) to generate the > necessary SSL certificates. I set MySQL both machines up as master-master > servers so that no matter which machine I make changes to the database they > are duplicated to the other machine. > > David Cousens > > > > ----- > David Cousens > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-user > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.