Upgrade to Pro — share decks privately, control downloads, hide ads and more …

My Pi in the Sky - Running MySQL on a Raspberry...

Scott Stroz
March 13, 2024
14

My Pi in the Sky - Running MySQL on a Raspberry Pi and Replicating Data to the Cloud

Did you know you can run MySQL on a Raspberry Pi and replicate the data to the cloud?

In this session, we will cover how to install MySQL on a Raspberry Pi, give a brief overview of how to store data on this MySQL instance, demonstrate an application that can visualize that data, and finally, how you can replicate that data to a MySQL instance running in the cloud.

Scott Stroz

March 13, 2024
Tweet

Transcript

  1. § MySQL Developer Advocate § Full stack Developer for longer

    than the term "full stack developer" has existed § The only constant in my dev stack has been MySQL § I am a die-hard NY Giants fan § I have the best office mate § I often force myself to learn new tech by submitting proposals to conferences
  2. SPS I §Raspberry Pi 4 Model B §AdaFruit Ultimate GPS

    Module §SunFounder RAP Breadboard
  3. §Raspberry Pi 4 Model B §AdaFruit Ultimate GPS Module §Cardboard

    §Scotch tape §AdaFruit USB to TTY Adapter
  4. §Raspberry Pi 4 Model B §AdaFruit Ultimate GPS Module §

    Soldered correctly §AdaFruit USB to TTY Adapter §Vilros Aluminum Pi 4 Case
  5. SOFTWARE ON THE PI §Ubuntu 23.10 §MySQL 8.0.35 §Node.js §

    SerialPort Module § GPS Module § MySQL Connector § MySQL Document Store §PiTunnel §Not open-source nor free
  6. COMPUTE INSTANCE §Always Free Tier §1 CPU §6 GB RAM

    §Ubuntu 23.10 §Node.js §Express Module §MySQL Connector §OCI TypeScript SDK §Leaflet Map Viewer §Leaflet.motion plugin §OpenStreetMaps §Vanilla JS Datepicker
  7. SET UP PITUNNEL §Create an account at https://www.pitunnel.com/ §Add a

    device §Add persistent 'Custom Tunnels' for ports § 3306 § 33060
  8. §Playing around with Raspberry Pi can be addicting. §And expensive…

    §Consumer-grade GPS is ridiculously accurate. §Except when it is not §Managing network connections in Ubuntu 23.10 Server on a Pi is…interesting
  9. §Inbound Replication might not be the best implementation for this

    project. §Removing data from the Pi will remove it from the replica. §Ubuntu Linux images in OCI are locked down pretty tight. §Specifically, firewall config