Abstract
Understanding what high availability is and some of the key goals for achieving higher levels of reliability will help you design your IOT solutions for greater reliability. As you learned in the previous chapter, it takes a bit of work to achieve these goals, but the payoff for a modest amount of work is well worth it should your solution expand beyond a set of discrete nodes.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
Made easier with MySQL Utilities, as you will see.
- 2.
Sometimes this is the easiest and fastest way to bring a slave back online after encountering fatal errors or data corruption. Thus, always take regular backups.
- 3.
There are other tricks, but this is the safest way.
- 4.
Oracle doesn’t have a load balancer for MySQL read scaling yet. But it does have a connection router capability in the MySQL Router product.
- 5.
Not that there is anything wrong with configuration files, but if you’ve ever encountered an installation where there are multiple configuration files scattered across several parts of the solution, you’ll grow to appreciate not requiring them.
- 6.
Not to be confused with hinky, which is worse.
- 7.
A highly technical description of erratic behavior.
- 8.
Not recommended, but I’ve seen it work well in experiments. I would use duplicate sensors.
- 9.
Can you guess how I know this? Yep. I was ready to skeet shoot my Leonardo until I remembered the pin layout was different. Use enough Arduino boards, and you may find you’ll want to do the same!
- 10.
A rudimentary albeit slightly inaccurate way to measure time without a real-time clock but good enough for use as a rough timer.
Author information
Authors and Affiliations
Electronic Supplementary Material
Below is the link to the electronic supplementary material.
Rights and permissions
Copyright information
© 2016 Charles Bell
About this chapter
Cite this chapter
Bell, C. (2016). Demonstration of High Availability Techniques. In: MySQL for the Internet of Things. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1293-6_8
Download citation
DOI: https://doi.org/10.1007/978-1-4842-1293-6_8
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-1294-3
Online ISBN: 978-1-4842-1293-6
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books