![Sri vlogs](/img/default-banner.jpg)
- 42
- 90 676
Sri vlogs
India
Registrace 17. 08. 2021
MySQL and related technologies videos!
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!
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
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.
Thank you for this video
Love this, thanks for sharing the knowledge
very informative, thank you very much🙏
I want to change the date format globally , Can you explain
it is very informative and given clear picture how this option work. Thank you very much
Nice video! helpful
another good video
great video. waiting for more videos on PMM
thank you
Is it possible to install & configure Percona Audit plugins on MySQL 8 community version?
Hii Sir , I have one doubt . What if the router server goes down? Or crash ?
Can i use it for Oracle db
It's really very good explanation.
Oh.. Thanks God
Super
Hi Sri, congrats, and thank you for making this video.
thanks
Hi Shakthi good explanation keep it up
thanks!
Yen phone panna attend pannamatengra by Sharmila
Hi Shakti, thanks this is very useful, can you please make one video on innodb clusterset switchover and switchback between dc and dr
thanks for the feedback! sure will plan for it
@@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 .
Superb 🎉
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..?
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
you did a great job!
Could you upgrade my MYSQL 5.7 to 8.0 it is only 944 MB
hey, do you face any issues while upgrade? if any doubts you can connect me in whatsapp +919008208584
Thanks a lot!