Sri vlogs
Sri vlogs
  • 42
  • 90 676
MariaDB | MySQL Data Center Migration | Replication filter | Multi Source replication | RollbackPlan
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 replication filters in MariaDB.
-- How to configure the MariaDB Multi-Connection replication.
If you have any questions or comments please use the comment section or reach out to me directly. Please subscribe my channel and share with your MySQL friends. Thanks!
zhlédnutí: 595

Video

MySQL InnoDB Cluster | Complete Tutorial | Architecture | Single / Multi primary | MySQL Router
zhlédnutí 3,5KPřed 7 měsíci
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
zhlédnutí 945Před 8 měsíci
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
zhlédnutí 2,7KPřed 8 měsíci
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
zhlédnutí 2,2KPřed 10 měsíci
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
zhlédnutí 1,8KPřed rokem
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
zhlédnutí 1,8KPřed rokem
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
zhlédnutí 308Před rokem
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
zhlédnutí 325Před rokem
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
zhlédnutí 1,3KPřed rokem
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
zhlédnutí 1,8KPřed rokem
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
zhlédnutí 304Před rokem
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
zhlédnutí 993Před rokem
In this video, I have explained about the Mysqldump option "single-transaction" to take the consistent backup for InnoDB tables. I also showned the demo of how this option is impacting with the Table LOCKs. If you have any questions (or) comments (or) recommendations please use the comment window, or you can reach me directly. I am also conducting the MySQL training, If you interested please re...
Why the STATEMENT based replication is dangerous? | MySQL Replication | ROW vs STATEMENT | Demo
zhlédnutí 465Před rokem
In this video, I have explained about the binary logging format for STATEMENT and ROW based binary log formats. And, I given the demo about how the STATEMENT based replication can create the DATA INCONSISTENCY in your replication environment. If you have any questions (or) comments (or) recommendations please use the comment window, or you can reach me directly. I am also conducting the MySQL t...
MySQL Performance Tuning | Query Optimisation Techniques | Joins optimisation | Part 1
zhlédnutí 1,6KPřed rokem
In this video, I have explained about the Query optimisation technique with Joins. Explained 2 different methods of joining the same data types and joining same charset/collations. Subscribe my CZcams channel for more MySQL and related technology videos. If you have any questions, comments, feedbacks please use the comment section and you can also reach me on my Linkdin profile. I am also doing...
MySQL Deadlocks | pt-deadlock-logger | innodb_print_all_deadlocks | part 1
zhlédnutí 1,6KPřed rokem
MySQL Deadlocks | pt-deadlock-logger | innodb_print_all_deadlocks | part 1
MySQL Asynchronous Replication LOad balancing using ProxySQL | Configurations | Testing
zhlédnutí 3,8KPřed 2 lety
MySQL Asynchronous Replication LOad balancing using ProxySQL | Configurations | Testing
MySQL Binlog side filtering behavior with ROW and STATEMENT based binlog formats | Percona Server
zhlédnutí 545Před 2 lety
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
zhlédnutí 3,8KPřed 2 lety
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
zhlédnutí 2KPřed 2 lety
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
zhlédnutí 7KPřed 2 lety
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
zhlédnutí 1,5KPřed 2 lety
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
zhlédnutí 2,3KPřed 2 lety
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
zhlédnutí 2,8KPřed 2 lety
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
zhlédnutí 1,2KPřed 2 lety
Percona Xtrabackup | Streaming backup | Replication setup | Part 4 | MySQL tutorial 18
Percona Xtrabackup | Incremental backups | Restore | Part 3 | MySQL Tutorial 17 for beginners
zhlédnutí 2,4KPřed 2 lety
Percona Xtrabackup | Incremental backups | Restore | Part 3 | MySQL Tutorial 17 for beginners
Percona Xtrabackup | Single table restore | MySQL tutorial | Part 2
zhlédnutí 1,6KPřed 2 lety
Percona Xtrabackup | Single table restore | MySQL tutorial | Part 2
Percona Xtrabackup | full backup | restore | How it works | Part 1
zhlédnutí 7KPřed 2 lety
Percona Xtrabackup | full backup | restore | How it works | Part 1
Comparing MySQL schemas using mysqldbcompare | MySQL Utility | MySQL Tutorial 14
zhlédnutí 994Před 2 lety
Comparing MySQL schemas using mysqldbcompare | MySQL Utility | MySQL Tutorial 14
Importance of “log_slave_updates” in MySQL chain replication | MySQL Tutorial 13 for beginners
zhlédnutí 902Před 2 lety
Importance of “log_slave_updates” in MySQL chain replication | MySQL Tutorial 13 for beginners

