Hi, why use this over Kubernetes which can do the same thing and more? perhaps im missing something? and there is proxmox
@KabileshP.R5 күн бұрын
hi Thank you for reaching us, This content is basically on the capabilities of Tiproxy balancer built for TiDB database , which helps in preserving your existing connected connections to the database in the event of an upgrade or unintended failures to the other available nodes achieving zero downtime Am not sure if kubernetes has this ability of database connection preservation and rerouting .
@Dilip-work-moode2 ай бұрын
In my case I had take manual snapshots but still not showing upgrade option in Action button.
@KabileshP.R2 ай бұрын
what is the mysql version here
@rajbiswas7763 ай бұрын
Appreciate the hardwork but the instructor needs to work on his English, super bad.
@accountfortesting63213 ай бұрын
can you suggest if we upgrade the snapshot then any downtime or issue in existing current running instance in production and will it be upgrade the character set and collation as well?
@KabileshP.R3 ай бұрын
if we upgrade the snapshot it wont have downtime for the running prod instance, since you are upgrading the backup snapshot. The collation for the table will not be changed, the backup upgrade will check the compatibility and then proceed for the upgrade
@techbhatt8934 ай бұрын
In my case, MySQL version is 5.7.44 How should I upgrade to version 8?
@KabileshP.R3 ай бұрын
1,if you have automated backups, you can follow the steps mentioned in the video to upgrade the backup to 8 and restore it 2, you can also try the inplace upgrade feature with RDS to make the upgrade to 8
@z.a.i.d.284 ай бұрын
Switch to 1.5x for better expirience
@user-nk7un3de1o5 ай бұрын
it's not showing upgrade option into snapshot. how to do that
@KabileshP.R5 ай бұрын
Hi Automated snapshot will not show that, I have explained in the video how to do for automated snapshots too
@dhanabalanrangasamy94625 ай бұрын
what is the best way to upgrade aws RDS mysql 5.7 to 8.. Is it through snapshot way which you described or directly clicking on upgrade
@KabileshP.R5 ай бұрын
Major version upgrade has to be tested with various aspects such as compatibility, performance etc Snapshots are point in backup, you can upgrade and restore them as a separate instance, The incremental sync has to be managed manually in this method. RDS also supports inlace upgrade for mysql 5.7 to mysql 8.
@dhanabalanrangasamy94625 ай бұрын
Inplace means clicking on console and changing the version?
@KabileshP.R5 ай бұрын
yes @@dhanabalanrangasamy9462
@KabileshP.R3 ай бұрын
@@dhanabalanrangasamy9462 yes
@SanthoshKumar-ue4mt6 ай бұрын
How does the rollback steps looks ? Just run the the alter query ALTER TABLE table_name ENCRYPTION='N' ?
@Mydbops2 ай бұрын
Yes you are correct for disabling the encryption of the table can be done by ALTER TABLE your_table_name ENCRYPTION='N'; . But for disabling the default encryption globally you have to change the parameter default_table_encryption to OFF if you are having MySQL version 8.0.16 or later.
@kirangelli6 ай бұрын
Thank you for this Informative session on MongoDB Atlas. Couple of questions... How will the Atlas know the slow running queries? Will the Profiling be enabled by default in Atlas? Also, in PMM-QAN we can't get the execution plan for the queries that use aggregation pipeline (limitation of PMM) In Atlas, is there a option to get the execution plans for the slow queries? Only 48 hours data retention is a limitation here.
@Mydbops6 ай бұрын
Thrilled to know that you have enjoyed our database contents. Here is the reply from MongoDB Expert Manosh Malai. How will the Atlas know the slow-running queries? MongoDB Atlas detects slow-running queries using MongoDB's database profiler, which tracks queries exceeding a specific execution time threshold, typically set to 100 milliseconds by default. Will the Profiling be enabled by default in Atlas? Yes, For M0, M2, and M5 clusters and serverless instances, Atlas disables the Atlas-managed slow query operation threshold by default and you can't enable it. Also, in PMM-QAN we can't get the execution plan for the queries that use aggregation pipeline (limitation of PMM) In Atlas, is there an option to get the execution plans for the slow queries? By default, MongoDB Atlas will share the execution plans for the slow query. How far can we check the metrics? The snapshots on metrics retention were made pictorially on the recording. kzbin.info/www/bejne/h5bGpWiweNmjrZIfeature=shared&t=1967 Is there an option to store the data for the past 1 month? We can Integrate with Prometheus to store the metrics longer time www.mongodb.com/docs/atlas/tutorial/prometheus-integration/#:~:text=Prometheus%20collects%20metrics%20from%20configured,deployment%20to%20your%20Prometheus%20instance
@user-zm3hl6ex7f6 ай бұрын
nice
@Mydbops6 ай бұрын
Thanks for your comment.
@dharmanandamohanta28727 ай бұрын
Can we apply the encryption on Window hosted DB ?
@Mydbops7 ай бұрын
Thanks for your question. Yeah they are independent of the operating system. They can be done on Windows too.
@lusinetalawally76118 ай бұрын
Great video! Very informative and resourceful.
@Mydbops8 ай бұрын
Thanks for the positive feedback! We are glad that you found the video informative.
@gulsaar8 ай бұрын
It really helps a lot. Thanks for the walkthrough.
@Mydbops8 ай бұрын
You're welcome! 👍
@damairevanth40909 ай бұрын
Why are you reading
@Mydbops9 ай бұрын
Thanks for your feedback! Our webinars feature live presentations for accurate and engaging content. Feel free to share any suggestions or questions for an enhanced experience.
@gb_creation_tamil9 ай бұрын
Interesting to know, thanks for explaining it
@Mydbops9 ай бұрын
Thanks for your support
@krishnakumark26010 ай бұрын
Great session! The content is informative and well-structured, Looking forward to more content like this that can help us stay updated and improve our database management skills. Thanks for sharing @Bhuvanesh.
@Mydbops10 ай бұрын
We will definitely be creating more content to help you stay updated and enhance your database management skills. Thanks for watching and sharing your thoughts,
@KaranSingh-se4yu10 ай бұрын
Very well spoken with lots of confidence,thorough knowledge of subject making it so impressive. Weldone Bhanu Jamwal and keep it up.
@ferdine44811 ай бұрын
Thank you
@Mydbops11 ай бұрын
Welcome @ferdine448
@lokeshsinghallife11 ай бұрын
Nice session
@Mydbops11 ай бұрын
Thank you 👍
@gerardo.ortega Жыл бұрын
Fix the audio before uploading videos, pls
@Mydbops Жыл бұрын
Thank you for your feedback! We'll make sure to improve the audio quality in our future videos
@Mydbops Жыл бұрын
Full webinar video link: kzbin.info/www/bejne/h6XZfGCXpbF1rbM Subscribe Mydbops for more database tech videos..!!
@Mydbops Жыл бұрын
Full webinar video link: kzbin.info/www/bejne/h6XZfGCXpbF1rbM Subscribe Mydbops for more database tech videos..!!
@Mydbops Жыл бұрын
Full webinar video link: kzbin.info/www/bejne/h6XZfGCXpbF1rbM Subscribe Mydbops for more database tech videos..!!
@Mydbops Жыл бұрын
Full webinar video link: kzbin.info/www/bejne/h6XZfGCXpbF1rbM Subscribe Mydbops for more database tech videos..!!
@Mydbops Жыл бұрын
Full webinar video link: kzbin.info/www/bejne/h6XZfGCXpbF1rbM Subscribe Mydbops for more database tech videos..!!
@Mydbops Жыл бұрын
Full webinar video link: kzbin.info/www/bejne/qKjNeYWCfL9qpsk Subscribe Mydbops for more database tech videos..!!