Mysql DBA Training

04/03/2023

Monitoring Using Prometheus
In this lecture you will learn Introduction to Monitoring, Client Libraries, Scraping Pull and Pushing monitoring, Querying, Service Discovery, Node Exporters, Expression Browser and Metric Types and Counter
There are four ways you can describe monitoring a metric, with Prometheus. Counter - Simplest form of metric type. A counter counts elements over time. A counter only goes up or resets. As a consequence, a counter is not naturally adapted for values that can go down or for negative ones. A counter is particularly suited to count the number of occurrences of a certain event on a period, i.e the rate at which your metric evolved over time.
What are Gauges?
Now what if you wanted to measure the current memory usage at a given time?
The memory usage can go down, how can it be measured with Prometheus?
Gauges
Gauges are designed to handle values that may decrease over time. Visually, they are like thermometers: at any given time, if you observe the thermometer, you would be able to see the current temperature value. But, if gauges can go up and down, accept positive or negative values, aren’t they a superset of counters?
Gauges are perfect when you want to monitor the current value of a metric that can decrease over time. Gauges can’t be used when you want to see the evolution of your metrics over time.

*Connect with me*📺 Please subscribe for more awesome videos: https://www.youtube.com/🐦 Follow me on twitter: https://twitter.com/TheSkillPed...

02/03/2023

Prometheus Installation and Introduction | Prometheus Tutorial | Prometheus Features. you will learn about Time Series Database, Introduction to Prometheus,
Prometheus Installation, Prometheus Configuration, Monitoring Servers with Prometheus and Prometheus Architecture.
What Is Prometheus?
Prometheus is an open-source project written in Golang. Some of its components are written in Ruby also. This means you have a single binary executables.
Prometheus is fully Docker compatible, and a number of Prometheus components within Prometheus itself are available on the Docker Hub.
Metrics are the primary way to represent both the overall health of your system and any other specific information you consider important for monitoring and alerting or observability. Prometheus is a leading metric instrumentation, collection, and storage toolkit built at SoundCloud beginning in 2012.
Since then, it's graduated from the Cloud Native Computing Foundation and become the de facto standard for Kubernetes monitoring.
Prometheus Features:
A multi-dimensional data model with time series data identified by metric name and key/value pairs.
PromQL, a flexible query language to leverage this dimensionality.
No reliance on distributed storage; single server nodes are autonomous.
Time series collection happens via a pull model over HTTP.
Pushing time series is supported via an intermediary gateway.
Targets are discovered via service discovery or static configuration.
Multiple modes of graphing and dashboarding support.

*Connect with me*📺 Please subscribe for more awesome videos: https://www.youtube.com/🐦 Follow me on twitter: https://twitter.com/TheSkillPed...

20/09/2018

Definition –MySQL Stored Routines
Features of MySQL Stored Procedures
Disadvantages
Getting Started with MySQL Stored Routines
Work Flow
Checking Stored Procedure
Stored Functions
Examples
Stored Routine Parameter Types

Definition –MySQL Stored Routines Features of MySQL Stored Procedures Disadvantages Getting Started with MySQL Stored Routines Work Flow Checking Stored Proc...

20/09/2018

Topics Covered in This Session: Introduction to MySQL Variables User Variable Syntax Uses of Variables User Variable Properties Prepared Statements Using Pre...

20/09/2018

Privileges in MySQL Levels of Privileges Types of Privileges in MySQL Administrative Privileges Database-Access Privileges Other Privileges Revoking Privileg...

20/09/2018

Username in MySQL
The Grant Tables
User Account
Approaches to Account Management
Creating and Dropping User Accounts
Specifying Account Names
Granting Privileges
Showing Privileges

Agenda of the Session is: User Management in MySQL Username in MySQL The Grant Tables User Account Approaches to Account Management Creating and Dropping Use...

20/09/2018

To Learn or Teach Linux visit www.theskillpedia.com, A Marketplace for Learners and Trainers. What is Covered in this Session : Backup Principles Binary Vers...

08/09/2018

Learn about Metadata and Metadata Access Methods, INFORMATION_SCHEMA to Obtain Metadata INFORMATION_SCHEMA Tables Commands to get Server Metadata The mysqlsh...