in RAM operation of MySQL

hi,

for MySQL , any feature/way to move all MySQL DB files on RAM , not just logical table / objects?
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Apurva BhandariLinux/Cloud/DB/DevOpsCommented:
exactly what do you mean by moving on to the RAM?? what i understand on that i can say you can deploy or run MySQL on docker like application containers.
0
marrowyungSenior Technical architecture (Data)Author Commented:
"exactly what do you mean by moving on to the RAM?"

the whole installation install file all on RAM while all function reserved ! so I mean not just IN-MEMORY table! is about the whole MySQL binary all in RAM and all operation in RAM.

"or run MySQL on docker like application containers."

all these container's binary all in RAM too ? I don't know what diff here is on container and the whole OS.

What is the diff between VM, Container and docker ?
0
Apurva BhandariLinux/Cloud/DB/DevOpsCommented:
container works exactly opposite of VM concept. they will only use user os kernel to run rest of things will be in container like lib bins log data but again it will use the base machine only if you don't want to store any data it will run. but it will use use system resources like ram and HDD. the main difference between VM and container is that in VM the whole system will boot and will run as a completely independent system and container run as application and you can run multiple container too. this can be solution for your query.

in addition to this i think you are looking like portable MySQL where no data and binary will store, it will only need to run??
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

marrowyungSenior Technical architecture (Data)Author Commented:
" VM the whole system will boot and will run as a completely independent system"
yeah.

" container run as application and you can run multiple container too. this can be solution for your query."

then how can the whole DB system move to RAM by this ? what is the draw back of container ?


"in addition to this i think you are looking like portable MySQL where no data and binary will store, it will only need to run"

not portable, is just like I don't want MySQL to run on disk as it is too slow and I want to make it faster! so can MySQL all move to RAM and stay there until I shut it down/restart.
0
marrowyungSenior Technical architecture (Data)Author Commented:
is container like run application as a VM so that other application can run on top of it?
0
Apurva BhandariLinux/Cloud/DB/DevOpsCommented:
anyhow if you're running any application it will utilise ram and processor don't worry about storage one because of storage application will not get slow so i guess don't think to deploy it on ram
0
marrowyungSenior Technical architecture (Data)Author Commented:
"storage one because of storage application will not get slow"

what do you mean I don't understand,  why storage application will not get slow ?

" i guess don't think to deploy it on ram"

there are a database system can do this already and I am not sure if  MySQL can do it , how about Oracle? still In memory table only ?
0
Apurva BhandariLinux/Cloud/DB/DevOpsCommented:
you can use container like docker. in docker you can deploy application and db. same like on same server with different container you can run multiple application and multiple db. but for them need that much amount of ram and processor.
0
marrowyungSenior Technical architecture (Data)Author Commented:
"you can use container like docker"

what is the diff between container and docker in this case.

"you can run multiple application and multiple db. but for them need that much amount of ram and processor."

so they all RAM and never leave RAM ?
0
Tomas Helgi JohannssonCommented:
Hi,

IN memory storage engine is the only option if you want to have tables and data in memory.
Other part of the database should not run on RAM or RAMDISK as it it volatile memory. In fact this is considered bad practice. You will risk loosing all your data on power failure in such setups.  
The nearest option to RAM without risk of loosing data is to have the database stored on SSD M.2 drive preferable on the motherboard.

Regards,
    Tomas Helgi
0
marrowyungSenior Technical architecture (Data)Author Commented:
Tomas,

"The nearest option to RAM without risk of loosing data is to have the database stored on SSD M.2 drive preferable on the motherboard. "

knew it !

but RAM industry is changing towards RAM can keep data now, e.g. Intel latest RAM.
0
Tomas Helgi JohannssonCommented:
Hi,

If you are talking about Intel Optane DC Persistent Memory then yes this can be a game changer. :)
However this is a new technology and combines memory and SSDs if I understand it correctly.
Because this is a new tech and not widely used yet then I would not put my mission critical databases on it until I see some good reviews with some pros and cons memos.
And it raises more questions about the consistency of the data residing in such memory as the power-outage prolongs especially in a distributed and replicated databases.

Regards,
    Tomas Helgi
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
marrowyungSenior Technical architecture (Data)Author Commented:
"If you are talking about Intel Optane DC Persistent Memory then yes this can be a game changer. :)"

yes ! you know HP also offering the server r


"However this is a new technology and combines memory and SSDs if I understand it correctly.
"
seems not !

"Because this is a new tech and not widely used yet then I would not put my mission critical databases on it until I see some good reviews with some pros and cons memos."
yes you are right!

MS is using SQL 2017 for linux + HP DL380 gen 10 + suse linux to offer the world's first diskless DB.
0
marrowyungSenior Technical architecture (Data)Author Commented:
tks both
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.