I run docker compose with MaxScale and try to imitate the situation when one of the msc node is disconnected and connected again. I can see in 'mcs cluster status' that dbrm_mode is offline and when I try to make queries from my app I get an error 'Lost connection to DDLProc' until I restart cluster with 'mcs cluster restart' command. Isn't it suppose to work automatically? What other settings may I need? Is this docker image production ready?
My company was evaluating it for use in production and although it seems fast when you do something it doesn’t like the entire db simply crashes. Would love to talk someone about it
SAP HANA is an interesting product that stores data in memory. This likely requires more expensive hardware than with MariaDB. In general, data storage is less cost-efective with in-memory solutions. Memory requirements scale with your data. There could also be advantages in ColumnStore over SAP HANA regarding backups, management, and even security-topics worth exploring during evaluation phases. On the other hand, yes, with CS data is copied so that it can be stored in an optimal way for both transactional and analytical workloads.
why do all computer geeks use only terminal which is not very ergonomic - is it some kind of challenge? why not use some IDE where results would be more user friendly... always wondering
For database companies, commandline utilities and terminals are kind of the same experience across operating systems, so it's a good way to show things. When you pick one IDE then people that use a different IDE and feel like the video isn't for them. Also I think you have a decent size community of developers that just don't use IDEs at all, and work at the command line, or with text editors, and do a lot of bash scripting
so much easier to start with Docker! And whoa, the ingest / query is *wicked fast* for Columnstore
I run docker compose with MaxScale and try to imitate the situation when one of the msc node is disconnected and connected again. I can see in 'mcs cluster status' that dbrm_mode is offline and when I try to make queries from my app I get an error 'Lost connection to DDLProc' until I restart cluster with 'mcs cluster restart' command. Isn't it suppose to work automatically? What other settings may I need? Is this docker image production ready?
Thank you for sharing, bro! :)
When I try to run this image using max scale I can't make queries. I get an error ' Cannot execute the statement. DBRM is read only"
Did you provision ColumnStore? docker exec -it mcs1 provision mcs1
@@alejandro_mariadb yep. I found out that I have to manually start cluster after every docker container restart.
@@palychbasist I wonder if there's an option to start it automatically...
Looks nice. How about WRITES, does the ColumnStore struggle with those?
The db is crashing on me when trying to do some unions. Have to restart:(. Should the container not run on Mac?
the columstore docker image does run on arm CPUs hub.docker.com/r/mariadb/columnstore
My company was evaluating it for use in production and although it seems fast when you do something it doesn’t like the entire db simply crashes. Would love to talk someone about it
@@tbone587 Any useful information in the logs? Please join the MariaDB Community Slack where you'll get more eyes on your question.
SAP HANA is both transactional and columnar. So why copying all data twice?
SAP HANA is an interesting product that stores data in memory. This likely requires more expensive hardware than with MariaDB. In general, data storage is less cost-efective with in-memory solutions. Memory requirements scale with your data. There could also be advantages in ColumnStore over SAP HANA regarding backups, management, and even security-topics worth exploring during evaluation phases. On the other hand, yes, with CS data is copied so that it can be stored in an optimal way for both transactional and analytical workloads.
why do all computer geeks use only terminal which is not very ergonomic - is it some kind of challenge? why not use some IDE where results would be more user friendly... always wondering
For database companies, commandline utilities and terminals are kind of the same experience across operating systems, so it's a good way to show things. When you pick one IDE then people that use a different IDE and feel like the video isn't for them. Also I think you have a decent size community of developers that just don't use IDEs at all, and work at the command line, or with text editors, and do a lot of bash scripting
what is this ? Can someone help me understand what language is she speaking?
She's speaking English in the video - perhaps try enable subtitles? support.google.com/youtube/answer/100078?hl=en&co=GENIE.Platform%3DiOS