5 ms·

NASA to deploy PostgreSQL/Nagios on Space Station

75 points by moe 16y ago

mahmud 16y ago
The child in me wants to drop everything he is doing; a new job, and apartment rent in 2 continents, and just go volunteer for this.
- adbge 16y ago
  Is there anything cooler or more badass than writing software used in space? Whenever I'm told that a piece of software isn't fit for "mission critical applications," I think of NASA. I'd love to help out with this, but I'm afraid I lack the necessary skill set. Still, maybe I will poke around the NDOUtils source anyways. If anyone else is interested, here's a link to the NDOUtils source tarball: http://sourceforge.net/projects/nagios/files/ndoutils-1.x/ndoutils-1.4b9/ndoutils-1.4b9.tar.gz/download http://sourceforge.net/projects/nagios/files/ndoutils-1.x/nd...
  - tomjen3 16y ago
    Yeah, it would be a lot cooler to go into space...
james2vegas 16y ago
well, they want to deploy Pg/Nagios on the Space Station, pity Nagios's support for anything other than MySQL is poor to non-existent.
- jncraton 16y ago
  It's not really a pity at all. It will be more work for them, but it's a win for us as long as they pass their code to make it work back upstream.
openfly 16y ago
NASA's commitment to open source is fairly great. And, postgresql is a really great database. If you haven't used it before, I highly recommend giving it a run.
- donw 16y ago
  It's just too bad they've got to pair it with Nagios; I'm fixing it so that I never have to work with that POS ever again.
  - nkassis 16y ago
    Well, as far as I can tell, all the other solutions they could be using suck more, at least adding new modules to nagios is about as easy as writing a script. Cause that's all you have to do. I've dealt with installs checking hundreds of servers,routers and switches and our only major issue was needing to distribute the checks onto multiple machines. One box will die trying to ping,connect,... onto too many nagios boxes.
  - dedward 16y ago
    What are you going to work with instead, just curious?
helium 16y ago
Well, I guess they just haven't heard how awesome NoSQL is yet :)
- tialys 16y ago
  I'm an intern at NASA this summer, and I've actually convinced the team I'm working with to use Redis/Resque for the application we're working on. Unfortunately it's 'just' a web application ;)
deleted 16y ago
[deleted]
nkassis 16y ago
That's awesome. Nagios in space. Sounds like a cool comedy title. Were about to install Nagios here too. One more point for management to like the idea ;p
pragmatic 16y ago
Why Postgres? I'm a fan of it, but I wonder why they can't/won't use mysql? (I'm looking for a good technical explanation, if anyone has one.)
- moe 16y ago
  My guess would be that NASA already uses postgres for other duties and is hesitant to introduce a new database into their infrastructure - especially one with so many known problems. If I was them then I most certainly wouldn't want a database with silent data truncation/corruption issues to come anywhere near my spaceships. Not even for seemingly unimportant tasks because even those may cost amazing amounts of money to fix if they go wrong a few thousand kilometers above groundlevel...
  - ugh 16y ago
    Regrettably only a few hundred kilometers above groundlevel (the ISS is at a height of about 350 km).
- rbranson 16y ago
  PostgreSQL is well-known for it's focus on data integrity and durability first, performance second. The team didn't really focus heavily on performance until the 8.x release series, after the database had been proven as extremely stable. Also, it has a much more complete implementation of SQL and larger feature set.
- dboyd 16y ago
  I've used both very recently, and I would definitely avoid MySQL given a choice. From my experience, postgres is faster, especially at more difficult problems (complex joins). I've never had issues in postgres joining several tables into 10 million plus row relations, and then filtering down to the set of interest. I did a recent test adding a similar column to a MySQL table with 3 million rows in it compared to adding a column to a postgres table with 30 million rows in it. MySQL took 3000 seconds, and postgres took 82 ms. Functional indexes. Doing things like "create unique index user_emails on users (lower(email));" works great in postgres. A quick google reveals this: http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL_2009 http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_My... It's a bit old, but it might provide more insight.
superk 16y ago
Makes me wonder about budget cuts...
- RyanMcGreal 16y ago
  "I felt about as good as anybody would, sitting in a capsule on top of a rocket that were both built by the lowest bidder." -- John Glenn on how it felt waiting to for the rocket to launch
avar 16y ago
Isn't the computing power on the ISS almost purely made up of Thinkpad laptops running Windows? Will they be running PostgreSQL and Nagios on a Windows machine?
gourneau 16y ago
Another NASA open source programmer checking in.

