@networknerd said in Using In-Memory Databases, Anyone?:

@jimmy9008 said in Using In-Memory Databases, Anyone?:

@networknerd said in Using In-Memory Databases, Anyone?:

• They actually point out in the podcast that they had the best success with in-memory databases on local storage or SAN (NAS not a good choice) and that ethernet was the networking avenue of choice.

Not sure what this means... not that I know about this, but, if its in memory, its in... memory, right? So, what does it have to do with local storage, SAN, or NAS?

Anyway, other databases load what is used frequently in to memory so its quick to access. Its why lots of places would build an SQL server with a ton of RAM - so that SQL can put what is used often in to RAM (fast) and keep it available... right?

Well, at some point you do have to write the data to disk (whether synchronously or asynchronously) to keep a less volatile copy of the data (at least that is what I remember from the podcast). It seems like synchronous data writes would be near impossible because you cannot keep it going at the same speed.

I definitely do not claim to understand it all really well.

Not necessarily. Persistence to disk is not a guaranteed feature of in memory databases. It is common, for sure, but not guaranteed. But you should think of it as taking a backup of the database, not as storing it normally. That's the big difference between the two approaches.

Caching a traditional database to memory and having an in memory database do not behave the same. A pure in memory database has advantages to structure that databases writing to disk do not. There is no need to structure the data in preparation for writing to disk.

Yes, it is standard for any high performance application in modern times to use an in memory database for performance of at least part of its workload. Sodium is planning on this as part of its design.

The most commonly known database for this is Redis.

Now if only it would install Sodium.

If anyone has Windows 8 or 8.1 for testing, that would be great.

That's great, thanks for testing that out for us. We also have Windows 7 confirmed as well. So that is 7 and Vista confirmed.

We are now able to add ElementaryOS to the matrix! Agent install is clean, but we have the same application enumeration problem as with several other Ubuntu-derived distros. Hopefully they can all be fixed together. Install is done using the "DEB Generic" installer.

Matrix is filled out and up to date.

And more importantly, we have full agent install and scanning with Windows Server 2008. The only caveat here is that the .NET Framework 4.0 installation has to be done prior to attempting the install of Sodium.

Our last systems of the night have reported in. We now have Zorin 12.1 with a clean agent install using the DEB Generic installer. Scanning is not 100% because we have the same application enumeration issue that we have with Deepin. But we are very close and likely the issue is the same.

Before calling it a night, we get to announce that Windows 2012 is fully working. Both for the agent install and for the monitoring and scanning!

The team is wrapping up for the night. It's been a long, productive night. See everyone tomorrow as we attempt to get more updates rolled out for you.

Latest release is up. No new functionality, just bad end fixes and improvements.

Another release coming now...

Spoke too soon, 2008 R2 scanning is working!

We have added Windows Server 2008 R2 to the matrix with the agent install working like a charm. Monitoring is mostly working but is not 100%.

openSuse Leap 42.3 is fully scanning now. Another one under our belts. We expected no problems as Tumbleweed has been so solid, as has Gecko.

Okay, in the latest release we have some backend improvements as well as the very prominent color coding of the dashboard "Last Check In" field. With this update you can now quickly look to see if your asset has responded currently, recently, or some time ago.

Okay, we have another release coming out now....

We have added openSuse Leap 42.3 as a working agent installer!