For our previous car (Solar Miner) I rewrote and redesigned the telemetry software that was used in support vehicles for viewing data coming from the car. It worked well, and gave us all the information we needed at the time, but it suffered in some areas. One of these was that data was never stored anywhere except a plain-text log file, which proved slow and unreliable. With this in mind, our new telemetry system will store information in a database for further review.

This post is a discussion of data gathered during week long tests performed on two popular database systems.

Old System

The previous telemetry software, as stated before, only stored incoming data in a plain-text, comma-separated file. This proved unreliable in a few ways:

With these faults in-mind, I have decided that all data coming from the car will be logged in a database, and also seen by telemetry software in real time. A dedicated machine running software to log incoming telemetry packets will run at all times when the car is running, constantly logging.

This will allow for data to be seen in real time (and only real time) on the telemetry software, as well as being processed and stored into a database. The machine will host a website that can be used during the race to see charts/graphs of data coming from the car, removing the legacy MATLAB program from the process.

 

The Data

Telemetry data from a solar car is a key component to successfully operating during a race. This data can tell you what is happening on almost every part of the car at any instance, which can play a vital role in debugging, diagnosing, or improving any system on the car.

For any solar car, you would want telemetry on a few basic things:

You can further improve your understanding of what exactly is happening on the car at any given time by adding various sensors around the car such as tire pressure sensors, accelerometers, GPS, and more.

But for the purpose of these tests, the data will be kept to the exact data we had available on Solar Miner, which included the basic items listed above then anything software controlled (horn, errors/warnings, etc...).

Since the data helps team members understand what is happening in the car at any given time, it is important that this data is sent out fast and often.

 

Our Needs

This constant flood of data is why we are performing these tests ourselves. Messages are sent out about every 100ms on the car, for just one system, that's a lot of messages!

We haven't exactly narrowed down how many telemetry messages our new car will send out a second, so we are using the speed of packets from Solar Miner.

We need a system that can both read, and write, to a database extremely quickly, no matter how large our tables become. We do not want to be cleaning out a table while in the middle of Australia because we have too much data.

While there are companies, and other scenarios, where database usage will be ten-fold more heavy than ours, these tests provide team members with testing experience, and experience interacting with a database.

 

Database Systems Tested

Tests were conducted against MySQL and Apache Cassandra.

Since we just want to know what systems will slow down more as data increases, our tests will simply insert a lot of rows, and the query for each operation as data grows larger will be tracked.

Average write times are recorded by taking the average time of 20,000 INSERT queries.

Average read times are taken while inserting rows, and then again when not inserting rows. 20,000 SELECT operations are performed during both of these tests.

A fourth, and final test, shows the average INSERT query time while rows are being read from the database.

 

Results

MySQL vs. Cassandra Read Times

Above is a chart that shows average read times (over 20,000 SELECT operations) for both MySQL (red and blue) and Apache Cassandra (green and yellow/orange).

There are four total data sets, two for each system. One of these sets shows the average read time while the database is having data written to it.

What this shows is that as you return more and more rows from MySQL each query grows slightly slower, not by a lot, but still slower. Both reading and reading while writing have a steady incline to them, they're reliably getting slower.

While looking at the data gathered from Cassandra, query times are nearly stable when only reading, as well as when you are reading and writing. Reading while writing with Cassandra did tend to fluctuate more than just reading, it is still hovering around the same times, where MySQL is a steady increase.

 

MySQL vs. Cassandra Write Times

The second chart shows the average write time (over 20,000 INSERT operations) on by MySQL (left) and Apache Cassandra (right).

Having never touched a NoSQL database before, it was amazing to see how quickly Cassandra could insert new data. I re-ran this test multiple times to confirm that this result was consistent, and sure enough, Cassandra blew MySQL out of the water every single time.

 

Conclusion

After running the tests, and many discussions, Apache Cassandra has been chosen as our database system of choice. While Cassandra performs slower than MySQL when reading while writing and returning <20,000 rows we will probably find ourselves in situations where we will need to return a lot more than 20,000 rows since it only represents about 2 minutes of telemetry data.

Choose Design Team
  • Student Design Teams
  • Missouri S&T Racing
  • Miner Aviation
  • Baja SAE
  • Concrete Canoe
  • Engineers Without Borders
  • Formula SAE Electric
  • Human Powered Vehicle Team
  • Hydrogen Design Solutions
  • Missouri S&T iGEM
  • Missouri S&T Underwater Robotics
  • Missouri S&T Solar Car Team
  • Missouri S&T Solar House Design Team
  • Steel Bridge Design Team
  • Mars Rover Design Team
  • Mid-Continent Student Conference 2016
  • Multirotor Robot Design Team
  • Drillbotics Design Team
  • S&T Chem E Car
  • Missouri S&T Rocket Design Team
  • Mars Rover Design Team - DEV
  • Liquid-fueled Rocket Design Team
  • Miner Motorcycle Design Team