[MCOL-412] SUGGESTION: Release MariaDB ColumnStore in Windows Created: 2016-11-17 Updated: 2019-07-09 Resolved: 2019-07-09 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | Build |
| Affects Version/s: | 1.0.5 |
| Fix Version/s: | Icebox |
| Type: | New Feature | Priority: | Major |
| Reporter: | Juan Telleria | Assignee: | Todd Stoffel (Inactive) |
| Resolution: | Won't Do | Votes: | 1 |
| Labels: | Windows, community | ||
| Environment: |
Windows |
||
| Description |
|
Hi! I would like to suggest that MariaDB Columnstore is releassed for Windows 7, 8 or 10. I heard (I am not sure about it) that "Windows 10 Anniversary Update" includes native Ubuntu bash support into the O.S. (Still in Development). Maybe by means of this feature it could be achieved to run MariaDB ColumnStore in Windows: http://www.howtogeek.com/249966/how-to-install-and-use-the-linux-bash-shell-on-windows-10/ I know few about Linux, but hope my suggestion is useful. Thank you. Kind regards, |
| Comments |
| Comment by David Thompson (Inactive) [ 2016-11-17 ] |
|
Currently ColumnStore does not work on the GA version of WLS / Bash for Windows. Some fixes have been made that improve things a little in the insider program version (including ubuntu 16 base) so it will likely work eventually maybe even at the next major anniversary version. Our recommendation for now is to use docker or vagrant on Windows (or Mac) to run ColumnStore: https://mariadb.com/kb/en/mariadb/columnstore-getting-started-mariadb-columnstore-docker-and-vagrant-setup-al/. There is some support for windows in the code base but it will take some work to fully make a native build. |
| Comment by David Thompson (Inactive) [ 2016-12-03 ] |
|
ColumnStore 1.0.5 now works on Bash for Windows using the Windows Insider Slow ring build 14965 and ensuring you re-install bash if upgrading so you get Ubuntu16. This is obviously not a stable platform being an early release but hopefully this will get released into the mainline windows distro soon. |
| Comment by Juan Telleria [ 2016-12-05 ] |
|
Thank you. Great news for the Long Term. Greetings, |
| Comment by Juan Telleria [ 2017-03-05 ] |
|
The Windows 10 Creators Update is probably expected Spring-Summer 2017: Some documentation could be included in the MariaDB Knowledge Base for that date on how to enable Bash for Windows and install & configure MariaDB Columnstore: |
| Comment by David Thompson (Inactive) [ 2017-03-07 ] |
|
Once it's available in a GA release we can do this. I just ran a test on build 15042 in a vm and it still works well enough but is still slower on anything I/O bound than using a native ubuntu 16 vm running in hyper-v or with docker which is sort of the same. |
| Comment by David Thompson (Inactive) [ 2017-04-28 ] |
|
I upgraded to windows 10 creator and the ubuntu install works great with bash for windows. With a quick test i saw similar performance to linux running in a hyper-v vm on the same box. You still have the issue that the lifecycle of linux processes is dictated by the bash shell being open but it's a good option for someone wanting to try without the additional steps of hyper-v / vbox and docker. |
| Comment by Juan Telleria [ 2017-04-28 ] |
|
Good to hear Although my home PC is not very powerful, I will try Columnstore via Windows Bash in it as soon as I have little time, and update "Knowledge Base Documentation" if I see any interesting contributions can be done about this topic. Thank you, |