Author: Charles Bell
Publisher: Apress
ISBN: 143025825X
Category : Computers
Languages : en
Pages : 358
Book Description
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.
Building Wireless Sensor Networks Using Arduino
Author: Matthijs Kooijman
Publisher: Packt Publishing Ltd
ISBN: 1784397156
Category : Computers
Languages : en
Pages : 192
Book Description
Leverage the powerful Arduino and XBee platforms to monitor and control your surroundings About This Book Build your own low-power, wireless network using ready-made Arduino and XBee hardware Create a complex project using the Arduino prototyping platform A guide that explains the concepts and builds upon them with the help of examples to form projects Who This Book Is For This book is targeted at embedded system developers and hobbyists who have some working knowledge of Arduino and who wish to extend their projects using wireless connectivity. What You Will Learn Interact with XBee boards using the XCTU program on Windows, OS X, or Linux Make your Arduino boards communicate wirelessly, using XBee modules in the advanced API mode Centrally collect and store measured sensor data, in the cloud or your own database Connect the coordinator Arduino to the Internet and send data to web services Control your environment automatically, based on sensor input from your network Interact with off-the-shelf ZigBee Home Automation devices Make your devices battery-powered and let them sleep to get months or even years of battery life In Detail Arduino has been established as the de facto standard microcontroller programming platform, being used for one-off do-it-yourself projects as well as prototypes for actual products. By providing a myriad of libraries, the Arduino community has made it very easy to interact with pretty much any piece of hardware out there. XBee offers a great range of low-power wireless solutions that are easy to work with, by taking all of the complexity of wireless (mesh) networking out of your hands and letting you focus on what to send without worrying about the how. Building wireless sensor networks is cost-effective as well as efficient as it will be done with Arduino support. The book starts with a brief introduction to various wireless protocols, concepts, and the XBee hardware that enables their use. Then the book expands to explain the Arduino boards to you, letting them read and send sensor data, collect that data centrally, and then even control your home from the Internet. Moving further more advanced topics such as interacting through the standard Zigbee Home Automation protocol, or making your application power-efficient are covered. By the end of the book, you will have all the tools needed to build complete, real-world solutions. Style and approach A hands-on guide, featuring a single home automation project that can be built as described or with endless variations. Every step is illustrated with complete examples and screenshots, allowing you to build the examples swiftly.
Publisher: Packt Publishing Ltd
ISBN: 1784397156
Category : Computers
Languages : en
Pages : 192
Book Description
Leverage the powerful Arduino and XBee platforms to monitor and control your surroundings About This Book Build your own low-power, wireless network using ready-made Arduino and XBee hardware Create a complex project using the Arduino prototyping platform A guide that explains the concepts and builds upon them with the help of examples to form projects Who This Book Is For This book is targeted at embedded system developers and hobbyists who have some working knowledge of Arduino and who wish to extend their projects using wireless connectivity. What You Will Learn Interact with XBee boards using the XCTU program on Windows, OS X, or Linux Make your Arduino boards communicate wirelessly, using XBee modules in the advanced API mode Centrally collect and store measured sensor data, in the cloud or your own database Connect the coordinator Arduino to the Internet and send data to web services Control your environment automatically, based on sensor input from your network Interact with off-the-shelf ZigBee Home Automation devices Make your devices battery-powered and let them sleep to get months or even years of battery life In Detail Arduino has been established as the de facto standard microcontroller programming platform, being used for one-off do-it-yourself projects as well as prototypes for actual products. By providing a myriad of libraries, the Arduino community has made it very easy to interact with pretty much any piece of hardware out there. XBee offers a great range of low-power wireless solutions that are easy to work with, by taking all of the complexity of wireless (mesh) networking out of your hands and letting you focus on what to send without worrying about the how. Building wireless sensor networks is cost-effective as well as efficient as it will be done with Arduino support. The book starts with a brief introduction to various wireless protocols, concepts, and the XBee hardware that enables their use. Then the book expands to explain the Arduino boards to you, letting them read and send sensor data, collect that data centrally, and then even control your home from the Internet. Moving further more advanced topics such as interacting through the standard Zigbee Home Automation protocol, or making your application power-efficient are covered. By the end of the book, you will have all the tools needed to build complete, real-world solutions. Style and approach A hands-on guide, featuring a single home automation project that can be built as described or with endless variations. Every step is illustrated with complete examples and screenshots, allowing you to build the examples swiftly.
Building Wireless Sensor Networks
Author: Robert Faludi
Publisher: "O'Reilly Media, Inc."
ISBN: 1449302742
Category : Technology & Engineering
Languages : en
Pages : 322
Book Description
Get ready to create distributed sensor systems and intelligent interactive devices using the ZigBee wireless networking protocol and Series 2 XBee radios. By the time you're halfway through this fast-paced, hands-on guide, you'll have built a series of useful projects, including a complete ZigBee wireless network that delivers remotely sensed data. Radio networking is creating revolutions in volcano monitoring, performance art, clean energy, and consumer electronics. As you follow the examples in each chapter, you'll learn how to tackle inspiring projects of your own. This practical guide is ideal for inventors, hackers, crafters, students, hobbyists, and scientists. Investigate an assortment of practical and intriguing project ideas Prep your ZigBee toolbox with an extensive shopping list of parts and programs Create a simple, working ZigBee network with XBee radios in less than two hours -- for under $100 Use the Arduino open source electronics prototyping platform to build a series of increasingly complex projects Get familiar with XBee's API mode for creating sensor networks Build fully scalable sensing and actuation systems with inexpensive components Learn about power management, source routing, and other XBee technical nuances Make gateways that connect with neighboring networks, including the Internet
Publisher: "O'Reilly Media, Inc."
ISBN: 1449302742
Category : Technology & Engineering
Languages : en
Pages : 322
Book Description
Get ready to create distributed sensor systems and intelligent interactive devices using the ZigBee wireless networking protocol and Series 2 XBee radios. By the time you're halfway through this fast-paced, hands-on guide, you'll have built a series of useful projects, including a complete ZigBee wireless network that delivers remotely sensed data. Radio networking is creating revolutions in volcano monitoring, performance art, clean energy, and consumer electronics. As you follow the examples in each chapter, you'll learn how to tackle inspiring projects of your own. This practical guide is ideal for inventors, hackers, crafters, students, hobbyists, and scientists. Investigate an assortment of practical and intriguing project ideas Prep your ZigBee toolbox with an extensive shopping list of parts and programs Create a simple, working ZigBee network with XBee radios in less than two hours -- for under $100 Use the Arduino open source electronics prototyping platform to build a series of increasingly complex projects Get familiar with XBee's API mode for creating sensor networks Build fully scalable sensing and actuation systems with inexpensive components Learn about power management, source routing, and other XBee technical nuances Make gateways that connect with neighboring networks, including the Internet
Beginning Sensor Networks with XBee, Raspberry Pi, and Arduino
Author: Charles Bell
Publisher: Apress
ISBN: 1484257960
Category : Computers
Languages : en
Pages : 732
Book Description
Build sensor networks with Python and MicroPython using XBee radio modules, Raspberry Pi, and Arduino boards. This revised and updated edition will put all of these together to form a sensor network, and show you how to turn your Raspberry Pi into a MySQL database server to store your sensor data! You'll review the different types of sensors and sensor networks, along with new technology, including how to build a simple XBee network. You'll then walk through building an sensor nodes on the XBee, Raspberry Pi, and Arduino, and also learn how to collect data from multiple sensor nodes. The book also explores 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'll even learn how to connect to and interact with a MySQL database server directly from an Arduino! Finally you'll see how to put it all together by connecting your sensor nodes to your new Raspberry Pi database server. If you want to see how well XBee, Raspberry Pi, and Arduino can get along, especially to create a sensor network, then Beginning Sensor Networks with XBee, Raspberry Pi, and Arduino is just the book you need. What You'll LearnCode your sensor nodes with Python and MicroPython Work with new XBee 3 modulesHost your data on Raspberry PiGet started with MySQLCreate sophisticated sensor networks Who This Book Is For Those interested in building or experimenting with sensor networks and IoT solutions, including those with little or no programming experience. A secondary target includes readers interested in using XBee modules with Raspberry Pi and Arduino, those interested in controlling XBee modules with MicroPython.
Publisher: Apress
ISBN: 1484257960
Category : Computers
Languages : en
Pages : 732
Book Description
Build sensor networks with Python and MicroPython using XBee radio modules, Raspberry Pi, and Arduino boards. This revised and updated edition will put all of these together to form a sensor network, and show you how to turn your Raspberry Pi into a MySQL database server to store your sensor data! You'll review the different types of sensors and sensor networks, along with new technology, including how to build a simple XBee network. You'll then walk through building an sensor nodes on the XBee, Raspberry Pi, and Arduino, and also learn how to collect data from multiple sensor nodes. The book also explores 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'll even learn how to connect to and interact with a MySQL database server directly from an Arduino! Finally you'll see how to put it all together by connecting your sensor nodes to your new Raspberry Pi database server. If you want to see how well XBee, Raspberry Pi, and Arduino can get along, especially to create a sensor network, then Beginning Sensor Networks with XBee, Raspberry Pi, and Arduino is just the book you need. What You'll LearnCode your sensor nodes with Python and MicroPython Work with new XBee 3 modulesHost your data on Raspberry PiGet started with MySQLCreate sophisticated sensor networks Who This Book Is For Those interested in building or experimenting with sensor networks and IoT solutions, including those with little or no programming experience. A secondary target includes readers interested in using XBee modules with Raspberry Pi and Arduino, those interested in controlling XBee modules with MicroPython.
Beginning Robotics with Raspberry Pi and Arduino
Author: Jeff Cicolani
Publisher: Apress
ISBN: 1484234626
Category : Computers
Languages : en
Pages : 372
Book Description
Learn how to use a Raspberry Pi in conjunction with an Arduino to build a basic robot with advanced capabilities. Getting started in robotics does not have to be difficult. This book is an insightful and rewarding introduction to robotics and a catalyst for further directed study. You'll be led step by step through the process of building a robot that uses the power of a Linux based computer paired with the simplicity of Arduino. You’ll learn why the Raspberry Pi is a great choice for a robotics platform; its strengths as well as its shortcomings; how to overcome these limitations by implementing an Arduino; and the basics of the Python programming language as well as some of the more powerful features. With the Raspberry Pi you can give your project the power of a Linux computer, while Arduino makes interacting with sensors and motors very easy. These two boards are complimentary in their functions; where one falters the other performs admirably. The book also includes references to other great works to help further your growth in the exciting, and now accessible, field of smart robotics. As a bonus, the final chapter of the book demonstrates the real power of the Raspberry Pi by implementing a basic vision system. Using OpenCV and a standard USB web cam, you will build a robot that can chase a ball. What You'll Learn Install Raspbian, the operating system that drives the Raspberry Pi Drive motors through an I2C motor controller Read data through sensors attached to an Arduino Who This Book Is For Hobbyists and students looking for a rapid start in robotics. It assumes no technical background. Readers are guided to pursue the areas that interest them in more detail as they learn.
Publisher: Apress
ISBN: 1484234626
Category : Computers
Languages : en
Pages : 372
Book Description
Learn how to use a Raspberry Pi in conjunction with an Arduino to build a basic robot with advanced capabilities. Getting started in robotics does not have to be difficult. This book is an insightful and rewarding introduction to robotics and a catalyst for further directed study. You'll be led step by step through the process of building a robot that uses the power of a Linux based computer paired with the simplicity of Arduino. You’ll learn why the Raspberry Pi is a great choice for a robotics platform; its strengths as well as its shortcomings; how to overcome these limitations by implementing an Arduino; and the basics of the Python programming language as well as some of the more powerful features. With the Raspberry Pi you can give your project the power of a Linux computer, while Arduino makes interacting with sensors and motors very easy. These two boards are complimentary in their functions; where one falters the other performs admirably. The book also includes references to other great works to help further your growth in the exciting, and now accessible, field of smart robotics. As a bonus, the final chapter of the book demonstrates the real power of the Raspberry Pi by implementing a basic vision system. Using OpenCV and a standard USB web cam, you will build a robot that can chase a ball. What You'll Learn Install Raspbian, the operating system that drives the Raspberry Pi Drive motors through an I2C motor controller Read data through sensors attached to an Arduino Who This Book Is For Hobbyists and students looking for a rapid start in robotics. It assumes no technical background. Readers are guided to pursue the areas that interest them in more detail as they learn.
IoT Machine Learning Applications in Telecom, Energy, and Agriculture
Author: Puneet Mathur
Publisher: Apress
ISBN: 1484255496
Category : Computers
Languages : en
Pages : 284
Book Description
Apply machine learning using the Internet of Things (IoT) in the agriculture, telecom, and energy domains with case studies. This book begins by covering how to set up the software and hardware components including the various sensors to implement the case studies in Python. The case study section starts with an examination of call drop with IoT in the telecoms industry, followed by a case study on energy audit and predictive maintenance for an industrial machine, and finally covers techniques to predict cash crop failure in agribusiness. The last section covers pitfalls to avoid while implementing machine learning and IoT in these domains. After reading this book, you will know how IoT and machine learning are used in the example domains and have practical case studies to use and extend. You will be able to create enterprise-scale applications using Raspberry Pi 3 B+ and Arduino Mega 2560 with Python. What You Will Learn Implement machine learning with IoT and solve problems in the telecom, agriculture, and energy sectors with PythonSet up and use industrial-grade IoT products, such as Modbus RS485 protocol devices, in practical scenariosDevelop solutions for commercial-grade IoT or IIoT projectsImplement case studies in machine learning with IoT from scratch Who This Book Is For Raspberry Pi and Arduino enthusiasts and data science and machine learning professionals.
Publisher: Apress
ISBN: 1484255496
Category : Computers
Languages : en
Pages : 284
Book Description
Apply machine learning using the Internet of Things (IoT) in the agriculture, telecom, and energy domains with case studies. This book begins by covering how to set up the software and hardware components including the various sensors to implement the case studies in Python. The case study section starts with an examination of call drop with IoT in the telecoms industry, followed by a case study on energy audit and predictive maintenance for an industrial machine, and finally covers techniques to predict cash crop failure in agribusiness. The last section covers pitfalls to avoid while implementing machine learning and IoT in these domains. After reading this book, you will know how IoT and machine learning are used in the example domains and have practical case studies to use and extend. You will be able to create enterprise-scale applications using Raspberry Pi 3 B+ and Arduino Mega 2560 with Python. What You Will Learn Implement machine learning with IoT and solve problems in the telecom, agriculture, and energy sectors with PythonSet up and use industrial-grade IoT products, such as Modbus RS485 protocol devices, in practical scenariosDevelop solutions for commercial-grade IoT or IIoT projectsImplement case studies in machine learning with IoT from scratch Who This Book Is For Raspberry Pi and Arduino enthusiasts and data science and machine learning professionals.
Beginning Arduino Nano 33 IoT
Author: Agus Kurniawan
Publisher: Apress
ISBN: 9781484264454
Category : Computers
Languages : en
Pages : 187
Book Description
Develop Internet of Things projects with Sketch to build your Arduino programs. This book is a quick reference guide to getting started with Nano 33 IoT, Arduino’s popular IoT board. You’ll learn how to access the Arduino I/O, understand the WiFi and BLE networks, and optimize your board by connecting it to the Arduino IoT Cloud. Arduino Nano 33 IoT is designed to build IoT solutions with supported WiFi and BLE networks. This board can be easily extend through I/O pins, sensors and actuators. Beginning Arduino Nano 33 IoT is the perfect solution for those interested in learning how to use the latest technology and project samples through a practical and content-driven approach. What You’ll Learn Prepare and set up Arduino Nano 33 IoT board Operate Arduino Nano 33 IoT board hardware and software Develop programs to access Arduino Nano 33 IoT board I/O Build IoT programs with Arduino Nano 33 IoT board Who This Book Is For Makers, developers, students, and professional of all levels.
Publisher: Apress
ISBN: 9781484264454
Category : Computers
Languages : en
Pages : 187
Book Description
Develop Internet of Things projects with Sketch to build your Arduino programs. This book is a quick reference guide to getting started with Nano 33 IoT, Arduino’s popular IoT board. You’ll learn how to access the Arduino I/O, understand the WiFi and BLE networks, and optimize your board by connecting it to the Arduino IoT Cloud. Arduino Nano 33 IoT is designed to build IoT solutions with supported WiFi and BLE networks. This board can be easily extend through I/O pins, sensors and actuators. Beginning Arduino Nano 33 IoT is the perfect solution for those interested in learning how to use the latest technology and project samples through a practical and content-driven approach. What You’ll Learn Prepare and set up Arduino Nano 33 IoT board Operate Arduino Nano 33 IoT board hardware and software Develop programs to access Arduino Nano 33 IoT board I/O Build IoT programs with Arduino Nano 33 IoT board Who This Book Is For Makers, developers, students, and professional of all levels.
The Internet of Things: Do-It-Yourself at Home Projects for Arduino, Raspberry Pi and BeagleBone Black
Author: Donald Norris
Publisher: McGraw Hill Professional
ISBN: 0071835210
Category : Technology & Engineering
Languages : en
Pages : 354
Book Description
Build and program projects that tap into the Internet of Things (IoT) using Arduino, Raspberry Pi, and BeagleBone Black! This innovative guide gets you started right away working with the most popular processing platforms, wireless communication technologies, the Cloud, and a variety of sensors. You’ll learn how to take advantage of the utility and versatility of the IoT and connect devices and systems to the Internet using sensors. Each project features a list of the tools and components, how-to explanations with photos and illustrations, and complete programming code. All projects can be modified and expanded, so you can build on your skills. The Internet of Things: DIY Projects with Arduino, Raspberry Pi, and BeagleBone Black Covers the basics of Java, C#, Python, JavaScript, and other programming languages used in the projects Shows you how to use IBM’s Net Beans IDE and the Eclipse IDE Explains how to set up small-scale networks to connect the projects to the Internet Includes essential tips for setting up and using a MySQL database. The fun, DIY projects in the book include: Raspberry Pi home temperature measurements Raspberry Pi surveillance webcams Raspberry Pi home weather station Arduino garage door controller Arduino irrigation controller Arduino outdoor lighting controller Beaglebone message panel Beaglebone remote control SDR Machine-to-machine demonstration project
Publisher: McGraw Hill Professional
ISBN: 0071835210
Category : Technology & Engineering
Languages : en
Pages : 354
Book Description
Build and program projects that tap into the Internet of Things (IoT) using Arduino, Raspberry Pi, and BeagleBone Black! This innovative guide gets you started right away working with the most popular processing platforms, wireless communication technologies, the Cloud, and a variety of sensors. You’ll learn how to take advantage of the utility and versatility of the IoT and connect devices and systems to the Internet using sensors. Each project features a list of the tools and components, how-to explanations with photos and illustrations, and complete programming code. All projects can be modified and expanded, so you can build on your skills. The Internet of Things: DIY Projects with Arduino, Raspberry Pi, and BeagleBone Black Covers the basics of Java, C#, Python, JavaScript, and other programming languages used in the projects Shows you how to use IBM’s Net Beans IDE and the Eclipse IDE Explains how to set up small-scale networks to connect the projects to the Internet Includes essential tips for setting up and using a MySQL database. The fun, DIY projects in the book include: Raspberry Pi home temperature measurements Raspberry Pi surveillance webcams Raspberry Pi home weather station Arduino garage door controller Arduino irrigation controller Arduino outdoor lighting controller Beaglebone message panel Beaglebone remote control SDR Machine-to-machine demonstration project
Exploring Raspberry Pi
Author: Derek Molloy
Publisher: John Wiley & Sons
ISBN: 1119188709
Category : Computers
Languages : en
Pages : 723
Book Description
Expand Raspberry Pi capabilities with fundamental engineering principles Exploring Raspberry Pi is the innovators guide to bringing Raspberry Pi to life. This book favors engineering principles over a 'recipe' approach to give you the skills you need to design and build your own projects. You'll understand the fundamental principles in a way that transfers to any type of electronics, electronic modules, or external peripherals, using a "learning by doing" approach that caters to both beginners and experts. The book begins with basic Linux and programming skills, and helps you stock your inventory with common parts and supplies. Next, you'll learn how to make parts work together to achieve the goals of your project, no matter what type of components you use. The companion website provides a full repository that structures all of the code and scripts, along with links to video tutorials and supplementary content that takes you deeper into your project. The Raspberry Pi's most famous feature is its adaptability. It can be used for thousands of electronic applications, and using the Linux OS expands the functionality even more. This book helps you get the most from your Raspberry Pi, but it also gives you the fundamental engineering skills you need to incorporate any electronics into any project. Develop the Linux and programming skills you need to build basic applications Build your inventory of parts so you can always "make it work" Understand interfacing, controlling, and communicating with almost any component Explore advanced applications with video, audio, real-world interactions, and more Be free to adapt and create with Exploring Raspberry Pi.
Publisher: John Wiley & Sons
ISBN: 1119188709
Category : Computers
Languages : en
Pages : 723
Book Description
Expand Raspberry Pi capabilities with fundamental engineering principles Exploring Raspberry Pi is the innovators guide to bringing Raspberry Pi to life. This book favors engineering principles over a 'recipe' approach to give you the skills you need to design and build your own projects. You'll understand the fundamental principles in a way that transfers to any type of electronics, electronic modules, or external peripherals, using a "learning by doing" approach that caters to both beginners and experts. The book begins with basic Linux and programming skills, and helps you stock your inventory with common parts and supplies. Next, you'll learn how to make parts work together to achieve the goals of your project, no matter what type of components you use. The companion website provides a full repository that structures all of the code and scripts, along with links to video tutorials and supplementary content that takes you deeper into your project. The Raspberry Pi's most famous feature is its adaptability. It can be used for thousands of electronic applications, and using the Linux OS expands the functionality even more. This book helps you get the most from your Raspberry Pi, but it also gives you the fundamental engineering skills you need to incorporate any electronics into any project. Develop the Linux and programming skills you need to build basic applications Build your inventory of parts so you can always "make it work" Understand interfacing, controlling, and communicating with almost any component Explore advanced applications with video, audio, real-world interactions, and more Be free to adapt and create with Exploring Raspberry Pi.
MySQL High Availability
Author: Charles Bell
Publisher: "O'Reilly Media, Inc."
ISBN: 1449339565
Category : Computers
Languages : en
Pages : 948
Book Description
Server bottlenecks and failures are a fact of life in any database deployment, but they don’t have to bring everything to a halt. This practical book explains replication, cluster, and monitoring features that can help protect your MySQL system from outages, whether it’s running on hardware, virtual machines, or in the cloud. Written by engineers who designed many of the tools covered, this book reveals undocumented or hard-to-find aspects of MySQL reliability and high availability—knowledge that’s essential for any organization using this database system. This second edition describes extensive changes to MySQL tools. Versions up to 5.5 are covered, along with several 5.6 features. Learn replication fundamentals, including use of the binary log and MySQL Replicant Library Handle failing components through redundancy Scale out to manage read-load increases, and use data sharding to handle large databases and write-load increases Store and replicate data on individual nodes with MySQL Cluster Monitor database activity and performance, and major operating system parameters Keep track of masters and slaves, and deal with failures and restarts, corruption, and other incidents Examine tools including MySQL Enterprise Monitor, MySQL Utilities, and GTIDs
Publisher: "O'Reilly Media, Inc."
ISBN: 1449339565
Category : Computers
Languages : en
Pages : 948
Book Description
Server bottlenecks and failures are a fact of life in any database deployment, but they don’t have to bring everything to a halt. This practical book explains replication, cluster, and monitoring features that can help protect your MySQL system from outages, whether it’s running on hardware, virtual machines, or in the cloud. Written by engineers who designed many of the tools covered, this book reveals undocumented or hard-to-find aspects of MySQL reliability and high availability—knowledge that’s essential for any organization using this database system. This second edition describes extensive changes to MySQL tools. Versions up to 5.5 are covered, along with several 5.6 features. Learn replication fundamentals, including use of the binary log and MySQL Replicant Library Handle failing components through redundancy Scale out to manage read-load increases, and use data sharding to handle large databases and write-load increases Store and replicate data on individual nodes with MySQL Cluster Monitor database activity and performance, and major operating system parameters Keep track of masters and slaves, and deal with failures and restarts, corruption, and other incidents Examine tools including MySQL Enterprise Monitor, MySQL Utilities, and GTIDs