The Millistream MDA project team is pleased to announce the release of
\nversion 0.9.38 of our open source application for updating SQL servers
\nwith data from the Millistream Data Feed.<\/p>\n
* For instruments that receive both a LastPrice and a NAV the ‘diffX’ and ‘diffXprc’
\n values in the ‘performance’ table could be accidentally calculated using the NAV instead
\n of the LastPrice if the LastPrice was NULL when the NAV was set. We have now changed it
\n so that NAV is only used for the calculation of diffs if the InstrumentType is set to 8
\n (Mutual Fund), for every other instrument type the LastPrice value is used.<\/p>\n
* It was discovered that MDA upon receiving a InstrumentDelete message would try and
\n delete data from a table even if that table where disabled in the config (for example
\n if ‘requestperformance’ was set to “0” in mda.config then the MDA would still try to delete
\n the insref from the ‘performance’ table) this could lead to unnecessary error logs if
\n the tables where disabled in the config due to them not existing.<\/p>\n
* The MDA will now only calculate the diffs in the ‘performance’ table if both
\n ‘requestquotes’ and ‘requestperformance’ is enabled in the config, since data from both
\n messages are needed in order to calculate the diffs.<\/p>\n
* On Linux systems we now create a “mda” user and group since the previous use of “nobody”
\n was not fully secure. This user and group is also used by default in new installs.<\/p>\n
* Failed updates to the ‘orderbooks’ table would log more than one error for each error.<\/p>\n
* The AppArmor profile have been updated to work with MariaDB, the previous profile referenced
\n the MySQL profile that is normally installed with the MySQL server but the MySQL profile
\n incuded in MariaDB is empty so the MDA could not access the MySQL socket in \/run\/mysqld\/mysqld.sock<\/p>\n
* Write the current size and the configured maximum size of the internal hash table used for
\n the orderbooks to the output of “mda –status” as ‘instrument-hash-size’ in the format:
\n ‘current_value\/maximum_value’. The maximum_value can be configured in mda.config under the
\n ‘MILLISTREAM’ tab with the ‘instrumenthashsize’ property, the default value is ‘100000’.<\/p>\n
As earlier announced, as of v0.9.33 the database schema is developed independently of
\nthe MDA and the latest schema including upgrade scripts is available on our ftp server
\nunder the documents section (MDA_schemas_[version].zip). As of this writing the latest
\ndatabase schema is v85 and thus the file is available from:
\n ftp:\/\/ftp.millistream.com\/documents\/MDA_schema_86.zip<\/p>\n
Do note however that the latest schemas are only needed if you need the new columns\/tables,
\nthey are not mandatory to operate the MDA!<\/p>\n
We consider MDA 0.9.38 to be the best version of MDA available and we
\nrecommend that users of older versions upgrade as soon as possible.<\/p>\n
MDA 0.9.38 is available for download from the following locations:<\/p>\n
Windows installer: ftp:\/\/ftp.millistream.com\/binaries\/windows\/
\nRed Hat \/ CentOS: https:\/\/packages.millistream.com\/rpm\/
\nDebian \/ Ubuntu: https:\/\/packages.millistream.com\/apt\/
\nSource code: ftp:\/\/ftp.millistream.com\/sources\/
\nDocumentation: ftp:\/\/ftp.millistream.com\/documents\/mda.pdf<\/p>\n
Windows users upgrade by running the installer for the new version.<\/p>\n
Linux users who have added our apt or yum repositories can upgrade by simply
\nissuing “apt-get update && apt-get upgrade” (Debian\/Ubuntu) or
\n“yum upgrade” (Red Hat\/CentOS).<\/p>\n","protected":false},"excerpt":{"rendered":"
The Millistream MDA project team is pleased to announce the release of version 0.9.38 of our open source application for updating SQL servers with data from the Millistream Data Feed. * For instruments that receive both a LastPrice and a NAV the ‘diffX’ and ‘diffXprc’ values in the ‘performance’ table could be accidentally calculated using […]<\/p>\n","protected":false},"author":1,"featured_media":9,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49],"tags":[],"class_list":["post-3469","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology-news"],"yoast_head":"\n