The Millistream MDA project team is pleased to announce the release of
\nversion 0.9.37 of our open source application for updating SQL servers
\nwith data from the Millistream Data Feed.<\/p>\n
* It was discovered that the columns ‘trades.canceltime’ and ‘trades.agreementtime’
\n where not converted to local time even of the ‘localtime’ setting in mda.confg where
\n set to ‘1’.<\/p>\n
* It was discovered that if the ‘localtime’ in mda.config where set to ‘1’ in order to
\n convert timestamps from UTC to the local time of the machine, the timestamps where
\n truncated to whole seconds, i.e the millisecond part (if available) where removed.<\/p>\n
* The ‘ignoremillisec’ setting in mda.config has been renamed to ‘truncatetime’ (the MDA
\n will however still support ‘ignoremillisec’) and the setting has been extended so that
\n it now support the following values:
\n – 0 : Truncate to microseconds, i.e ‘HH:MM:SS.mmmuuu’ or time(6). This is the default.
\n – 1 : Truncate to whole seconds, i.e ‘HH:MM:SS’ or time(0)
\n – 2 : Truncate to milliseconds, i.e ‘HH:MM:SS.mmm’ or time(3)<\/p>\n
* The CommandTimeout property for the Microsoft SQL Server are now set to ‘0’ to allow queries
\n to complete even if they take a very long time (if the SQL server is busy). If not set as
\n was the case in previous versions of MDA the default value in MSSQL is 30 seconds which could
\n lead to endless loops on very busy SQL servers where the MDA would re-issue the same query over
\n and over again if they took longer to execute than 30 seconds. The new value of ‘0’ means that
\n the timeout is disabled which matches how the other SQL servers work (MySQL\/MariaDB\/PostgreSQL).<\/p>\n
* If the account credentials is invalid then MDA will now log so instead of just logging that
\n it has been disconnected due to the server shutting down.<\/p>\n
* The sql script for MSSQL have been cleaned up so that the ‘time’ column for tables which
\n will never get timestamps with fractional seconds now are time(0) instead of time(7). And
\n the ‘time’ column for the ‘trades’ and ‘orderbooks’ table have been changed from time(7) to
\n time(6) since time(6) will be the highest time resolution that MDA supports. This will only
\n affect new installs and there is no need to update your sql server in order to incorporate
\n these changes since they are purely estetic. <\/p>\n
* The sql script for MySQL (v5.6.4 and above) and MariaDB (any version) have been changed in
\n order to prepare for microsecond resolution in the ‘trades’ and ‘orderbooks’ tables where
\n time(3) have been changed into time(6). There is at the moment no reason to update existing
\n installs since such timestamps are not yet distributed, and is really only needed if you
\n really want to have microsecond resolution in your database once they will be available.<\/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_85.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.37 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.37 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
Information on how to add these repositories are available at
\nftp:\/\/ftp.millistream.com\/binaries\/linux\/<\/p>\n
And as usual, if you have any questions what so ever regarding this release
\nor other things, don’t hesitate to contact us at tech@millistream.com<\/p>\n
Yours,
\n The Millistream Development Team<\/p>\n","protected":false},"excerpt":{"rendered":"
The Millistream MDA project team is pleased to announce the release of version 0.9.37 of our open source application for updating SQL servers with data from the Millistream Data Feed. * It was discovered that the columns ‘trades.canceltime’ and ‘trades.agreementtime’ where not converted to local time even of the ‘localtime’ setting in mda.confg where set […]<\/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-3471","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology-news"],"yoast_head":"\n