Sri vlogs
Sri vlogs
  • 45
  • 100 110
MySQL 8 User management | Copy password hash with caching_sha2_passwo | print_identified_with_as_hex
In this video, I have tried to address the issue with copying the password hash with caching_sha2_password plugin. I also explored the parameter "print_identified_with_as_hex" to show, how that helps on migrating the users from one environment to another environment.
Please let me know, if you have any feedback or topic suggestions. Subscribe my channel for more MySQL related videos. Share it with your MySQL friends too. Thanks!
Переглядів: 245

Відео

Galera Cluster how the SNAPSHOT ISOLATION works | Architecture | Isolation level | MySQL | MariaDB
Переглядів 16421 день тому
In this video, I have tried to explain the various Isolation levels and How that impacts the Galera Cluster. I have explained the SNAPSHOT ISOLATION level with demo. Part of this, I also touched the Galera Certification based replication architecture. reference: galeracluster.com/library/documentation/certification-based-replication.html Please put your feedback and Questions and suggestions in...
ProxySQL behavior when MySQL replication lag is NULL instead of numbers | MySQL | Async Replication
Переглядів 2882 місяці тому
In this video, I have tried to explain about the ProxySQL parameters "max_replication_lag" and "mysql-monitor_slave_lag_when_null". I am pretty sure, understanding those parameters would be really helpful. As usual, I tried to explain those parameters with the demo. Please add the questions in the comment section. I would be happy to respond. And, please subscribe my channel if you like the con...
MariaDB | MySQL Data Center Migration | Replication filter | Multi Source replication | RollbackPlan
Переглядів 6947 місяців тому
In this video I have tried to explains the complete logic behind the Data Center migration using the MariaDB Instances. As a part of this tutorial, I have explained how I am managed to migrate the data from one DC to another DC with suitable rollback plan. By checking this tutorial, you might come to know about, How can split the data from one instance to two different instances. How to use the...
MySQL InnoDB Cluster | Complete Tutorial | Architecture | Single / Multi primary | MySQL Router
Переглядів 4,6 тис.9 місяців тому
In this video, I have explained the complete details about the InnoDB Cluster. It covers the following aspects, Overview Architecture ( Async replication vs Group replication ) MySQL, Shell, Router Installation InnoDB Cluster configuration MySQL Router configuration InnoDB Cluster Single (or) Multi primary Promoting any node as a primary member. Please give your feedback on the comment section....
MySQL Performance | Understanding MySQL Collation AI, CI, AS, CS | Query Optimisation techniques
Переглядів 1,1 тис.11 місяців тому
In this video, I tried to explain the following topics with a complete DEMO. MySQL collation and the role of AI, CI, AS, and CS in the collation How the UPPER and LOWER functions working The production use case with Collation and UPPER/LOWER functions I hope this video will be helpful in understanding those topics in a better way. If you have any comments or feedback please reach me directly or...
PMM for MySQL | Monitoring | Installation |Alert configuration to Slack | Custom dashboard | Percona
Переглядів 3,1 тис.11 місяців тому
In this video, I have tried to explain the following topics about PMM with a complete DEMO. I hope this will be helpful to the PMM and Database users. PMM Installation and Configuration Alerts configurations to Slack channel Testing the alerts Creating a custom dashboard with MySQL Data source Please let me know if you have any questions or doubts. You can reach me directly through my LinkedIn ...
Percona XtraDB Cluster | Installation | Configuration | Galera cluster | MySQL | Tutorial | Part 1
Переглядів 2,6 тис.Рік тому
In this video, I have tried to explain the Percona XtraDB Cluster installation and configuration. I have added the detailed demo session to show the complete steps involved in the 3 node PXC setup.
MySQL Point-In-Time-Recovery using Percona Xtrabackup and Binary logs | MySQL DBA | Demo | Tutorial
Переглядів 2,1 тис.Рік тому
In this video, I have tried to explain the MySQL Point-In-Time-Recovery process with simple example. The video covers the complete practical demo for the better understanding. Please let me know, If you have any suggestions are questions. You can comment in video or reach me directly for any questions. Subscribe my channel for more MySQL related videos! Thanks!
MySQL InnoDB Architecture | Understanding the Temporary Tablespaces | .ibt files | ibtmp1 |Variables
Переглядів 2,1 тис.Рік тому
Do you want to see how the MySQL temporary tables are getting created in disk or memory? Do you want to understand what is .ibt and ibtmp1 files and when they are updated? Do you wnat to understand what is tmp_table_size and max_heap_table_size? Then hopefully this is the right video for you! In this video, I tried to explain all those things based on my understanding :wink: . If you have any f...
Impact of storing JSON data in MySQL | Partial JSON updates in Binary log | Performance | MySQL 8
Переглядів 338Рік тому
In this video, I have tried to explain about "How the big JSON columns are impacting the database performance, disk space and network usage in MySQL. Then, showed the demo about "How to implement the "Partial JSON" feature and how that is helping with big JSON columns" You can share your feedback in the comment section or you can directly reach me through LinkdIN or Mobile. Please subscribe my ...
MySQL Tips and Tricks | Choosing right data type matters! | VARCHAR vs INT | MySQL DBA | Session 1
Переглядів 347Рік тому
I have created a new playlist "Tips and Tricks" to share the short interesting videos. And, here is the sample of it!! In this video, I tried to explain why choosing the right data type is matters. And, the impact of single quotes on VARCHAR columns. You might like this! If you like this video, please share it to your friends and support my channel for more MySQL and related technology videos. ...
MySQL GTID Replication | Different ways to SKIP the Replication errors | Part - 2 | MySQL DBA
Переглядів 1,4 тис.Рік тому
In this video, I have tried to explain the Different methods available to skip the replication error in GTID environmnet. I have explained the following topics and showed the demo as well. * sql_slave_skip_counter * slave_exec_mode * skip_slave_errors * pt-slave-restart * injecting the empty transaction * removing the record which creating the issue. If you have any questions, you can comment i...
MySQL GTD Replication | Understanding GTID_EXECUTED | GTID_PURGED | Retrieved/Executed_Gtid_Set
Переглядів 2 тис.Рік тому
In this video, I have tried to explain the MySQL GTID replication configuration and also tried to explain the GTID structure and parameters GTID_EXECUTED, GTID_PURGED, Retrieved_Gtid_Set, Executed_Gtid_Set. Hope this video is helpful! I would like to see the feedback! If you have any questions, you can reach me directly or comment in the Video. Please share this video to your friends, who are l...
How MIXED based MySQL Replication create Data Inconsistency |Drawback | Timezone Issue| binlogFormat
Переглядів 330Рік тому
In this video, I have explained about - How the "MIXED" based binlog format can create the Data Inconsistency in your replication environmnet. I tried to explain the different binlog formats and their structure in the binary log. And, how the Mixed format is working with different time-zone environment. If you have any questions (or) comments (or) recommendations please use the comment window, ...
Mysqldump and single-transaction better together for InnoDB tables | MySQL Backup | LOCK | Demo
Переглядів 1,1 тис.Рік тому
Mysqldump and single-transaction better together for InnoDB tables | MySQL Backup | LOCK | Demo
Why the STATEMENT based replication is dangerous? | MySQL Replication | ROW vs STATEMENT | Demo
Переглядів 535Рік тому
Why the STATEMENT based replication is dangerous? | MySQL Replication | ROW vs STATEMENT | Demo
MySQL Performance Tuning | Query Optimisation Techniques | Joins optimisation | Part 1
Переглядів 1,8 тис.Рік тому
MySQL Performance Tuning | Query Optimisation Techniques | Joins optimisation | Part 1
MySQL Deadlocks | pt-deadlock-logger | innodb_print_all_deadlocks | part 1
Переглядів 1,7 тис.Рік тому
MySQL Deadlocks | pt-deadlock-logger | innodb_print_all_deadlocks | part 1
MySQL Asynchronous Replication LOad balancing using ProxySQL | Configurations | Testing
Переглядів 4 тис.2 роки тому
MySQL Asynchronous Replication LOad balancing using ProxySQL | Configurations | Testing
MySQL Binlog side filtering behavior with ROW and STATEMENT based binlog formats | Percona Server
Переглядів 5652 роки тому
MySQL Binlog side filtering behavior with ROW and STATEMENT based binlog formats | Percona Server
MySQL Upgrade Checker | MySQL Upgrade | Percona server 5.7 to 8.0.27 | MySQL Shell utility | Percona
Переглядів 4,2 тис.2 роки тому
MySQL Upgrade Checker | MySQL Upgrade | Percona server 5.7 to 8.0.27 | MySQL Shell utility | Percona
Percona Audit Log Plugin Configurations & Operations | MySQL Monitoring | MySQL Security | Audit
Переглядів 2,2 тис.2 роки тому
Percona Audit Log Plugin Configurations & Operations | MySQL Monitoring | MySQL Security | Audit
MySQL InnoDB buffer pool configuration | Role of InnoDB buffer pool chunk size and Instances
Переглядів 7 тис.2 роки тому
MySQL InnoDB buffer pool configuration | Role of InnoDB buffer pool chunk size and Instances
Various way to configure MySQL variables | SESSION | GLOBAL | my.cnf | PERSIST | init-file | mysqld
Переглядів 1,6 тис.2 роки тому
Various way to configure MySQL variables | SESSION | GLOBAL | my.cnf | PERSIST | init-file | mysqld
MySQL Replication troubleshooting part 2 | Data sync using pt-table-checksum and pt-table-sync
Переглядів 2,4 тис.2 роки тому
MySQL Replication troubleshooting part 2 | Data sync using pt-table-checksum and pt-table-sync
Replication troubleshooting part 1 | Duplicate entry | Can't find record | sql_slave_skip_counter
Переглядів 2,9 тис.2 роки тому
Replication troubleshooting part 1 | Duplicate entry | Can't find record | sql_slave_skip_counter
Percona Xtrabackup | Streaming backup | Replication setup | Part 4 | MySQL tutorial 18
Переглядів 1,3 тис.2 роки тому
Percona Xtrabackup | Streaming backup | Replication setup | Part 4 | MySQL tutorial 18
Percona Xtrabackup | Incremental backups | Restore | Part 3 | MySQL Tutorial 17 for beginners
Переглядів 2,6 тис.2 роки тому
Percona Xtrabackup | Incremental backups | Restore | Part 3 | MySQL Tutorial 17 for beginners
Percona Xtrabackup | Single table restore | MySQL tutorial | Part 2
Переглядів 1,7 тис.2 роки тому
Percona Xtrabackup | Single table restore | MySQL tutorial | Part 2

