Beginning sensor networks with Arduino and Raspberry Pi : learn how to make Arduino and Raspberry Pi-based sensor networks

__Beginning Sensor Networks with Arduino and Raspberry Pi__ teaches you how to build sensor networks with Arduino, Raspberry Pi, and XBee radio modules, and even shows you how to turn your Raspberry Pi into a MySQL database server to store your sensor data! First you'll learn about the different types of sensors and sensor networks, including how to build a simple XBee network. Then you'll walk through building an Arduino-based temperature sensor and data collector, followed by building a Raspberry Pi-based sensor node. Next you'll learn different ways to store sensor data, including writing to an SD card, sending data to the cloud, and setting up a Raspberry Pi MySQL server to host your data. You even learn how to connect to and interact with a MySQL database server directly from an Arduino! Finally you'll learn how to put it all together by connecting your Arduino sensor node to your new Raspberry Pi database server. If you want to see how well Arduino and Raspberry Pi can get along, especially to create a sensor network, then __Beginning Sensor Networks with Arduino and Raspberry Pi__ is just the book you need. What you’ll learn* How to build sensor nodes with both Arduino and Raspberry Pi! * What is XBee? * What methods you have for storing sensor data * How you can host your data on the Raspberry Pi * How to get started with the MySQL database connector for Arduino * How to build database enabled sensor networks Who this book is for Electronics enthusiasts, Arduino and Raspberry Pi fans, and anyone who wants hands-on experience seeing how these two amazing platforms, Arduino and Raspberry Pi, can work together with MySQL. Table of Contents1. Introduction to Sensor Networks2. Tiny Talking Modules: An Intro to Xbee Wireless Modules3. Arduino-Based Sensor Node4. Rapberry Pi-based Sensor Notes 5. Where to Put It All: Storing Sensor Data6. Turning Your Raspberry Pi into a Database Server 7. MySQL and Arduino: United at Last! 8. Building Your Network: Arduino Wireless Aggregator + Wireless Sensor Node + Raspberry Pi Server9. Planning Wireless Sensor Networks10. Shopping List Title......Page 2 Copyright......Page 3 Dedication......Page 4 Contents at a Glance......Page 5 Contents......Page 6 About the Author......Page 12 About the Technical Reviewer......Page 13 Acknowledgments......Page 14 Introduction......Page 15 Examples of Sensor Networks......Page 19 The Topology of a Sensor Network......Page 24 Wireless Networks......Page 26 Data Nodes......Page 27 Sensors......Page 28 How Sensors Measure......Page 29 Examples of Sensors......Page 33 Summary......Page 36 What Is an XBee?......Page 38 Choosing XBee Modules......Page 39 Interacting with an XBee-ZB Module......Page 41 Pin Layout......Page 45 Configuring Modules......Page 46 For More Information......Page 56 Loading the Firmware for the Modules......Page 57 Capturing Serial Numbers......Page 59 Configuring the Coordinator......Page 60 Configuring the Router......Page 61 Let the Chat Begin......Page 62 Building an XBee-ZB Mesh Network......Page 64 Forming Test Messages......Page 65 Testing the Network......Page 67 Component Shopping List......Page 71 Things to Check......Page 72 Common Issues......Page 73 Summary......Page 74 What Is an Arduino?......Page 76 Arduino Models......Page 77 Arduino Clones......Page 83 Where to Buy......Page 90 The Arduino IDE......Page 92 Project: Hardware “Hello, World!”......Page 95 Hosting Sensors with Arduino......Page 101 Project: Building an Arduino Temperature Sensor......Page 102 Hardware Setup......Page 103 Writing the Sketch......Page 105 Test Execution......Page 109 XBee Sensor Node......Page 110 Arduino with XBee Shield......Page 116 Testing the Final Project......Page 125 Component Shopping List......Page 126 Summary......Page 127 What Is a Raspberry Pi?......Page 129 Noble Origins......Page 130 Models......Page 131 A Tour of the Board......Page 132 Required Accessories......Page 134 Recommended Accessories......Page 135 Where to Buy......Page 138 Installing a Boot Image......Page 141 Booting Up......Page 143 GPIO Pin Mapping......Page 147 Required Software......Page 150 Project: Hardware “Hello, World!”......Page 151 Project: Building a Raspberry Temperature Sensor Node......Page 157 Hardware Setup......Page 158 Testing the Hardware......Page 160 Software Setup......Page 161 Testing the Sensor......Page 164 Project: Building a Raspberry Barometric Pressure Sensor Node......Page 165 Hardware Setup......Page 167 Testing the Hardware......Page 168 Software Setup......Page 169 Testing the Sensor......Page 171 Project: Creating a Raspberry Pi Data Collector for XBee Sensor Nodes......Page 172 Hardware......Page 173 Software......Page 175 Testing the Final Project......Page 178 Component Shopping List......Page 179 Summary......Page 180 Storage Methods......Page 182 Local Storage Options for the Arduino......Page 183 SD Card......Page 184 Project: Saving Data in Nonvolatile Memory......Page 185 Project: Writing Data to an SD Card......Page 196 Local Storage Options for the Raspberry Pi......Page 206 Project: Writing Data to Files......Page 207 Remote Storage Options......Page 208 Storing Data in the Cloud......Page 209 Component Shopping List......Page 232 Summary......Page 233 What Is MySQL?......Page 234 Getting Started with MySQL......Page 237 How and Where MySQL Stores Data......Page 238 How to Start, Stop, and Restart MySQL......Page 242 Creating Users and Granting Access......Page 243 MySQL and Python—MySQL Utilities......Page 244 Building a Raspberry Pi MySQL Server......Page 247 Partitioning and Formatting the Drive......Page 248 Setting Up Automatic Drive Mounting......Page 251 Project: Installing MySQL Server on a Raspberry Pi......Page 253 Advanced Project: Using MySQL Replication to Back Up Your Sensor Data......Page 259 Summary......Page 268 Introducing Connector/Arduino......Page 270 Hardware Requirements......Page 271 How to Get MySQL Connector/Arduino......Page 274 Database Setup......Page 277 Setting Up the Arduino......Page 279 Starting a New Sketch......Page 280 Testing the Sketch......Page 283 Troubleshooting Connector/Arduino......Page 289 MySQL Server Configuration......Page 290 MySQL User Account Problems......Page 291 Networking Configuration......Page 293 Connector Installation......Page 294 Other......Page 295 Library Files......Page 296 Field Structure......Page 298 Public Methods......Page 299 Example Uses......Page 300 Project: Building a MySQL Arduino Client......Page 303 Hardware Setup......Page 304 Setting Up the Sensor Database......Page 306 Writing the Code......Page 307 Test Execution......Page 309 For More Fun......Page 311 Project Example: Inserting Data from Variables......Page 312 Displaying a Result Set in the Serial Monitor......Page 313 Writing Your Own Display Method......Page 314 Example: Getting a Lookup Value from the Database......Page 317 Summary......Page 318 Data-Aggregate Nodes......Page 320 Local-Storage Data Aggregator......Page 321 Project: Data-Aggregate Node with Local Storage......Page 322 Project: Arduino Data-Aggregate Node with Database Storage......Page 343 Project: Raspberry Pi Data-Aggregate Node with Database Storage......Page 355 Component Shopping List......Page 363 Summary......Page 364 Considerations for Data-Aggregate Nodes......Page 366 Considerations for Sensor Network Databases......Page 370 Other Considerations......Page 374 Wired Or Wireless?......Page 379 Arduino or Raspberry Pi?......Page 380 Alternative Hosts......Page 382 Planning the Nodes......Page 388 Cost Considerations......Page 389 Conclusion......Page 391 Summary......Page 392 Appendix: Shopping List......Page 394 Index......Page 397 Annotation Beginning Sensor Networks with Arduino and Raspberry Pi teaches you how to build sensor networks with Arduino, Raspberry Pi, and XBee radio modules, and even shows you how to turn your Raspberry Pi into a MySQL database server to store your sensor data! First you'll learn about the different types of sensors and sensor networks, including how to build a simple XBee network. Then you'll walk through building an Arduino-based temperature sensor and data collector, followed by building a Raspberry Pi-based sensor node. Next you'll learn different ways to store sensor data, including writing to an SD card, sending data to the cloud, and setting up a Raspberry Pi MySQL server to host your data. You even learn how to connect to and interact with a MySQL database server directly from an Arduino! Finally you'll learn how to put it all together by connecting your Arduino sensor node to your new Raspberry Pi database server. If you want to see how well Arduino and Raspberry Pi can get along, especially to create a sensor network, then Beginning Sensor Networks with Arduino and Raspberry Pi is just the book you need. What you'll learn How to build sensor nodes with both Arduino and Raspberry Pi! What is XBee? What methods you have for storing sensor data How you can host your data on the Raspberry Pi How to get started with the MySQL database connector for Arduino How to build database enabled sensor networks Who this book is for Electronics enthusiasts, Arduino and Raspberry Pi fans, and anyone who wants hands-on experience seeing how these two amazing platforms, Arduino and Raspberry Pi, can work together with MySQL. Table of Contents 1. Introduction to Sensor Networks 2. Tiny Talking Modules: An Intro to Xbee Wireless Modules 3. Arduino-Based Sensor Node 4. Rapberry Pi-based Sensor Notes 5. Where to Put It All: Storing Sensor Data 6. Turning Your Raspberry Pi into a Database Server 7. MySQL and Arduino: United at Last! 8. Building Your Network: Arduino Wireless Aggregator + Wireless Sensor Node + Raspberry Pi Server 9. Planning Wireless Sensor Networks 10. Shopping List The first book on building sensor networks with both Arduino and Raspberry Pi The first book ever to combine Arduino and Raspberry Pi for enthusiasts! Real-world examples that built as the reader goes along