Video

we are getting a lot of below errors in router log during peak hours , what is the reason and how to solve it ? Version MySQL 8.0.35 Enterprise Edition, Innodb cluster with 3 mysql nodes, single primary mode 2024-06-30 20:27:01 routing INFO [7fa5b2764700] [routing:bootstrap_rw] 10.10.33.34:53886 closed connection before finishing handshake 2024-06-30 20:27:01 routing INFO [7fa5b2764700] [routing:bootstrap_rw] incrementing error counter for host of 10.10.33.34:53886 (now 2) 2024-06-30 20:27:39 routing INFO [7fa5b0f40700] [routing:bootstrap_rw] resetting error counter for 10.10.33.34:53156 (was 2)

Really use full and informative , i need do snap shot and PITR of On prime MySQL instance recovery .

great video!

can you please share the PPT?

Hay lefred - quality tutorial you have made! I was wondering - do you have to cleanup somehow after switching the application to use the cluster instead of the single instance? I am refering to the CHANGE MASTER TO and START SLAVE that were issued on the mysql1 cluster instance. Or you can simply shut down and destroy the source/single instance? Perhaps before shut down and destroy we have to RESET SLAVE ALL on the primary (r/w) server in the cluster? Thanks!

Is it possible to use MySQL Router without cluster? (Just two replicated MySQL instances, for example)

whwre did you get the installe rther ei sno more installer just a zip of files and ofldrs

Mummy

Daddy

I still think it is a missed opportunity to not expand SQL to include machine learning capabilities and take the opportunity to make SQL more like the functional language it wants to be. Will the model explaining tell me something about the actual algorithms used or is everything just a big black box? Can I run my own algorithm within this framework?

Awesome videos, all of these! Thanks for editing and making them available here!

Wow, you couldn’t really voice over the video. Wow, so lazy… dis

great Did not know what histograms are. What I would like to know is in which cases a hash index is recommended. Should hash indexes be allowed by default? Does hash indexes comes with a an additional cost (memory, CPU)?

I cant connect to the database pls help

That code completion drop down menu is not coming for me can you advice me something ?

The MySQL server performs the upgrade tasks previously handled by mysql_upgrade (for details, see Section 2.10.3, “What the MySQL Upgrade Process Upgrades”). Consequently, mysql_upgrade is unneeded and is deprecated; expect it to be removed in a future version of MySQL. Because mysql_upgrade no longer performs upgrade tasks, it exits with status 0 unconditionally. One less thing to do now. I upgraded mysql 8.0.27 to 8.0.34 on debian 12 with the following steps: 1. Log into mysql node, execute: set persist group_replication_start_on_boot = 0; 2. stop mysql server: systemctl stop mysql 3. Update mysql and mysql-shell using MySQL APT Repository. Download the .deb packages, and run "sudo dpkg -i filename.deb" 4. start mysql 5. log into mysql node and execute: set persist group_replication_start_on_boot = 1; 6. You no longer need to use mysql_upgrade 7.restart mysql: systemctl restart mysql dev.mysql.com/doc/refman/8.0/en/linux-installation-debian.html

Sorry to bother, I am unable to use the private key from the resource manager log to connect to the instance. Can you please help?

Great content thanks for the help 😊

Thank you so much! Worked for me when using VM.Standard.E2.1.Micro instead of Ampere compute, which seems to be unavailable at present. If it fails during an initial attempt, it is better to clear out all the partially created artifacts and then start afresh.

Thank you

i have Innodb cluster with 3 MySQL servers and 2 Routers , how to make 2 Routers highly available ? i can do it with KeepaliveD software , is it a good approach in Production environment? if there is a better approach then please guide , thanks

Nice information to be place in our PK or numbers.

Hey thanks, man! was easy to do well explained. thank you!

Nice video, could you explain how to create tables outside of the main data directory

bellissimo video preciso e veloce, grazie!

Merci!! I got a good paying job because of your easy to understand tutorials! 🙏🙏

😚 p͎r͎o͎m͎o͎s͎m͎

Love it!

Lefred, would be nice if you add in the description of the video the list of commands used.

Thank you very much, this video was very useful: I've learned about MySQL CLONE and finally started to use mysqlsh for backups (easier than I thought).

Thanks, It works for me :)

Greetings Lefred, Can I use the below steps: stop group replication systemctl stop mysqld yum update MySQL*.* --- note that I have the packages on the VM

Very well explained!

I felt frustrated when I watched your video. YOUR VIDEO TITLE IS WRONG (upside down).

In automatic failover, would there be data loss? Does it depend on sync/async replication configuration?

I have configured mysql innodb cluster. In my cluster I have 3 nodes for cluster and one app server where I install mysql router. When I disconnect one nodes from cluster it automatically switch another nodes but running transactions on node1 are being failed. I am controlling this using app server where I use mysql router. My router automatically switch from node1 to node2 when node1 disconnect. But there are some queries running on node1. Queries are failed when router automatically switch from node1 to node2 during node 1 shutdown. How can I recover this data loss ? my all running queries are failed during node switch in inno db cluster. Is there any solution to fix this data loss ?? Thank you so much

Super intéressant ! Merci 👍🏿

Thanks

Do you know wtf it was

Can I inject the SQL queries or read the results from the DB before passed to the App like in mysql proxy? If yes, how?

thanks for the video. i wonder if we have switch over and fail over in mysql replication similar to what we have in oracle or not. i mean switch to slave and the switch back to master without backup and restore from primary.

hello Fred ben alors tu parles plus ?? dommage. Super sinon la demo. merci

Error shows :. An open session is required to perform this operation (Run time error)

thank you for this

thx ! very good tuto

Thanks Sir .. Now its very easy

Your volume is to LOW !

Thanks for your useful post. Is 32GB RAM is ok for a dev environment ? Thanks

This help me understand how to this work this part of the proxysql. Very nice video, congratulations!