Hi Stan, sorry for the late answer. Your mail slipped my attention.
I can not tell you why MySQL fails in cluster mode. If you really need that, you have to debug yourself. If you start QMapShack with -d option all SQL error messages should be printed to the console. I know of a use case where MySQL (MariaDB) is used via network in a working environment. No severe problems so far. As the remote connection is not very good some glitches happen. So far no real corruption of the database. Personally I use a local SQLite database. That is rock solid. I have tested concurrent access to SQLite and MySQL. There is quite some code to keep the database representation in sync. HTH Oliver Am Dienstag, 5. September 2017, 18:48:27 CEST schrieb SC: > Hi Folks, > > I am doing the startup routine with qmapshack, and have had good success > with maps, dem etc. Then I turned my attention to storage and backup before > committing real data. Sqlite works easily. Mysql works if I use a > standalone db, either local or via network. > > However, if I then have the working mysql db join a cluster, the connection > from qmapshack to the db is not working. The folders do get created but are > not visible, and after closing/opening qmapshack, the db is not connected > at all (red x). I then back out the db from the cluster, but it still does > not work with qmapshack. The only use case that works for me is to use a > pure standalone mysql db. (mariadb works also). > > Can anyone elaborate on the mystery that unfolds when one uses a mysql db > that is part of a cluster? > > Why does qmapshack only work on a pure, standalone db? > > And, subject to my own testing, will this standalone use case withstand > time? It appears that if one just touches the db, it stops working with > qmapshack - just an impression. > > There is no wrong answer here: I simply need to have the storage basis in a > solid, hardened state, before spending months inputting my data. I can even > fall back to sqlite, if I have to. > > > Regards, > > Stan ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Qlandkartegt-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/qlandkartegt-users
