Mydbops

Mydbops

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!

Пікірлер

  • @Dilip-work-moode
    @Dilip-work-moode21 күн бұрын

    In my case I had take manual snapshots but still not showing upgrade option in Action button.

  • @KabileshP.R
    @KabileshP.R20 күн бұрын

    what is the mysql version here

  • @rajbiswas776
    @rajbiswas776Ай бұрын

    Appreciate the hardwork but the instructor needs to work on his English, super bad.

  • @accountfortesting6321
    @accountfortesting63212 ай бұрын

    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.R
    @KabileshP.RАй бұрын

    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

  • @techbhatt893
    @techbhatt8932 ай бұрын

    In my case, MySQL version is 5.7.44 How should I upgrade to version 8?

  • @KabileshP.R
    @KabileshP.R2 ай бұрын

    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.28
    @z.a.i.d.282 ай бұрын

    Switch to 1.5x for better expirience

  • @user-nk7un3de1o
    @user-nk7un3de1o4 ай бұрын

    it's not showing upgrade option into snapshot. how to do that

  • @KabileshP.R
    @KabileshP.R4 ай бұрын

    Hi Automated snapshot will not show that, I have explained in the video how to do for automated snapshots too

  • @dhanabalanrangasamy9462
    @dhanabalanrangasamy94624 ай бұрын

    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.R
    @KabileshP.R4 ай бұрын

    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.

  • @dhanabalanrangasamy9462
    @dhanabalanrangasamy94624 ай бұрын

    Inplace means clicking on console and changing the version?

  • @KabileshP.R
    @KabileshP.R4 ай бұрын

    yes @@dhanabalanrangasamy9462

  • @KabileshP.R
    @KabileshP.RАй бұрын

    @@dhanabalanrangasamy9462 yes

  • @SanthoshKumar-ue4mt
    @SanthoshKumar-ue4mt4 ай бұрын

    How does the rollback steps looks ? Just run the the alter query ALTER TABLE table_name ENCRYPTION='N' ?

  • @Mydbops
    @MydbopsАй бұрын

    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.

  • @kirangelli
    @kirangelli4 ай бұрын

    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.

  • @Mydbops
    @Mydbops4 ай бұрын

    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

  • @user-zm3hl6ex7f
    @user-zm3hl6ex7f4 ай бұрын

    nice

  • @Mydbops
    @Mydbops4 ай бұрын

    Thanks for your comment.

  • @dharmanandamohanta2872
    @dharmanandamohanta28726 ай бұрын

    Can we apply the encryption on Window hosted DB ?

  • @Mydbops
    @Mydbops6 ай бұрын

    Thanks for your question. Yeah they are independent of the operating system. They can be done on Windows too.

  • @lusinetalawally7611
    @lusinetalawally76116 ай бұрын

    Great video! Very informative and resourceful.

  • @Mydbops
    @Mydbops6 ай бұрын

    Thanks for the positive feedback! We are glad that you found the video informative.

  • @gulsaar
    @gulsaar7 ай бұрын

    It really helps a lot. Thanks for the walkthrough.

  • @Mydbops
    @Mydbops7 ай бұрын

    You're welcome! 👍

  • @damairevanth4090
    @damairevanth40907 ай бұрын

    Why are you reading

  • @Mydbops
    @Mydbops7 ай бұрын

    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_tamil
    @gb_creation_tamil8 ай бұрын

    Interesting to know, thanks for explaining it

  • @Mydbops
    @Mydbops7 ай бұрын

    Thanks for your support

  • @krishnakumark260
    @krishnakumark2608 ай бұрын

    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.

  • @Mydbops
    @Mydbops8 ай бұрын

    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-se4yu
    @KaranSingh-se4yu9 ай бұрын

    Very well spoken with lots of confidence,thorough knowledge of subject making it so impressive. Weldone Bhanu Jamwal and keep it up.

  • @ferdine448
    @ferdine4489 ай бұрын

    Thank you

  • @Mydbops
    @Mydbops9 ай бұрын

    Welcome @ferdine448

  • @lokeshsinghallife
    @lokeshsinghallife10 ай бұрын

    Nice session

  • @Mydbops
    @Mydbops10 ай бұрын

    Thank you 👍

  • @gerardo.ortega
    @gerardo.ortega11 ай бұрын

    Fix the audio before uploading videos, pls

  • @Mydbops
    @Mydbops10 ай бұрын

    Thank you for your feedback! We'll make sure to improve the audio quality in our future videos

  • @Mydbops
    @Mydbops11 ай бұрын

    Full webinar video link: kzread.info/dash/bejne/g6iqrY-aoK-op7Q.html Subscribe Mydbops for more database tech videos..!!

  • @Mydbops
    @Mydbops11 ай бұрын

    Full webinar video link: kzread.info/dash/bejne/g6iqrY-aoK-op7Q.html Subscribe Mydbops for more database tech videos..!!

  • @Mydbops
    @Mydbops11 ай бұрын

    Full webinar video link: kzread.info/dash/bejne/g6iqrY-aoK-op7Q.html Subscribe Mydbops for more database tech videos..!!

  • @Mydbops
    @Mydbops11 ай бұрын

    Full webinar video link: kzread.info/dash/bejne/g6iqrY-aoK-op7Q.html Subscribe Mydbops for more database tech videos..!!

  • @Mydbops
    @Mydbops11 ай бұрын

    Full webinar video link: kzread.info/dash/bejne/g6iqrY-aoK-op7Q.html Subscribe Mydbops for more database tech videos..!!

  • @Mydbops
    @Mydbops Жыл бұрын

    Full webinar video link: kzread.info/dash/bejne/pKueqrSFd72doMo.html Subscribe Mydbops for more database tech videos..!!

  • @Mydbops
    @Mydbops Жыл бұрын

    Register now: us06web.zoom.us/webinar/register/WN_yWLiahLnTGmTnySK6dWp4w#/registration

  • @Mydbops
    @Mydbops Жыл бұрын

    Full webinar video link: kzread.info/dash/bejne/pKueqrSFd72doMo.html Subscribe Mydbops for more database tech videos..!!

  • @Mydbops
    @Mydbops Жыл бұрын

    Full webinar video link: kzread.info/dash/bejne/pKueqrSFd72doMo.html Subscribe Mydbops for more database tech videos..!!

  • @Mydbops
    @Mydbops Жыл бұрын

    Full webinar video link: kzread.info/dash/bejne/pKueqrSFd72doMo.html Subscribe Mydbops for more database tech videos..!!

  • @Mydbops
    @Mydbops Жыл бұрын

    Full webinar video link: kzread.info/dash/bejne/pKueqrSFd72doMo.html Subscribe Mydbops for more database tech videos..!!

  • @Mydbops
    @Mydbops Жыл бұрын

    Full webinar video link: kzread.info/dash/bejne/pKueqrSFd72doMo.html Subscribe Mydbops for more database tech videos..!!

  • @user-cd1vg8le7f
    @user-cd1vg8le7f Жыл бұрын

    Thank you... Please keep up these series .. helpful

  • @Mydbops
    @Mydbops Жыл бұрын

    Thanks.. More to come!

  • @ManuelTransfeld
    @ManuelTransfeld Жыл бұрын

    If you aim to produce good content, please try again.

  • @Mydbops
    @Mydbops Жыл бұрын

    @manuel Thank you for your feedback. We aim to produce better content, will exceed your expectations in upcoming days 👍

  • @Mydbops
    @Mydbops Жыл бұрын

    Full webinar video link: kzread.info/dash/bejne/pKueqrSFd72doMo.html Subscribe Mydbops for more database tech videos..!!

  • @Mydbops
    @Mydbops Жыл бұрын

    Full webinar video link: kzread.info/dash/bejne/pKueqrSFd72doMo.html

  • @miriamfigueroa5510
    @miriamfigueroa5510 Жыл бұрын

    Great explanation. Can you include how to move the keys to other server?

  • @Mydbops
    @Mydbops Жыл бұрын

    Sure we will make a blog/a video on it.

  • @Mydbops
    @Mydbops Жыл бұрын

    TiDB Architecture Full video link: kzread.info/dash/bejne/lm2lyNKtZbCunMY.html

  • @Mydbops
    @Mydbops Жыл бұрын

    TiDB Architecture Full video link: kzread.info/dash/bejne/lm2lyNKtZbCunMY.html

  • @Mydbops
    @Mydbops Жыл бұрын

    TiDB Architecture Full video link: kzread.info/dash/bejne/lm2lyNKtZbCunMY.html

  • @m3informativeworld208
    @m3informativeworld208 Жыл бұрын

    👌👌👌

  • @Mydbops
    @Mydbops Жыл бұрын

    Watch Full video kzread.info/dash/bejne/em1orrWEdNu5n6Q.html Reply

  • @Mydbops
    @Mydbops Жыл бұрын

    Watch Full Video : kzread.info/dash/bejne/a2yFl6yAgpfdgbg.html

  • @Mydbops
    @Mydbops Жыл бұрын

    Watch Full video : kzread.info/dash/bejne/aZ11ttywoc-7qM4.html

  • @Mydbops
    @Mydbops Жыл бұрын

    Watch Full video kzread.info/dash/bejne/em1orrWEdNu5n6Q.html

  • @Mydbops
    @Mydbops Жыл бұрын

    Subcribe NOW👇 kzread.info/dron/ATGZiJAceNoRTtZsEbwIyQ.html

  • @Mydbops
    @Mydbops Жыл бұрын

    subscribe NOW 👇 kzread.info/dron/ATGZiJAceNoRTtZsEbwIyQ.html

  • @RiyaSharma-et8xl
    @RiyaSharma-et8xl Жыл бұрын

    Good session

  • @Mydbops
    @Mydbops Жыл бұрын

    Thank you Riya Sharma.

  • @Govinda260
    @Govinda2602 жыл бұрын

    Keep going