StatsD- Metric Agent, What is it and How it works

StatsD is originally a simple daemon developed to aggregate and summarize application metrics. ( StatsD is a standard and, by extension, a set of tools that can be used to send, collect, and aggregate custom metrics from any application. StatsD uses client-server-backend model and three  components are: a client, a server and a backend,  client-server-backend model provides […]

Understanding Kafka

What is Kafka : Kafka is publish and subscribe messaging system which is durable, fast , scalable and fault-tolerant with exceptional performance and high throughput. What Kafka is Used for : Kafka is used for stream processing, website activity tracking, metrics collection and monitoring, log aggregation, real-time analytics, ingesting data into Spark, ingesting data into […]

How to update million+ rows in MySQL

There are some use cases when we need to update a table containing more than million rows. There exist many solution To update row wise. We can do this by writing a script, making a connection to database and then executing queries. Another good way to create another table with data to be updated and […]

PL/SQL Programming MySQL

PL/SQL is a procedural language that Oracle developed as an extension to standard SQL to provide a way to execute procedural logic on the database. The Syntax for a PL/SQL Block DECLARE variable_declarations BEGIN program_code EXCEPTION exception_handlers END; CREATE PROCEDURE and CREATE FUNCTION Syntax in MySQL: DROP PROCEDURE IF EXISTS CALLS; DELIMITER ;; CREATE PROCEDURE […]

Design Patterns

Design patterns are the best practices to solve out specific problems that have evolved over time. Over the many years of practicing software development, experts have figured out ways of solving similar problems. These solutions have been encapsulated into design patterns. Design pattern is a reusable software solution to a specific type of problems. It […]