MySQL for the Internet of Things
Chapter 6 ■ Building low-Cost MysQl data nodes Congratulations! You’ve written your first MySQL-enabled Python script. Now that ...
Chapter 6 ■ Building low-Cost MysQl data nodes Notice the line in bold. This command is necessary to ensure the rows are written ...
Chapter 6 ■ Building low-Cost MysQl data nodes MYSQL UtILItIeS: pYthON-BaSeD DataBaSe aDMINIStratION if you are a python develop ...
Chapter 7 High Availability IOT Solutions You may be wondering what high availability has to do with IOT solutions. That is, you ...
Chapter 7 ■ high availability iOt SOlutiOnS reLIaBILItY VS. hIGh aVaILaBILItY: What IS the DIFFereNCe? reliability is a measure ...
Chapter 7 ■ high availability iOt SOlutiOnS As you can see, there are several concepts and corresponding tools or techniques tha ...
Chapter 7 ■ high availability iOt SOlutiOnS some components are more important and must be recoverable, and thus your efforts sh ...
Chapter 7 ■ high availability iOt SOlutiOnS This is a good strategy and one of the most common found in DIY IOT solutions. Howev ...
Chapter 7 ■ high availability iOt SOlutiOnS You can also implement fault tolerance at the database. Once again, we build on the ...
Chapter 7 ■ high availability iOt SOlutiOnS Notice I include the name of the tool, the type of backup produced, a license, and a ...
Chapter 7 ■ high availability iOt SOlutiOnS /!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /; /!40101 SET @OLD_CHA ...
Chapter 7 ■ high availability iOt SOlutiOnS Notice the verbosity of the output. As you can see, the client captures a great deal ...
Chapter 7 ■ high availability iOt SOlutiOnS BEGIN DECLARE num_samples int; SELECT COUNT(*) into num_samples FROM plant_monitorin ...
Chapter 7 ■ high availability iOt SOlutiOnS Listing 7-3. Using MySQL Utilities for Backup $ mysqldbexport --server=root@localhos ...
Chapter 7 ■ high availability iOt SOlutiOnS While MySQL Enterprise Backup is a fee-based application, you can download a trial v ...
Chapter 7 ■ high availability iOt SOlutiOnS Binary logs are special files that contain a copy of all changes made to the databas ...
Chapter 7 ■ high availability iOt SOlutiOnS MySQL Replication Primer One of the nicest things about using an external drive to s ...
Chapter 7 ■ high availability iOt SOlutiOnS How to Set Up Replication This section demonstrates how to set up replication from a ...
Chapter 7 ■ high availability iOt SOlutiOnS But one more piece of information is needed for the slave. The slave needs to know t ...
Chapter 7 ■ high availability iOt SOlutiOnS Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. This so ...
«
8
9
10
11
12
13
14
15
16
17
»
Free download pdf