Welcome to Mydbops Managed Services! Since 2015, we have been optimizing database performance and simplifying management. With expertise in top open-source databases like MySQL, MariaDB, MongoDB, and PostgreSQL, we provide comprehensive assistance, support, consulting, and 24/7 operation services both on premises and in the cloud.
Our mission is to help organizations enhance the performance, scalability, efficiency, and uptime of their databases. Our team of expert DBAs and database engineers identify potential bottlenecks, design flaws, and architectural issues, implementing best practices to ensure optimal database functionality.
On this channel, you'll find valuable insights, tutorials, tips, and best practices to empower you with the knowledge to improve your database environments.
Subscribe now to stay updated with our latest videos and gain a competitive edge in the world of database management!
Пікірлер
In my case I had take manual snapshots but still not showing upgrade option in Action button.
what is the mysql version here
Appreciate the hardwork but the instructor needs to work on his English, super bad.
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?
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
In my case, MySQL version is 5.7.44 How should I upgrade to version 8?
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
Switch to 1.5x for better expirience
it's not showing upgrade option into snapshot. how to do that
Hi Automated snapshot will not show that, I have explained in the video how to do for automated snapshots too
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
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.
Inplace means clicking on console and changing the version?
yes @@dhanabalanrangasamy9462
@@dhanabalanrangasamy9462 yes
How does the rollback steps looks ? Just run the the alter query ALTER TABLE table_name ENCRYPTION='N' ?
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.
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.
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. kzread.info/dash/bejne/g5mX1pezc9fWp5M.htmlfeature=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
nice
Thanks for your comment.
Can we apply the encryption on Window hosted DB ?
Thanks for your question. Yeah they are independent of the operating system. They can be done on Windows too.
Great video! Very informative and resourceful.
Thanks for the positive feedback! We are glad that you found the video informative.
It really helps a lot. Thanks for the walkthrough.
You're welcome! 👍
Why are you reading
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.
Interesting to know, thanks for explaining it
Thanks for your support
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.
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,
Very well spoken with lots of confidence,thorough knowledge of subject making it so impressive. Weldone Bhanu Jamwal and keep it up.
Thank you
Welcome @ferdine448
Nice session
Thank you 👍
Fix the audio before uploading videos, pls
Thank you for your feedback! We'll make sure to improve the audio quality in our future videos
Full webinar video link: kzread.info/dash/bejne/g6iqrY-aoK-op7Q.html Subscribe Mydbops for more database tech videos..!!
Full webinar video link: kzread.info/dash/bejne/g6iqrY-aoK-op7Q.html Subscribe Mydbops for more database tech videos..!!
Full webinar video link: kzread.info/dash/bejne/g6iqrY-aoK-op7Q.html Subscribe Mydbops for more database tech videos..!!
Full webinar video link: kzread.info/dash/bejne/g6iqrY-aoK-op7Q.html Subscribe Mydbops for more database tech videos..!!
Full webinar video link: kzread.info/dash/bejne/g6iqrY-aoK-op7Q.html Subscribe Mydbops for more database tech videos..!!
Full webinar video link: kzread.info/dash/bejne/pKueqrSFd72doMo.html Subscribe Mydbops for more database tech videos..!!
Register now: us06web.zoom.us/webinar/register/WN_yWLiahLnTGmTnySK6dWp4w#/registration
Full webinar video link: kzread.info/dash/bejne/pKueqrSFd72doMo.html Subscribe Mydbops for more database tech videos..!!
Full webinar video link: kzread.info/dash/bejne/pKueqrSFd72doMo.html Subscribe Mydbops for more database tech videos..!!
Full webinar video link: kzread.info/dash/bejne/pKueqrSFd72doMo.html Subscribe Mydbops for more database tech videos..!!
Full webinar video link: kzread.info/dash/bejne/pKueqrSFd72doMo.html Subscribe Mydbops for more database tech videos..!!
Full webinar video link: kzread.info/dash/bejne/pKueqrSFd72doMo.html Subscribe Mydbops for more database tech videos..!!
Thank you... Please keep up these series .. helpful
Thanks.. More to come!
If you aim to produce good content, please try again.
@manuel Thank you for your feedback. We aim to produce better content, will exceed your expectations in upcoming days 👍
Full webinar video link: kzread.info/dash/bejne/pKueqrSFd72doMo.html Subscribe Mydbops for more database tech videos..!!
Full webinar video link: kzread.info/dash/bejne/pKueqrSFd72doMo.html
Great explanation. Can you include how to move the keys to other server?
Sure we will make a blog/a video on it.
TiDB Architecture Full video link: kzread.info/dash/bejne/lm2lyNKtZbCunMY.html
TiDB Architecture Full video link: kzread.info/dash/bejne/lm2lyNKtZbCunMY.html
TiDB Architecture Full video link: kzread.info/dash/bejne/lm2lyNKtZbCunMY.html
👌👌👌
Watch Full video kzread.info/dash/bejne/em1orrWEdNu5n6Q.html Reply
Watch Full Video : kzread.info/dash/bejne/a2yFl6yAgpfdgbg.html
Watch Full video : kzread.info/dash/bejne/aZ11ttywoc-7qM4.html
Watch Full video kzread.info/dash/bejne/em1orrWEdNu5n6Q.html
Subcribe NOW👇 kzread.info/dron/ATGZiJAceNoRTtZsEbwIyQ.html
subscribe NOW 👇 kzread.info/dron/ATGZiJAceNoRTtZsEbwIyQ.html
Good session
Thank you Riya Sharma.
Keep going