Category Archives: RDBMS

Docker – Install Other Open source DB

We can quickly install anything on Docker with PostgreSQL: $ docker run –name some-postgres -e POSTGRES_PASSWORD=mysecretpassword -d postgres MariaDB: docker run –name mariadbtest -e MYSQL_ROOT_PASSWORD=mypass -d mariadb/server:10.3 –log-bin –binlog-format=MIXED

Posted in Kubernetes/Docker/Container, Open Source, Others, RDBMS | Tagged , | Leave a comment

Informix on Docker

Today we will discuss how to install/configure informix on Docker, >docker run -it –name ifx –privileged -p 9088:9088 -p 9089:9089 -p 27017:27017 -p 27018:27018 -p 27883:27883 -e LICENSE=accept ibmcom/informix-developer-database:latest   >docker exec -it ifx bash   Other information to consider: … Continue reading

Posted in Kubernetes/Docker/Container, Others, RDBMS | Tagged | 1 Comment

MongoDB 4.0.2 release

As i was discussing about MongoDB in my earlier blog, on NOSQL ACID stands for Atomic, Consistent, Isolation, and Durable we generally call this for RDBMS systems BASE, which is typical for NoSQL systems, stands for Basically Available, Soft State, … Continue reading

Posted in Future DBA, NoSQL, Others, RDBMS | Tagged , | Leave a comment

Oracle Atonomous

Last month Oracle – (Larry Ellison, CTO and Executive Chairman) has introduced Oracle Autonomous database for OLTP system Oracle has already introduced Autonomous on OLAP system in early this year. This way it is shows that Oracle on Cloud can … Continue reading

Posted in Cloud, Future DBA, News, oracle, Others, RDBMS, Whats New | Tagged , , , , | Leave a comment

What is MemSQL

yeah, MemSQL for me its a combination of RDBMS and NOSQL and more of flexibility of both per our choice, most of the RDBMS going with such concept. NOSQL is compromise with ACID property and flexible for developers it has … Continue reading

Posted in Future DBA, NoSQL, Others, RDBMS, What I learned today, Whats New | Tagged , , , | Leave a comment

Day 4: MySQL Architecture Continue…

MySQL is an open source and configuration of MySQL is very simple and can be customized per the requirement. MySQL works on following options: Option/configuration file (my.cnf) System variables (Local /Global) Status variables My.cnf option file will have various Groups and … Continue reading

Posted in Basic, DB Design, High Avaliability, MySQL, Others, RDBMS, Replication, What I learned today | Tagged , | Leave a comment

Day 2: Introduction to MySQL

Story of MySQL is very interesting and involved emotions in it. This is my understanding and my though on Journey of MySQL. MySQL AB is (“My”) in 1995 by Michael Widenius (Monty) and team, as an open source by community … Continue reading

Posted in History, MySQL, Others, RDBMS | Tagged , | Leave a comment

Day 1: MySQL History

Swedish Company: MySQL AB by – Michael Widenius (Monty), David Axmark and Allan Larsson Name Combination: Michael’s Daughter name –“My” and SQL Initially – PHP DB Extension to open source – not suitable for DBMS – Developed in(C & C++) … Continue reading

Posted in Experts, Future DBA, History, Imp dates, MySQL, Others, RDBMS, What I learned today, Whitepapers | Tagged | Leave a comment