Abstract
The journey thus far into InnoDB Cluster has been one of discovery and experimentation. To make InnoDB Cluster truly useful and meaningful to your infrastructure, we must deploy it to real machines using real data. Although a walk-through of a live, working production system could be beneficial, that would be jumping too far ahead for those exploring InnoDB Cluster and MySQL high availability for the first time. We can’t go from a simulated environment such as a sandbox to a product deployment. No administrator would do that. We must start from a development deployment that we can use to experiment and test our application. Only after careful testing can we then roll it out to our production environment.
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.
Experience has shown that each installation of high-availability MySQL tends to become specific to the environment, goals, and application requirements. What is presented here is an example of a general installation that you can use to build upon.
- 2.
I haven’t met too many experienced developers and administrators who couldn’t lay their hands on several of each of these items at a moment’s notice.
- 3.
Wikipedia provides more information on endianness; see https://en.wikipedia.org/wiki/Endianness .
- 4.
DHCP is a network management protocol used on TCP/IP networks to manage IP addresses. See https://en.wikipedia.org/wiki/Dynamic_Host_Configuration_Protocol .
- 5.
I suppose we should discourage that, eh? Always read the license!
- 6.
You are using a case, right? Using a Raspberry Pi without a case is not safe because anything that conducts electricity can fall on the boards, possibly causing damage. It is highly recommended that each Raspberry Pi has its own case.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2018 Charles Bell
About this chapter
Cite this chapter
Bell, C. (2018). Example MySQL High Availability Deployment. In: Introducing InnoDB Cluster. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-3885-1_7
Download citation
DOI: https://doi.org/10.1007/978-1-4842-3885-1_7
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-3884-4
Online ISBN: 978-1-4842-3885-1
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books