- 45
- 100 110
Sri vlogs
India
Приєднався 17 сер 2021
MySQL and related technologies videos!
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!
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
Thanks
can you provide any documentation for this ?
no, i am planning to have the blogs
Thanks
thanks, but why this much?? 😇
Excellent video, could you please make video for new instance creation
Great 👍
Excellent ❤
Thanks Sir
Thanks, for the informative contents 😊
My pleasure!
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
thanks, it will be huge. I will try to make it one or at least with few part of videos.
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 ?
could you please upload a video for upgrading without downtime or some other upgrading technology
I will work on it.
Thanks Sir
can you please provide sysbench repo link or steps to install on ec2
github.com/akopytov/sysbench
Usually the native repo should have sysbench apt-get install sysbench yum install sysbench can work
@@hercules7sakthi # yum install sysbench getting below error No match for argument: sysbench Error: Unable to find a match: sysbench
@shubhrajitsutar5803 which version and OS you are using?
Your videos are very useful for me! I have learned a lot from your videos. Thanks for making such amazing contents!
Amazing lecture! Thanks for making such beautiful videos. Please keep post more videos. Love to learn from you. Thanks again!
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
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.
Good and Clear concept. Almost all are address, More on Router log analysys
Great explanations.... Thanks a lot Sri
Super..nice topic.. but daily updated ❤
Please share how to set up proxy SQL document
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.
Loved it
Great jobs
You need to authorize server between them? with ssh?
no need of SSH authorization. Backup will be transferred through port during SST. Group communication will also happens through port.
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
Unable to add instance
Hi, How to replicate innodb cluster to one instnace slave. I want to replicate the DB for other purpase like Backup/analytics SQLs
Thank you for this....The best
hello sir please add video regarding pt-online-schema-change
Fantastic...😍
Hi can you make one video for Dc Dr innodb cluster replication
Sure, will work on it
superb explanation , please create more such videos.
In case of multiple insert statements in a transaction, if we cannot use sql_slave_skip_counter then what we can use?
after all this i am missing the file called mysql-auto.cnf in /var/lib/mysql directory, what should i do to retrieve it
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?
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
The words fall short to appreciate your brilliant work, lets see what we face at the time of hands on . Thank you sir Sri.
Very useful video. Thanks Sri for making study video for us, it’s really helpful to clear our concepts
Nice Video
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.
Hi Sri have u created vlog for MYSQL upgrade for window server ??
im not sure if im setting this up correctly, i keep getting timed out when trying to run mysql after putting the cluster
Hello, Could you share the error here : if possible?
@@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
thanks a lot
how would we remove a node?
Did you do this on AWS console?
Good video but need your notepad
Serously well explained
wow.. what a demo.. I don't need to watch any other video. Crystal clear explanation. Thanks Sri ❤
Great video and explanation. Will you discuss mysql in aws environment in future?
One of the best video on ProxySQL thank for this social cost. If possible please share video on how to setup ProxySQL cluster.