Author Archives: Vinay

Apache Hadoop Ozone+HDDs and Kubernetes

As Hadoop is already a great on BIG Data, now as you know hadoop has addition stuff in it with concept called “Ozone” works with HDFS Datanode plugin and HDDs. “Ozone is designed to scale to tens of billions of … Continue reading

Posted in BIGDATA, Others, Whats New | Tagged , | Leave a comment

Kubernetes

Have you heard the name Kubernetes, it is another open source in the market by Google and works one Containers, like Docker on Cloud. Kubernetes v1.0 was released on July 21, 2015 by Cloud Native Computing Foundation (CNCF). Future is … Continue reading

Posted in Cloud, Others | Tagged | Leave a comment

Microsoft Acquire GitHub after Linkedin

Microsoft acquires GitHub is a very big news after LinkedIn… that way now Microsoft will grow like anything as considering the information it has at GitHub, it will have a great help of open source information at GitHub will provide … Continue reading

Posted in Basic, News, Others, Whats New | Tagged , , | Leave a comment

Day 25 Optimization

Locking is depends upon Isolation level and Storage Engine. MySQL uses table level locking (instead of page, row, or column locking) for all storage engines except InnoDB, which uses row level locking locking system in MySQL: Implicit Locking: To maintain the … Continue reading

Posted in DeadLock, Lock/Blocking, MySQL, Others, Performance Tuning, What I learned today | Tagged , , , | Leave a comment

Day 24 Replication Setup

Today we will discuss how setup a replication: Master – Slave Replication: Requirement: 2 (Linux) System (MasterServer and SlaveServer) MySQL Installed Connection to both servers are accessible. On Master Server: Edit my.cnf with following information: [mysqld] Log-Bin =MySQL_Binlog Server_ID=1 Create … Continue reading

Posted in Disaster Recovery, High Avaliability, Internal, MySQL, Others, Replication, What I learned today | Tagged , , | Leave a comment

Day 23 Replication

Replication means making copy of the objects and moving transaction from primary server to secondary/standby/Slave server. There are two type of Replication Master-Master Replication Master-Slave Replication Like other RDBMS MySQL works replication on Transactions. The pre requisite of replication is … Continue reading

Posted in MySQL, Others, Replication, What I learned today | Tagged , | Leave a comment

Day 22 Other Storage Engines

So far we have discussed InnoDB, MyIASM and NDB Storage engine which are most standard/common and important storage engine MySQL has, there are some other Storage engine which are specific to the business requirement and used only for their special … Continue reading

Posted in MySQL, Others, Performance Tuning | Tagged , | Leave a comment

Day 21 NDB Storage Engine (Cluster)

MySQL also support High Availability, NDB Storage engine provides high availability- shared-nothing system, NDB Cluster integrates the standard MySQL server with an in-memory clustered storage engine called NDB (which stands for “Network DataBase” NDB Cluster required 3 Nodes required complete the setup: Management node(mgmd): … Continue reading

Posted in Disaster Recovery, High Avaliability, Isolation Level, MySQL, Others | Tagged , , , | Leave a comment

Day 20 Innodb Storage engine

InnoDB is the major Storage engine and is default Storage engine after MySQL 5.5 version. As standard RDBMS requires ACID properties and to make the Enterprise level of the system requires Transaction management. Before this MySQL was known to be … Continue reading

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

Day 19 MyIASM Storage engine

MyIASM storage engine is available from the early stage of MySQL this engine is developed from IASM language and it is used for Read intensive operations. As described in yesterday this Engine was default till MySQL 5.5 and is widely … Continue reading

Posted in General, History, Internal, MySQL, Others | Tagged , , , , | Leave a comment