MYSQL Master Slave Replication over SSH tunnel

The purpose of running having a master / slave relationship between your databases is that the slave database will be an exact replica of the specified master database. The purpose of running the connection through a SSH tunnel is to ensure:

  1. Connection is encrypted
  2. MYSQL server will only connect to the localhost
  3. Minimal ports need to be opened at the firewall.

If you are unfamiliar with the SSH protocol or how to forward local ports, now is a great time to learn about it or to brush up on it from the Offical Website.

On Both Servers

On both the master …

more ...

Repair MYSQL Master Slave Replication

One of the interesting parts of living on a boat is probably something that most people never think of dealing with. Power Management! Since we only have 30 amps of power available to draw at any one time we have to be quite careful on what is running. On those times that we aren't so careful and the breaker trips my Raspberry Pi running weewx loses power and the MYSQL connection to the web server is lost. This can lead to a corrupted database on the web server that will not work until the errors are cleared. One of the …

more ...

Raspberry Pi WS-2080 Weather Station

After surviving a windstorm that produced 40-60 mph winds on the boat I decided that I wanted a weather station to capture that data! The closest anemometer was very far away and definitely was not subjected to the same winds that I had in my marina. The following post is the steps I took to get my system up and running. It will probably be a work in progress because I like to tinker and fix things until they are broken.

For my overall design I had to make a decision right off the bat on whether I wanted to …

more ...

C++

These posts will be various lessons and lessons learned as I start learning how to program in C++. My first experiences programming started in Windows batch files and then in high school I was introduced to Perl. While it could be argued that neither batch or Perl are "real programming languages" they non-the-less introduced me to the world of programming.

C++

Useful C++ Resources

The following links are the sites that I found most helpful for me. I have found that I learn best by reading the text, looking at examples of code, and then systematically analyzing the code and breaking …

more ...