Getting Started with Database containers

Question

Post reply

Getting Started with Database containers

Steve Jones - SSC Editor

SSC Guru

Points: 736172
More actions
February 4, 2019 at 12:00 am

#382665

Comments posted to this topic are about the item Getting Started with Database containers

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

reece.watkins 16343 Valued Member Points: 68 More actions · Answer 1

You should probably cover using a Docker Volume for persistent/shareable storage options.

Bruno Campos Grasshopper Points: 11 More actions · Answer 2

Agreed with reece.watkins 16343.
It would be good to cover persistent storage and how this can greatly help with patching.

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 3

Persistent volumes is a separate item. This was just to help people get started.

sqlfriend SSC Guru Points: 52781 More actions · Answer 4

Thanks Steve for this easy to understand article for beginners for docker.

One question: the docker in this example is for windows desktop ,just curious , if using a Linux laptop, is there a docker for Linux desktop to download? And it has to use Linux version not windows correct?

Thanks

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 5

I used Docker for Windows, though I'm running Linux containers with the WSL (Windows subsystem for Linux).

For Linux, depends on OS. There is a docker application which adds the engine, a client, and a daemon server.
Ubuntu: https://www.digitalocean.com/community/tutorials/how-to-install-and-use-docker-on-ubuntu-16-04
Redhat: https://www.unixarena.com/2018/06/how-to-install-docker-on-redhat-linux-rhel-centos.html/

Others, Google for what to do. Basically add a key for the docker repository, then yum, apt-get, etc. Mac, there's an equivalent docker client.

sqlfriend SSC Guru Points: 52781 More actions · Answer 6

sqlfriend

SSC Guru

Points: 52781

February 12, 2019 at 12:07 pm

#2021830

Thanks Steve. That is good to know

sqlfriend SSC Guru Points: 52781 More actions · Answer 7

Hi Steve,
I would like to learn Linux as a DBA, not necessarily for SQL server, but for all databases like SQLserver, mySQL, oracle, Postgresql,
I want to download a copy of Unix for my workstation. Windows 10 enterprise.

Should I use docker and container or should I use virtualbox?
I'd like it to be more lightweight and efficient, this is just for my learning experiment?

Thanks,

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 8

If you want to learn Unix/Linux, I'd install a VM and practice there. Working inside a container is OK, but you're slightly crippled, so you don't really learn. The Stairway to SQL Server on Linux has a level that's getting started with the OS.
http://www.sqlservercentral.com/articles/SQL+Server+on+Linux/176220/
There is also a good series on Simple Talk. Need to do a similar one here. - https://www.red-gate.com/simple-talk/sql/sql-linux/how-to-linux-for-sql-server-dbas-part-1/

If you just want to play with the applications, like Oracle, PostgreSQL, etc., containers make this easy. I'd run Docker for Windows with Linux containers and then pull the containers that you need for Oracle, etc.

sqlfriend SSC Guru Points: 52781 More actions · Answer 9

Thanks much Steve for the resources and recommendations.