• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Using MariaDB on NetPi
#8
Quote:It is noted about the write cycles for these SD cards. Im not sure how to get around this issue as the vessel will not always have an internet connection. So while it is out of range it needs to record the information somewhere. If it had a constant internet connection we could just connect directly to the azure server.

Do you have any other suggestions for recording telemetry on the NetPi?

Well I don't know if the system can detect if the device has internet connectivity or not in any case.

My understanding is that if you are accessing the database from remote and call a write command from there I am pretty sure the mariadb will first of all do a write access to the database file on the file system and synching later. So the "bad" write for the SD card you will not be able to suppress. But correct me if I am wrong.

Fact is that if you know alreay today you have permament writes to the SD card it will fail. The last tests I did with the current used netPI SD from SANDISK showed me 20TBytes that I was able to write until I saw first write errors. But I can also tell you that I have written 1GByte big files during my tests always. With a database it will write some subsequent and smaller packages for sure and I cannot tell you how the SD card performs then.

So in this case I just can recommend to use a different type of SD card from company Swissbit for example of type pSLC. https://www.swissbit.com/en/
You never fail until you stop trying.“, Albert Einstein (1879 - 1955)

  Reply


Messages In This Thread
Using MariaDB on NetPi - by philump - January-7th-2020, 05:52 AM
RE: Using MariaDB on NetPi - by Armin@netPI - January-7th-2020, 07:50 AM
RE: Using MariaDB on NetPi - by philump - January-7th-2020, 10:04 PM
RE: Using MariaDB on NetPi - by Armin@netPI - January-8th-2020, 07:42 AM
RE: Using MariaDB on NetPi - by Armin@netPI - January-8th-2020, 07:55 AM
RE: Using MariaDB on NetPi - by Armin@netPI - January-8th-2020, 08:06 AM
RE: Using MariaDB on NetPi - by Armin@netPI - January-8th-2020, 08:12 AM
RE: Using MariaDB on NetPi - by Armin@netPI - January-7th-2020, 08:29 AM
RE: Using MariaDB on NetPi - by Armin@netPI - January-7th-2020, 08:46 AM
RE: Using MariaDB on NetPi - by Armin@netPI - January-8th-2020, 07:27 AM
RE: Using MariaDB on NetPi - by Armin@netPI - January-8th-2020, 08:21 AM
RE: Using MariaDB on NetPi - by philump - January-8th-2020, 11:52 AM
RE: Using MariaDB on NetPi - by Armin@netPI - January-8th-2020, 12:14 PM
RE: Using MariaDB on NetPi - by philump - January-8th-2020, 09:41 PM
RE: Using MariaDB on NetPi - by philump - January-9th-2020, 12:01 AM
RE: Using MariaDB on NetPi - by Armin@netPI - January-9th-2020, 06:36 AM
RE: Using MariaDB on NetPi - by Armin@netPI - January-9th-2020, 06:39 AM
RE: Using MariaDB on NetPi - by philump - January-10th-2020, 07:17 AM
RE: Using MariaDB on NetPi - by Armin@netPI - January-10th-2020, 07:51 AM
RE: Using MariaDB on NetPi - by Armin@netPI - January-10th-2020, 07:57 AM
RE: Using MariaDB on NetPi - by philump - January-13th-2020, 02:55 AM
RE: Using MariaDB on NetPi - by Armin@netPI - January-13th-2020, 06:47 AM

Forum Jump:


Users browsing this thread: 2 Guest(s)