May 22, 2012
I discovered this fabulous project and installed the version found on
https://github.com/other/thingspeak.git on a test machine for the moment it is only happiness.
But I ask myself some questions:
-Is there a version on postgres? Because I am not able to make some fine tuning in mysql.
-The three tabs plugin apps and devices and file import are not available with the version I have installed, do you know where to find them?
-Do you think that memcached is needed to 10Mio measures spread over approximately 100 channels knowing that there will be seldom more than 5 concurrent clients on the application.
Benni! Glad that you found us and the GitHub release is working for you.
There are differences between what we have on our website and the open source version. The Apps and Plugins are not on GitHub (yet). We are still working on another round of new features that we will release before we get to adding new functionality to GutHub. Our intent is provide the base on which it's easy to build new components to.
I don't know of any Postgres variants. Internally we use MySQL for time-series data and Redis for queuing (to large scale).
Also, memcached is probably not needed for the applications that you are describing. Once you get to a 1000 it probably makes sense.
Let us know if you have more questions... Good luck-have fun.
May 22, 2012
Can you describe in more detail the configuration of mysql? For example for a server 16Gb ram.
What storage engine do you use?
Do you have a sample my.cnf?
I am also very interested in using REDIS. I use Publish / Subscribe
for forwarding alarms and real-time measurements from Arduino. (unfortunately without archiving). I'm looking for more information on storing time series in REDIS with or without WEBdis, because using the native REDIS protocol in the arduino is a great idea to save space and increase efficiency.
Does the average values derived for example 60 are pre-calculated and it available in a database or she are calculated on the fly during each query?
Most Users Ever Online: 166
Currently Browsing this Page:
Guest Posters: 1
Newest Members:khanhNguyen_CT, susyburr, quijano__, meosuckhoe, briskpanda, Dejw0089
Moderators: cstapels: 460
Administrators: Hans: 405, lee: 457