75 points by moe 16y ago

The child in me wants to drop everything he is doing; a new job, and apartment rent in 2 continents, and just go volunteer for this.

adbge 16y ago
Is there anything cooler or more badass than writing software used in space? Whenever I'm told that a piece of software isn't fit for "mission critical applications," I think of NASA. I'd love to help out with this, but I'm afraid I lack the necessary skill set. Still, maybe I will poke around the NDOUtils source anyways. If anyone else is interested, here's a link to the NDOUtils source tarball: http://sourceforge.net/projects/nagios/files/ndoutils-1.x/ndoutils-1.4b9/ndoutils-1.4b9.tar.gz/download http://sourceforge.net/projects/nagios/files/ndoutils-1.x/nd...
- tomjen3 16y ago
  Yeah, it would be a lot cooler to go into space...

james2vegas 16y ago

well, they want to deploy Pg/Nagios on the Space Station, pity Nagios's support for anything other than MySQL is poor to non-existent.

jncraton 16y ago
It's not really a pity at all. It will be more work for them, but it's a win for us as long as they pass their code to make it work back upstream.

openfly 16y ago

NASA's commitment to open source is fairly great. And, postgresql is a really great database. If you haven't used it before, I highly recommend giving it a run.

donw 16y ago
It's just too bad they've got to pair it with Nagios; I'm fixing it so that I never have to work with that POS ever again.
- nkassis 16y ago
  Well, as far as I can tell, all the other solutions they could be using suck more, at least adding new modules to nagios is about as easy as writing a script. Cause that's all you have to do. I've dealt with installs checking hundreds of servers,routers and switches and our only major issue was needing to distribute the checks onto multiple machines. One box will die trying to ping,connect,... onto too many nagios boxes.
- dedward 16y ago
  What are you going to work with instead, just curious?

helium 16y ago

Well, I guess they just haven't heard how awesome NoSQL is yet :)

tialys 16y ago
I'm an intern at NASA this summer, and I've actually convinced the team I'm working with to use Redis/Resque for the application we're working on. Unfortunately it's 'just' a web application ;)

deleted 16y ago

[deleted]

nkassis 16y ago

That's awesome. Nagios in space. Sounds like a cool comedy title. Were about to install Nagios here too. One more point for management to like the idea ;p

pragmatic 16y ago

Why Postgres? I'm a fan of it, but I wonder why they can't/won't use mysql? (I'm looking for a good technical explanation, if anyone has one.)

moe 16y ago
My guess would be that NASA already uses postgres for other duties and is hesitant to introduce a new database into their infrastructure - especially one with so many known problems. If I was them then I most certainly wouldn't want a database with silent data truncation/corruption issues to come anywhere near my spaceships. Not even for seemingly unimportant tasks because even those may cost amazing amounts of money to fix if they go wrong a few thousand kilometers above groundlevel...
- ugh 16y ago
  Regrettably only a few hundred kilometers above groundlevel (the ISS is at a height of about 350 km).
rbranson 16y ago
PostgreSQL is well-known for it's focus on data integrity and durability first, performance second. The team didn't really focus heavily on performance until the 8.x release series, after the database had been proven as extremely stable. Also, it has a much more complete implementation of SQL and larger feature set.
dboyd 16y ago
I've used both very recently, and I would definitely avoid MySQL given a choice. From my experience, postgres is faster, especially at more difficult problems (complex joins). I've never had issues in postgres joining several tables into 10 million plus row relations, and then filtering down to the set of interest. I did a recent test adding a similar column to a MySQL table with 3 million rows in it compared to adding a column to a postgres table with 30 million rows in it. MySQL took 3000 seconds, and postgres took 82 ms. Functional indexes. Doing things like "create unique index user_emails on users (lower(email));" works great in postgres. A quick google reveals this: http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL_2009 http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_My... It's a bit old, but it might provide more insight.

superk 16y ago

Makes me wonder about budget cuts...

RyanMcGreal 16y ago
"I felt about as good as anybody would, sitting in a capsule on top of a rocket that were both built by the lowest bidder." -- John Glenn on how it felt waiting to for the rocket to launch

avar 16y ago

Isn't the computing power on the ISS almost purely made up of Thinkpad laptops running Windows? Will they be running PostgreSQL and Nagios on a Windows machine?

gourneau 16y ago

Another NASA open source programmer checking in.