Skip to main content

Building Low-Cost MySQL Data Nodes

  • Chapter
MySQL for the Internet of Things
  • 3058 Accesses

Abstract

Data nodes are a key component in IOT solutions. Your solution could use one or more data aggregators to send data to a database server in the cloud or one or more database servers in the solution itself. If your IOT solution uses custom-designed hardware, you may even incorporate a database server on an embedded computing component. Whichever the choice, you need to know more about using a database server in your solution.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 29.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 37.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Notes

  1. 1.

    But can accept USB-based memory sticks and hard drives.

  2. 2.

    Micro Secure Digital (micro SD): a small removable memory drive. See http://en.wikipedia.org/wiki/Secure_Digital .

  3. 3.

    My alma mater has suffered a similar transition. I mourn for the loss of knowledge.

  4. 4.

    My first real computer was an IBM PCjr. I followed it by building my own IBM PC AT computer, complete with a 10MB hard drive. Ah, those were the glory days of personal computers!

  5. 5.

    Places like your couch, favorite recliner, patio, coffee bar, and so on.

  6. 6.

    Be sure to select a cable that supports device sensing. If your Lapdock does not power on when the Raspberry Pi is connected, it is most likely the HDMI cable. Try another cable.

  7. 7.

    Be sure to get permission before “borrowing” a cable from a friend or spouse—it won’t be usable as a standard cable when you’re finished modifying it.

  8. 8.

    Not to be confused with noob, which is a bit derogatory. See https://en.wiktionary.org/wiki/noob .

  9. 9.

    The operating system is free. You’re just paying for the convenience of someone having formatted and installed the image on the card for you.

  10. 10.

    They go by so fast; it is unlikely you can read them anyway. Basically, they’re noise unless there is an error, and those usually appear in the last few lines displayed.

  11. 11.

    Raspberry Pi images were generated with fbgrab. You can install it with sudo apt-get install fbgrab.

  12. 12.

    What does vi mean? If you’ve ever had the pleasure of trying to learn it for the first time, you may think it means “virtually impossible,” because the commands are terse (by design) and difficult to remember. But seriously, vi is short for vim or Vi Improved text editor. The name suggests that the original editor may very well have been completely impossible to use!

  13. 13.

    A highly technical term for when computers don’t do what you think they should.

  14. 14.

    http://alextgalileo.altervista.org/package-repo-configuration-instructions.html

  15. 15.

    https://github.com/ChuckBell/MySQL_Connector_Arduino/blob/master/extras/MySQL_Connector_Arduino_Reference_Manual.pdf

  16. 16.

    https://github.com/ChuckBell/MySQL_Connector_Arduino/blob/master/extras/MySQL_Connector_Arduino_Reference_Manual.pdf

  17. 17.

    Python experts often refer to themselves using this term. It is reserved for the most avid and experienced Python programmers.

Author information

Authors and Affiliations

Authors

Electronic Supplementary Material

Below is the link to the electronic supplementary material.

Source_Ch06.zip (zip 2 kb)

Rights and permissions

Reprints and permissions

Copyright information

© 2016 Charles Bell

About this chapter

Cite this chapter

Bell, C. (2016). Building Low-Cost MySQL Data Nodes. In: MySQL for the Internet of Things. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1293-6_6

Download citation

Publish with us

Policies and ethics