Komentáře

  • @DhirajPujari-w5q
    @DhirajPujari-w5q Před 18 hodinami

    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 Před 8 dny

    Unable to add instance

  • @manish0554
    @manish0554 Před 21 dnem

    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 Před 24 dny

    Thank you for this....The best

  • @parassahu9035
    @parassahu9035 Před měsícem

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

  • @suneeraboobacker5825
    @suneeraboobacker5825 Před měsícem

    Fantastic...😍

  • @pawanrao9917
    @pawanrao9917 Před měsícem

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

  • @UpmanyuTiwari
    @UpmanyuTiwari Před 2 měsíci

    superb explanation , please create more such videos.

  • @ajinkyakharate4581
    @ajinkyakharate4581 Před 2 měsíci

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

  • @handsomevillian
    @handsomevillian Před 2 měsíci

    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 Před 2 měsíci

    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 Před 2 měsíci

    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 Před 2 měsíci

    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 Před 3 měsíci

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

  • @SaravananL-cw8wb
    @SaravananL-cw8wb Před 3 měsíci

    Nice Video

  • @creativeground2245
    @creativeground2245 Před 3 měsíci

    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 Před 3 měsíci

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

  • @michaelgallo5940
    @michaelgallo5940 Před 4 měsíci

    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 Před 4 měsíci

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

    • @michaelgallo5940
      @michaelgallo5940 Před 4 měsíci

      @@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 Před 4 měsíci

    thanks a lot

  • @michaelgallo5940
    @michaelgallo5940 Před 4 měsíci

    how would we remove a node?

  • @user-yw4ho7pr9e
    @user-yw4ho7pr9e Před 4 měsíci

    Did you do this on AWS console?

  • @MohammedAli-rt3gs
    @MohammedAli-rt3gs Před 4 měsíci

    Good video but need your notepad

  • @bhupendrapatel6277
    @bhupendrapatel6277 Před 4 měsíci

    Serously well explained

  • @shrinidhig3672
    @shrinidhig3672 Před 4 měsíci

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

  • @cmillthesnake4849
    @cmillthesnake4849 Před 5 měsíci

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

  • @rahulpardeshi4427
    @rahulpardeshi4427 Před 5 měsíci

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

  • @prasanthvlog3970
    @prasanthvlog3970 Před 5 měsíci

    Thank you for this video

  • @user-zf7on1si3i
    @user-zf7on1si3i Před 5 měsíci

    Love this, thanks for sharing the knowledge

  • @Tamil-family_vlog
    @Tamil-family_vlog Před 5 měsíci

    very informative, thank you very much🙏

  • @srinivasanv780
    @srinivasanv780 Před 5 měsíci

    I want to change the date format globally , Can you explain

  • @user-zt4rz9qx6b
    @user-zt4rz9qx6b Před 5 měsíci

    it is very informative and given clear picture how this option work. Thank you very much

  • @RAHUL841991
    @RAHUL841991 Před 5 měsíci

    Nice video! helpful

  • @johnnydeals1705
    @johnnydeals1705 Před 5 měsíci

    another good video

  • @johnnydeals1705
    @johnnydeals1705 Před 5 měsíci

    great video. waiting for more videos on PMM

  • @ismaeelmohamedalhassan6028
    @ismaeelmohamedalhassan6028 Před 5 měsíci

    thank you

  • @lucasaspera
    @lucasaspera Před 5 měsíci

    Is it possible to install & configure Percona Audit plugins on MySQL 8 community version?

  • @krishnayadavrayappa9656
    @krishnayadavrayappa9656 Před 6 měsíci

    Hii Sir , I have one doubt . What if the router server goes down? Or crash ?

  • @Nerddog12344
    @Nerddog12344 Před 6 měsíci

    Can i use it for Oracle db

  • @krishnayadavrayappa9656
    @krishnayadavrayappa9656 Před 6 měsíci

    It's really very good explanation.

  • @user-th4zn3de1d
    @user-th4zn3de1d Před 6 měsíci

    Oh.. Thanks God

  • @himalayanflow8645
    @himalayanflow8645 Před 7 měsíci

    Super

  • @prashantgupta8209
    @prashantgupta8209 Před 7 měsíci

    Hi Sri, congrats, and thank you for making this video.

  • @sharmilarajendran8692
    @sharmilarajendran8692 Před 7 měsíci

    Hi Shakthi good explanation keep it up

  • @user-xw4cl7jr1h
    @user-xw4cl7jr1h Před 7 měsíci

    Hi Shakti, thanks this is very useful, can you please make one video on innodb clusterset switchover and switchback between dc and dr

    • @hercules7sakthi
      @hercules7sakthi Před 7 měsíci

      thanks for the feedback! sure will plan for it

    • @krishnayadavrayappa9656
      @krishnayadavrayappa9656 Před 6 měsíci

      ​@@hercules7sakthi please let me know how the application will connect to cluster , through which IP application will connect? What is the cluster IP ? How the router will work during the fail over .

  • @sakthisri1084
    @sakthisri1084 Před 7 měsíci

    Superb 🎉

  • @vishusrangolifoodanddailyv8323

    Hi, congrats and thank you for making this video. One question: is it possible to setup 3 node innodb cluster in prod site, 3 node innodb cluster at DR site and keep async replication between any one node..?

    • @hercules7sakthi
      @hercules7sakthi Před 7 měsíci

      Yes, absolutely. please take a look at the following blog blogs.oracle.com/mysql/post/announcing-mysql-innodb-cluster-read-replicas#:~:text=With%20MySQL%20InnoDB%20Cluster%20Read,what%20the%20secondaries%20can%20handle

  • @alemamangeldinov3880
    @alemamangeldinov3880 Před 7 měsíci

    you did a great job!

  • @ArtFernandez1
    @ArtFernandez1 Před 7 měsíci

    Could you upgrade my MYSQL 5.7 to 8.0 it is only 944 MB

    • @hercules7sakthi
      @hercules7sakthi Před 7 měsíci

      hey, do you face any issues while upgrade? if any doubts you can connect me in whatsapp +919008208584

  • @mahalakshmimuthaiah1514
    @mahalakshmimuthaiah1514 Před 7 měsíci

    Thanks a lot!