Databases on Docker

databases-docker

// MySQL
docker run -p 3306:3306 --name some-mysql -e MYSQL_ROOT_PASSWORD=yousafzai -d mysql
sudo docker inspect some-mysql
docker exec -it some-mysql bash
mysql --password
create database db_example;
create user 'springuser'@'%' identified by 'ThePassword';
grant all on db_example.* to 'springuser'@'%';

// Postgres
docker run -p 5432:5432 --name some-postgres -e POSTGRES_PASSWORD=yousafzai -d postgres
sudo docker inspect some-postgres

// MongoDB
docker run -p 27017:27017 --name some-mongo -d mongo
// To get IP
sudo docker inspect some-mongo

// Redis
docker run -p 6379:6379 --name some-redis -d redis

// Cassandra
docker run -p 9042:9042 --name some-cassandra -d cassandra
docker exec -it some-cassandra cqlsh
CREATE KEYSPACE example_keyspace WITH replication = {'class':'SimpleStrategy','replication_factor':1};
USE example_keyspace;
CREATE TABLE users( user_id varchar, age int, email varchar, city varchar,PRIMARY KEY (user_id));
INSERT INTO users(user_id, age, email, city)VALUES ('jsmith',32,'john.smith@example.com','Dallas');
INSERT INTO users(user_id, city) VALUES ('pscott','New Jersey');
INSERT INTO users(user_id, age, email) VALUES ('davidb',37,'david.bergin@example.com');
SELECT * FROM users WHERE user_id='jsmith';

https://github.com/reljicd/spring-boot-cassandra