КОМЕНТАРІ

  • @tamilscientist5260
    @tamilscientist5260 День тому

    Thanks

  • @Unfoldingmoments
    @Unfoldingmoments 4 дні тому

    can you provide any documentation for this ?

  • @tamilscientist5260
    @tamilscientist5260 4 дні тому

    Thanks

  • @sagarghodke6945
    @sagarghodke6945 6 днів тому

    Excellent video, could you please make video for new instance creation

  • @GIRISHPOLAMARASETTI
    @GIRISHPOLAMARASETTI 10 днів тому

    Great 👍

  • @Tamil-family_vlog
    @Tamil-family_vlog 10 днів тому

    Excellent ❤

  • @ranvijaymehta
    @ranvijaymehta 10 днів тому

    Thanks Sir

  • @aanchalrani1380
    @aanchalrani1380 10 днів тому

    Thanks, for the informative contents 😊

  • @Pandaaaa-vh
    @Pandaaaa-vh 10 днів тому

    Hi Sri, I am watching your session, those really good. Can you also make a video on understanding comple information on show engine innodb status output and how to take actions based on the outcome

    • @hercules7sakthi
      @hercules7sakthi 10 днів тому

      thanks, it will be huge. I will try to make it one or at least with few part of videos.

  • @PhyoThiriTun-DBA-yt5ng
    @PhyoThiriTun-DBA-yt5ng 19 днів тому

    Hi Sir , how to configure the Galer cluster to failover properly if some of the nodes down which option of wsrep various need to setup properly ?

  • @shubhrajitsutar5803
    @shubhrajitsutar5803 25 днів тому

    could you please upload a video for upgrading without downtime or some other upgrading technology

  • @ranvijaymehta
    @ranvijaymehta 26 днів тому

    Thanks Sir

  • @shubhrajitsutar5803
    @shubhrajitsutar5803 26 днів тому

    can you please provide sysbench repo link or steps to install on ec2

    • @hercules7sakthi
      @hercules7sakthi 26 днів тому

      github.com/akopytov/sysbench

    • @hercules7sakthi
      @hercules7sakthi 26 днів тому

      Usually the native repo should have sysbench apt-get install sysbench yum install sysbench can work

    • @shubhrajitsutar5803
      @shubhrajitsutar5803 26 днів тому

      @@hercules7sakthi # yum install sysbench getting below error No match for argument: sysbench Error: Unable to find a match: sysbench

    • @hercules7sakthi
      @hercules7sakthi 26 днів тому

      @shubhrajitsutar5803 which version and OS you are using?

  • @JAIGANESH-gd3qj
    @JAIGANESH-gd3qj Місяць тому

    Your videos are very useful for me! I have learned a lot from your videos. Thanks for making such amazing contents!

  • @tamilscientist5260
    @tamilscientist5260 Місяць тому

    Amazing lecture! Thanks for making such beautiful videos. Please keep post more videos. Love to learn from you. Thanks again!

  • @yogeshbhamre4643
    @yogeshbhamre4643 Місяць тому

    my data directory is /data/mysql and after the upgrade its showing default /var/lib/mysql . and this is reason why i am not able to see my user schemas there. pls advise

    • @hercules7sakthi
      @hercules7sakthi Місяць тому

      After upgrade, the MySQL service will be using the brand new my.cnf located in the default location. You can just replace your custom config ( my.cnf before upgrade ) and restart the MySQL service. It should work.

  • @sudeeptachoudhury
    @sudeeptachoudhury Місяць тому

    Good and Clear concept. Almost all are address, More on Router log analysys

  • @suneeraboobacker5825
    @suneeraboobacker5825 2 місяці тому

    Great explanations.... Thanks a lot Sri

  • @Tamil-family_vlog
    @Tamil-family_vlog 2 місяці тому

    Super..nice topic.. but daily updated ❤

  • @bhaskarjadapalli4137
    @bhaskarjadapalli4137 2 місяці тому

    Please share how to set up proxy SQL document

    • @hercules7sakthi
      @hercules7sakthi 2 місяці тому

      I usually do not maintain any documents with me. I would recommend to go through the ProxySQL documentations and blogs available on internet. They should be very helpful. You can also find some useful videos in our channel related to ProxySQL.

  • @yetfix
    @yetfix 2 місяці тому

    Loved it

  • @yetfix
    @yetfix 2 місяці тому

    Great jobs

  • @CryptoThink
    @CryptoThink 2 місяці тому

    You need to authorize server between them? with ssh?

    • @hercules7sakthi
      @hercules7sakthi 10 днів тому

      no need of SSH authorization. Backup will be transferred through port during SST. Group communication will also happens through port.

  • @DhirajPujari-w5q
    @DhirajPujari-w5q 2 місяці тому

    how can i use proxy SQL in between the client of MariaDB app server and the master and slave servers. Is there any video or documentation you have created on it? Im using frappe framework which uses MariaDB as a database i want to replicate that MariaDB database into one master and multiple slave and in between app and master slave i want to use ProxySQL for monitoring read and write queries. Thank You for this video as well..Good Luck

  • @mayurmakwana8153
    @mayurmakwana8153 2 місяці тому

    Unable to add instance

  • @manish0554
    @manish0554 3 місяці тому

    Hi, How to replicate innodb cluster to one instnace slave. I want to replicate the DB for other purpase like Backup/analytics SQLs

  • @swernalakshmib6795
    @swernalakshmib6795 3 місяці тому

    Thank you for this....The best

  • @parassahu9035
    @parassahu9035 3 місяці тому

    hello sir please add video regarding pt-online-schema-change

  • @suneeraboobacker5825
    @suneeraboobacker5825 4 місяці тому

    Fantastic...😍

  • @pawanrao9917
    @pawanrao9917 4 місяці тому

    Hi can you make one video for Dc Dr innodb cluster replication

  • @UpmanyuTiwari
    @UpmanyuTiwari 4 місяці тому

    superb explanation , please create more such videos.

  • @ajinkyakharate4581
    @ajinkyakharate4581 4 місяці тому

    In case of multiple insert statements in a transaction, if we cannot use sql_slave_skip_counter then what we can use?

  • @handsomevillian
    @handsomevillian 4 місяці тому

    after all this i am missing the file called mysql-auto.cnf in /var/lib/mysql directory, what should i do to retrieve it

  • @mohanb02
    @mohanb02 5 місяців тому

    great Sri! you made it all appear so easy to set up a MySql cluster. Fantastic job. Just a doubt, can this procedure be followed in case of dockerised mysql server instances?

  • @leopardcourier-ht4lt
    @leopardcourier-ht4lt 5 місяців тому

    hi sri, i will installed this one pmm. after i will launch the mysql instance they will give me error this type of error, Connection check failed: dial tcp 127.0.0.1:3306: connect: connection refused. please give me solution

  • @handsomevillian
    @handsomevillian 5 місяців тому

    The words fall short to appreciate your brilliant work, lets see what we face at the time of hands on . Thank you sir Sri.

  • @aanchalrani1380
    @aanchalrani1380 6 місяців тому

    Very useful video. Thanks Sri for making study video for us, it’s really helpful to clear our concepts

  • @SaravananL-cw8wb
    @SaravananL-cw8wb 6 місяців тому

    Nice Video

  • @creativeground2245
    @creativeground2245 6 місяців тому

    Thank you, Sri, for your excellent video. It was very clear and easy to understand. I come from an MSSQL background and am trying to learn MySQL as well. I'm familiar with master-slave replication, but the issue is that it requires manual failover. Once one node is down, it cannot automatically redirect the application to the other node. Is there any way to achieve automatic failover in InnoDB replication? I mean, once innodb1 is down, innodb2 will become the primary node.I followed your instructions and intentionally shutdown innodb1, but it is not failing over or reachable from the router node. Looking for your respose. Thank you.

  • @kamleshyadav-lx9xs
    @kamleshyadav-lx9xs 6 місяців тому

    Hi Sri have u created vlog for MYSQL upgrade for window server ??

  • @michaelgallo5940
    @michaelgallo5940 6 місяців тому

    im not sure if im setting this up correctly, i keep getting timed out when trying to run mysql after putting the cluster

    • @hercules7sakthi
      @hercules7sakthi 6 місяців тому

      Hello, Could you share the error here : if possible?

    • @michaelgallo5940
      @michaelgallo5940 6 місяців тому

      @@hercules7sakthi It involves the pid file where it says WARNING: mysql pid file /var/lib/mysql/user.pid empty or not readable and it times out

  • @naziramad6542
    @naziramad6542 6 місяців тому

    thanks a lot

  • @michaelgallo5940
    @michaelgallo5940 6 місяців тому

    how would we remove a node?

  • @YashrajTalokar
    @YashrajTalokar 6 місяців тому

    Did you do this on AWS console?

  • @MohammedAli-rt3gs
    @MohammedAli-rt3gs 6 місяців тому

    Good video but need your notepad

  • @bhupendrapatel6277
    @bhupendrapatel6277 6 місяців тому

    Serously well explained

  • @shrinidhig3672
    @shrinidhig3672 6 місяців тому

    wow.. what a demo.. I don't need to watch any other video. Crystal clear explanation. Thanks Sri ❤

  • @cmillthesnake4849
    @cmillthesnake4849 7 місяців тому

    Great video and explanation. Will you discuss mysql in aws environment in future?

  • @rahulpardeshi4427
    @rahulpardeshi4427 7 місяців тому

    One of the best video on ProxySQL thank for this social cost. If possible please share video on how to setup ProxySQL cluster.