[GNC] Using a mysql database?

[Craig Van Tassle]

I have been using GnuCash with a MySQL database. I used it for the 
ability to replicate to an offsite backup/slave.
That feature has saved me a number of times.

Local LAN is very fast. Even over a slow WAN connection it's pretty fast 
as long as I keep the Database limited to about a year.
If I kept more then 3 years of moderate personal use, then it would 
start to slow down but not badly.


On 2019-03-12 20:14, Joseph Vernice wrote:
> Been using MySQL DB for gnu cash for many years, mainly because of
> security. Never had a problem. Very reliable and fast on my lan server.
> Not sure how fast over internet.
> 
> 
> On Tue, Mar 12, 2019 at 7:37 PM John Ralls <jralls at ceridwen.us> wrote:
> 
>> 
>> 
>> > On Mar 12, 2019, at 3:39 PM, Jacob Larsen <jacob at larsen.net> wrote:
>> >
>> > Hi
>> >
>> > How reliable is my data if I move from an XML file to a mysql database?
>> I just tried saving my books in a mysql (MariaDB) database, reload 
>> from the
>> database, and then saving back to an XML file. The files are of the 
>> same
>> size, and they have a large chunk that is identical on both sides in 
>> my
>> difftool. But there is also a large chunk that differs, so most likely 
>> the
>> order is shuffled. I started xmldiff on it just to see what it finds, 
>> but
>> that tool has not yet returned.
>> >
>> > Does anyone here know if there are any issues with data reliability when
>> saving data in a mysql database?
>> >
>> > Also, do you happen to know a difftool for xml files that runs faster
>> than xmldiff? I started xmldiff on the 2x50MB (uncompressed) files I 
>> have
>> lying around, and it is still running for the last hour or so.
>> >
>> 
>> Jacob,
>> 
>> The list of open SQL backend bugs is
>> https://bugs.gnucash.org/buglist.cgi?bug_status=NEW&bug_status=ASSIGNED&bug_status=NEEDINFO&bug_status=REOPENED&component=Backend%20-%20SQL&list_id=3199&query_format=advanced.
>> AFAICT none affect data integrity.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -----
>> 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 at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.