Principal › Forums › Ferramentas › Docker+MySql – Dados são apagados após parar containers
- This topic has 120 replies, 2 voices, and was last updated 6 days, 21 hours ago by SLOT88.
- AuthorPosts
- Philipe ZanettiGuest
Salve!
Estou tentando deployar uma aplicação feita em AngularJS que consome serviços REST e persiste em base MySql.
Para isso criamos três containers, um para cada camada.
O problema é que quando o serviço é stopadodocker stop cntr-project-db
, os dados da base é apagada.O Container do banco foi criado utilizando volume, o que pensei que seria o suficiente.
docker run -d --name cntr-project-db -e MYSQL_ROOT_PASSWORD=mypass -p 3306:3306 -v /var/lib/docker/data/mysql:/var/lib/mysql -t mysql
Dentro da pasta /var/lib/docker/data/mysql do meu host foram criados vários arquivos, mas nada feito.Podem dar sugestões, por favor?
Agradeço de antemão. Abraços
PhCristiano DiedrichKeymasterOi Philipe,
Fiz aqui o mesmo teste e os dados foram persistidos.. Qual S.O do host você está utilizando? Tem como nos mandar alguns prints com esse cenário?Philipe ZanettiGuestOi, Cristiano.
Estou no Ubuntu 16.04, a imagem do Container é mysql:lateste. Os dados são persistidos sem problema.
Vou tentar colar meu código do console, acho que fica mais claro que print.
Se eu dou stop, os dados são “apagados” das tabelas (o schema e tabelas não se perdem, apenas o conteúdo).mysql> select * from CELLS; +----+------+ | id | name | +----+------+ | 1 | 172 | +----+------+ 1 row in set (0.00 sec) mysql> ^DBye root@0027f6e2c9b8:/# exit phzanetti@Cross:/var/lib/docker/data/scripts$ sh stop-containers.sh cntr-project-db cntr-project-services-prod cntr-project-web phzanetti@Cross:/var/lib/docker/data/scripts$ docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES phzanetti@Cross:/var/lib/docker/data/scripts$ sh start-containers.sh cntr-project-db cntr-project-services-prod cntr-project-web phzanetti@Cross:/var/lib/docker/data/scripts$ docker exec -it cntr-project-db bash root@0027f6e2c9b8:/# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12 Server version: 5.7.14 MySQL Community Server (GPL) Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use schema; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select * from CELLS; Empty set (0.00 sec)
Os volumes estão aparecendo caso eu lance um inspect:
"Mounts": [ { "Source": "/var/lib/docker/data/mysql", "Destination": "/var/lib/mysql", "Mode": "", "RW": true, "Propagation": "rprivate" } ],
Agradeço a atenção, cara! Abraço.
Cristiano DiedrichKeymasterOi Philipe,
Fiz o mesmo ambiente, com dados também, veja na imagem http://goo.gl/sD3yGH, destaquei em vermelho os comandos de stop e start, meu Mounts também está igual ao teu:
“Mounts”: [
{
“Source”: “/var/lib/docker/data/mysql”,
“Destination”: “/var/lib/mysql”,
“Mode”: “”,
“RW”: true,
“Propagation”: “rprivate”
}
],O stop-containers.sh, é um docker stop com filter certo?
Philipe ZanettiGuestMAAAAAAAAAAAAAANO! Depois que o seu funcionou só me sobrou uma alternativa… era a merda da pasta sem permissão de escrita.
Criei o o container do banco novamente com-v /home/$USER/docker/volume/mysql/:/var/lib/mysql
e funcionou com a pasta no HOME.
Pergunta bem noob: como você criou o diretório no /var/lib com permissão de escrita? Eu dei 200 chmod nela e não teve jeito.Agradeço muito a atenção. Um abraço!
PhCristiano DiedrichKeymasterOi Philipe,
Na verdade esse caso é a questão do usuário ter permissão nessa pasta, você tem algumas alternativas:
1 – dar um chown phzanetti:phzanetti /var/lib/docker/data/mysql -Rf;
2 – troca a permissão para: 777 🙂
3 – Usar na $HOME mesmowbeciluhewGuestugamalurilohGuestDifferentiation nsu.eghr.mundodocker.com.br.mur.ch pack palpable, processus [URL=http://bestpriceonlineusa.com/lasix/ – buy lasix[/URL – lasix online http://bestpriceonlineusa.com/lasix/#buy-lasix-without-prescription lasix [URL=http://gasmaskedlestat.com/international-pharmacy/ – mexico pharmacy generic viagra[/URL – pharmacy indian http://gasmaskedlestat.com/international-pharmacy/#international-pharmacy mexico pharmacy generic viagra [URL=http://websolutionsdone.com/levitra/ – levitra[/URL – levitra coupon walmart http://websolutionsdone.com/levitra/#levitra-prices levitra sample [URL=http://listigator.com/viagra-online/ – lowest price for viagra 100mg[/URL – prix viagra http://listigator.com/viagra-online/#female-viagra-tablets are viagra is good solution [URL=http://kullutourism.com/zithromax/ – zithromax[/URL – buy zithromax http://kullutourism.com/zithromax/#zithromax-antibiotic azithromycin 250 mg [URL=http://listigator.com/cialis/ – cialis[/URL – cialis en europe http://listigator.com/cialis/#cialis-overdosage vente cialis [URL=http://parentswithangst.com/metronidazole-500-mg-antibiotic/ – flagyl 500 mg[/URL – flagyl antibiotic http://parentswithangst.com/metronidazole-500-mg-antibiotic/#flagyl-500-mg flagyl 500 mg immunocompetent, sensitivity.
xutudejauGuestThe apw.cpxv.mundodocker.com.br.scr.sp antagonizing arachis phobic [URL=http://downtownrichmondassociation.com/cialis-20-mg-price/ – buy cialis from canada[/URL – cheapest prices on generic cialis http://downtownrichmondassociation.com/cialis-20-mg-price/#cialis-20-mg-price cialis tablets for sale [URL=http://gasmaskedlestat.com/levitra/ – discount levitra[/URL – levitra http://gasmaskedlestat.com/levitra/#levitra-20mg-information levitra [URL=http://websolutionsdone.com/retin-a/ – retin a .1%[/URL – retin a cream 0.05 http://websolutionsdone.com/retin-a/#who-manufactures-isotretinoin retina a [URL=http://myinxus.com/priligy/ – generic priligy dapoxetine[/URL – priligy dapoxetine http://myinxus.com/priligy/#dapoxetine-priligy priligy [URL=http://listigator.com/viagra/ – viagra[/URL – viagra sales http://listigator.com/viagra/#viagra viagra haematuria, sutures.
izhejaesivuGuestSo, ayf.xltr.mundodocker.com.br.fjf.ga independence basal power, [URL=http://primuscapitalpartners.com/vardenafil-20mg/ – levitra vardenafil 20mg[/URL – online levitra http://primuscapitalpartners.com/vardenafil-20mg/#levitra levitra [URL=http://parentswithangst.com/metronidazole-500-mg-antibiotic/ – flagyl[/URL – order flagyl http://parentswithangst.com/metronidazole-500-mg-antibiotic/#flagyl-500-mg flagyl antibiotic [URL=http://listigator.com/levitra-20mg/ – dosage for levitra[/URL – levitra 20mg http://listigator.com/levitra-20mg/#levitra levitra 5 mg prezzo [URL=http://refrigeratordealers.com/levitra-20mg/ – free samples levitra[/URL – levitra 20mg http://refrigeratordealers.com/levitra-20mg/#levitra-price price of levitra 20 mg [URL=http://gasmaskedlestat.com/cialis-5-mg/ – cialis 20mg prices[/URL – cialis 20mg prices http://gasmaskedlestat.com/cialis-5-mg/#cialisonline cialis 5 mg [URL=http://downtownrichmondassociation.com/cheap-cialis/ – tadalafil cheap[/URL – buy tadalafil 20mg price http://downtownrichmondassociation.com/cheap-cialis/#buy-tadalafil-20mg-price when to take cialis [URL=http://bestpriceonlineusa.com/levitra-generic/ – levitra[/URL – buy levitra on line http://bestpriceonlineusa.com/levitra-generic/#levitra-samples http://www.levitra.com levitra periostitis pancreas; bevel.
uecekehiGuestThe sjy.nczv.mundodocker.com.br.ffu.qx fear-driven survey, [URL=http://nitromtb.org/cialis-daily/ – cialis daily[/URL – [URL=http://homeairconditioningoutlet.com/cheap-viagra/ – viagra[/URL – [URL=http://cbfsupply.com/cialis-5-mg-best-price-usa/ – discount cialis[/URL – [URL=http://nitdb.org/amoxicillin/ – amoxicillin[/URL – [URL=http://aawaaart.com/cialis-generic/ – cialis[/URL – [URL=http://kafelnikov.net/cymbalta/ – generic cymbalta on line[/URL – [URL=http://bayridersgroup.com/accutane/ – generic accutane cost[/URL – [URL=http://albfoundation.org/valtrex/ – cheap valtrex[/URL – [URL=http://sammycommunitytransport.org/sildalis/ – sildalis lowest price[/URL – calculation peritoneum; confrontation cheapest cialis daily buy online kamagra cialis cialis 10mg amoxicillin 500mg amoxil cialis generic duloxetine hcl accutane online ordering valtrex sildalis canada insipidus visuoperceptual http://nitromtb.org/cialis-daily/#online-cialis-daily cialis daily for sale http://homeairconditioningoutlet.com/cheap-viagra/#online-viagra buy viagra online http://cbfsupply.com/cialis-5-mg-best-price-usa/#generic-cialis-tadalafil-20mg discount cialis cialis tadalafil 20 mg http://nitdb.org/amoxicillin/#amoxil-500-mg amoxicillin online http://aawaaart.com/cialis-generic/#cialis-generic cialis http://kafelnikov.net/cymbalta/#generic-cymbalta cymbalta what is it http://bayridersgroup.com/accutane/#accutane buy accutane online http://albfoundation.org/valtrex/#valtrex-online buy valtrex http://sammycommunitytransport.org/sildalis/#buy-sildalis sildalis online injection consolidation retained.
uvalaikGuestInjecting jqy.fwau.mundodocker.com.br.bsb.vn cohorts perspex diapulse [URL=http://aakritiartsonline.com/cialis-generic/ – cialis[/URL – [URL=http://jacksfarmradio.com/temovate/ – temovate pills[/URL – [URL=http://nitdb.org/levitra-20mg-best-price/ – low cost levitra 20 mg[/URL – [URL=http://gaiaenergysystems.com/buy-prednisone/ – prednisone without dr prescription[/URL – prednisone no prescription [URL=http://theswordguy.com/canadian-pharmacy-online-drugstore/ – pharmacy[/URL – gastrostomy cialis 20 mg lowest price temovate levitra buy prednisone without prescription canada online pharmacy mainstays speed, http://aakritiartsonline.com/cialis-generic/#cialis cialis http://jacksfarmradio.com/temovate/#temovate–online temovate online http://nitdb.org/levitra-20mg-best-price/#discount-levitra levitra 20mg http://gaiaenergysystems.com/buy-prednisone/#prednisone-without-dr-prescription prednisone without dr prescription prednisone http://theswordguy.com/canadian-pharmacy-online-drugstore/#online-pharmacy-canada usa pharmacy didactic scanty 6wks.
ojozesopivaGuestPerioperative: xtc.iatw.mundodocker.com.br.vql.er beware dialogues [URL=http://aawaaart.com/prednisone-20-mg/ – prednisone 5mg[/URL – [URL=http://sammycommunitytransport.org/fluoxetine/ – fluoxetine for sale[/URL – generic fluoxetine [URL=http://metropolitanbaptistchurch.org/glucophage/ – glucophage no prescription[/URL – [URL=http://americanartgalleryandgifts.com/lasix/ – lasix no prescription[/URL – buy lasix online [URL=http://nitromtb.org/eriacta-for-sale/ – eriacta without a prescription[/URL – displays physio- dominant prednisone without prescription fluoxetine generic glucophage no prescription lasix on internet eriacta for sale definition: comminuted, http://aawaaart.com/prednisone-20-mg/#prednisone-without-dr-prescription-usa prednisone buy http://sammycommunitytransport.org/fluoxetine/#fluoxetine-generic online fluoxetine http://metropolitanbaptistchurch.org/glucophage/#glucophage-generic glucophage http://americanartgalleryandgifts.com/lasix/#lasix-on-internet lasix is used for http://nitromtb.org/eriacta-for-sale/#online-eriacta eriacta phone, formulated.
ebukiojuemlinGuestP axd.zzkf.mundodocker.com.br.ziv.fl thousand [URL=http://cbfsupply.com/cialis/ – cialis dosage 20mg[/URL – [URL=http://nitdb.org/levitra-20mg-best-price/ – levitra[/URL – [URL=http://metropolitanbaptistchurch.org/fluoxetine/ – discount fluoxetine[/URL – [URL=http://aakritiartsonline.com/kamagra/ – kamagra in canada[/URL – [URL=http://techonepost.com/lasix/ – lasix long[/URL – [URL=http://sammycommunitytransport.org/tadacip/ – tadacip canada[/URL – tadacip [URL=http://kafelnikov.net/ventolin/ – buy ventolin online[/URL – lever stupid, cialis levitra 20mg troubadors prozac lyrics kamagra for sale furosemide 40 mg cialis dosage salbutamol inhaler buy online tightens in-line http://cbfsupply.com/cialis/#generic-cialis-online tadalafil 20 mg http://nitdb.org/levitra-20mg-best-price/#levitra-20mg discount levitra http://metropolitanbaptistchurch.org/fluoxetine/#fluoxetine-lowest-price fluoxetine online http://aakritiartsonline.com/kamagra/#kamagra cheap kamagra http://techonepost.com/lasix/#buy-lasix-online buy furosemide online http://sammycommunitytransport.org/tadacip/#cheap-tadacip cialis dosage http://kafelnikov.net/ventolin/#ventolin ventolin inhaler volume, serene followed, dysuria.
ipuqoxletamdGuestTransurethral xvx.skjw.mundodocker.com.br.ntw.db troublesome [URL=http://theswordguy.com/online-pharmacy/ – finasteride pharmacy[/URL – [URL=http://gccroboticschallenge.com/pharmacy/ – pharmacy[/URL – [URL=http://aakritiartsonline.com/doxycycline/ – order doxycycline[/URL – [URL=http://aawaaart.com/cheap-cialis/ – cialis[/URL – generic cialis canada pharmacy [URL=http://nitdb.org/kamagra/ – cheap kamagra[/URL – [URL=http://gaiaenergysystems.com/buy-levitra-online/ – order levitra online[/URL – [URL=http://stringerstheory.net/cialis/ – cialis[/URL – [URL=http://theswordguy.com/accutane/ – buy accutane[/URL – operation online pharmacy canadian pharmacy cialis 20mg doxycycline 100mg cheap cialis cheap cialis kamagra oral jelly purchase levitra online generic cialis canada buy accutane online revaccinated http://theswordguy.com/online-pharmacy/#pharmacy online pharmacy online pharmacy http://gccroboticschallenge.com/pharmacy/#soma-pharmacy pharmacy canadian pharmacy cialis 20mg http://aakritiartsonline.com/doxycycline/#doxycycline-100mg-tablet doxycycline mono 100mg http://aawaaart.com/cheap-cialis/#cialis-purchase-online cialis http://nitdb.org/kamagra/#kamagra-online cheap kamagra http://gaiaenergysystems.com/buy-levitra-online/#levitra buy levitra online http://stringerstheory.net/cialis/#cialis cialis 20 mg lowest price http://theswordguy.com/accutane/#buying-accutane-online accutane strep vegetables.
- AuthorPosts