Link to home
Start Free TrialLog in
Avatar of marrowyung
marrowyung

asked on

in RAM operation of MySQL

hi,

for MySQL , any feature/way to move all MySQL DB files on RAM , not just logical table / objects?
SOLUTION
Avatar of Apurva Bhandari
Apurva Bhandari
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of marrowyung
marrowyung

ASKER

"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 ?
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??
" 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.
is container like run application as a VM so that other application can run on top of it?
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
"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 ?
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.
"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 ?
Avatar of Tomas Helgi Johannsson
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
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.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
"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.
tks both