« Professional Cat Herding: A FOSS Community Panel | Main | Eben Moglen: Freedom Businesses Protect Privacy »

April 24, 2007

Mission Critical Flight Planning Applications at the US Navy

Christine Vota is talking at the 2007 MySQL Conference about the US Navy using MySQL.

The session starts with an introduction from a MySQL sales engineer, Craig Sylvester, about how MySQL is used in government. Los Almos lab, the US Census Bureau and NASA all use MySQL for some part of their operations.

Christine's presentaition starts with a video about the operation of a Navy aircraft carrier. Maintenance, fuel, weather conditions, flightdeck plans etc all have to be tracked and shown all around the ship. The subject of the film is a new computerized flight deck and operations management system. Instead of having multiple systems around the ship it is all centralized into one repository.

For deployment they needed no single point of failure. Complete reduncancy. Needs to have minimal hardware physical footprint. They were looking for an alternative to a legacy database. They found MySQL and one other in-memory database. They did a MySQL jump-start and got the cluster up. They got a smaller application up and running on the cluster and it passed all of their failure checks so they went with MySQL.

An aircraft carrier has a 4-node cluster running. It runs on Linux, which is additional training because the systems folks on the team were primarily Windows and other Unix flavors. There were still some concerns. Lack of foreign keys, database sequences, missing varchar datatype, case sensitivity and consultant recommendation to not alter tables.

They were able to work around all of the issues. They installed a pre-Alpha version of Windows-based cluster management node.

It has been running for over a year 24/7. Haven't had any performance issues. She closes with a statement from the Navy about using MySQL.

Pretty cool (if you believe in MySQL) to think about aircraft carriers sailing around the globe with MySQL Cluster running.

Posted by mike at April 24, 2007 6:04 PM