- 153
- 43 157
Mydbops
India
เข้าร่วมเมื่อ 27 ต.ค. 2015
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!
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!
Protect MongoDB from Linux OOM Killer (Out of Memory Issues) - Mydbops Podcast Episode 8
Read the blog: www.mydbops.com/blog/out-of-memory-issues-in-mongodb
Protect MongoDB from Linux OOM Killer - Mydbops Podcast Episode 8
In this episode, we dive deep into one of the most critical challenges facing MongoDB deployments on Linux: Out of Memory (OOM) situations. Discover how the Linux OOM Killer operates and the devastating impact it can have on your database performance. We’ll explore practical strategies to prevent MongoDB from being terminated during these critical moments, including system optimizations, query analysis, and memory management techniques.
🎧 Follow us on Spotify for more episodes: open.spotify.com/show/2nLafQs2QiAcz7ULKsy5KM?si=w8lLph7MRXC5j-pc1yDs3A
👉 Need professional database management? Contact Mydbops for expert MongoDB Managed and Consulting Services to ensure seamless performance and optimized database operations.
www.mydbops.com/
#mongodb #sequencenumber #DatabaseManagement #Mydbops #database #sql #troubleshooting #discspace #storage #Optimization #PerformanceTuning #Podcast #DBA #dbms #nosql #mongod #linux #oomkiller
Protect MongoDB from Linux OOM Killer - Mydbops Podcast Episode 8
In this episode, we dive deep into one of the most critical challenges facing MongoDB deployments on Linux: Out of Memory (OOM) situations. Discover how the Linux OOM Killer operates and the devastating impact it can have on your database performance. We’ll explore practical strategies to prevent MongoDB from being terminated during these critical moments, including system optimizations, query analysis, and memory management techniques.
🎧 Follow us on Spotify for more episodes: open.spotify.com/show/2nLafQs2QiAcz7ULKsy5KM?si=w8lLph7MRXC5j-pc1yDs3A
👉 Need professional database management? Contact Mydbops for expert MongoDB Managed and Consulting Services to ensure seamless performance and optimized database operations.
www.mydbops.com/
#mongodb #sequencenumber #DatabaseManagement #Mydbops #database #sql #troubleshooting #discspace #storage #Optimization #PerformanceTuning #Podcast #DBA #dbms #nosql #mongod #linux #oomkiller
มุมมอง: 19
วีดีโอ
Preventing MySQL Binary Log Sequence Number Exhaustion - Mydbops Podcast Episode 7
มุมมอง 142 ชั่วโมงที่ผ่านมา
Read the blog: www.mydbops.com/blog/preventing-mysql-binary-log-sequence-number-exhaustion Preventing MySQL Binary Log Sequence Number Exhaustion - Mydbops Podcast Episode 7 In this gripping episode, we tackle a hidden threat that could bring your MySQL database to its knees: sequence number exhaustion in binary logs. Did you know that reaching the maximum sequence number can lead to catastroph...
Mastering Vector Search with MongoDB Atlas - Manosh Malai - Mydbops MyWebinar 39
มุมมอง 12612 ชั่วโมงที่ผ่านมา
Mastering Vector Search with MongoDB Atlas - Manosh Malai - Mydbops MyWebinar 39 Premiere Date: Dec 27th, Friday Time: 3:30 PM - 4:15 PM IST Speaker: Manosh Malai, CTO, Mydbops Topic: Mastering Vector Search with MongoDB Atlas In this session, explore how to harness MongoDB's native vector search capabilities to enhance your database and search functionality. From the basics to advanced techniq...
Troubleshooting MySQL Binlog Purge Error 1372 (HY000) - Mydbops Podcast Episode 6
มุมมอง 6119 ชั่วโมงที่ผ่านมา
Read the blog here: www.mydbops.com/blog/resolving-mysql-binlog-errors-and-reclaiming-disk-space Ever faced the puzzling MySQL error "Target log not found in binlog index" while trying to purge binlogs to free up disk space? In this episode, we dive deep into a real-life incident where this issue emerged during a critical disk space reclamation attempt. Join us as we explore: * The root cause b...
Import data 10X faster with the power of TiDB Lightning - Mydbops Podcast
มุมมอง 45หลายเดือนก่อน
Read the blog: mydbops.com/blog/tidb-lightning-for-high-speed-data-import Discover the secrets to high-speed data imports with TiDB Lightning! In this podcast, we dive into tips, backend options, and expert advice to optimize your TiDB database performance. Tune in now! 🎧 Follow us on Spotify for more episodes: open.spotify.com/show/2nLafQs2QiAcz7ULKsy5KM?si=w8lLph7MRXC5j-pc1yDs3A #mydbops #tid...
Boost Your MySQL Replication Efficiency by 50% with Tagged GTID in MySQL 8.4
มุมมอง 155หลายเดือนก่อน
Read the blog here: www.mydbops.com/blog/simplifying-replication-with-tagged-gtid-in-mysql-8-4 In this episode, we explore the groundbreaking Tagged GTID feature in MySQL 8.4. Learn how this innovative capability allows you to streamline replication, ensure data consistency, and manage complex setups like InnoDB Clusters and Group Replication. We'll dive into practical use cases, implementation...
Migration Journey To TiDB - Kabilesh PR - Mydbops MyWebinar 38
มุมมอง 104หลายเดือนก่อน
Migration Journey To TiDB - Mydbops MyWebinar 38 Premiere Date: Nov 28th, Thursday Time: 11:00 AM Speaker: Kabilesh PR, Founding Partner, Mydbops Topic: Migration Journey To TiDB Webinar Overview: Join us for an informative session on the essential strategies and techniques for a successful migration journey to TiDB. This webinar will cover critical aspects of migration, including data migratio...
MongoDB Shutdown Best Practices: db.shutdownServer() vs systemctl stop | Replica Sets Guide
มุมมอง 110หลายเดือนก่อน
Read the blog: www.mydbops.com/blog/mongodb-shutdown-methods-db-shutdownserver-vs-systemctl-stop MongoDB Shutdown Best Practices: db.shutdownServer() vs systemctl stop | Replica Sets Guide Learn the best techniques for shutting down MongoDB nodes, including db.shutdownServer() and systemctl stop. Explore replica set-specific behaviors, the quiesce period in MongoDB 5.0 , and strategies to avoid...
Mastering PostgreSQL 17: pg_createsubscriber and Logical Replication Enhancements - Mydbops
มุมมอง 181หลายเดือนก่อน
Read the full blog here: www.mydbops.com/blog/postgresql-17-convert-streaming-replica-to-logical-replication-with-pg-createsubscriber Mastering PostgreSQL 17: pg_createsubscriber and Logical Replication Enhancements - Mydbops In this episode, explore PostgreSQL 17's game-changing features, including the powerful new pg_createsubscriber command. Learn how it streamlines logical replication setup...
Evolution of Histograms in MySQL 8.4 - Mydbops
มุมมอง 103หลายเดือนก่อน
Read the full blog: www.mydbops.com/blog/evolution-of-histograms-in-mysql-8-4 In this episode, we explore the evolution of histograms in MySQL and how MySQL 8.4 has transformed their management, making it more automated and adaptive. Histograms are vital for optimizing query performance by providing statistical insights into data distribution. Prior to MySQL 8.4, DBAs had to manually update his...
Mastering AWS Blue/Green Deployment for Databases - Mydbops MyWebinar 37
มุมมอง 2672 หลายเดือนก่อน
Mastering AWS Blue/Green Deployment for Databases - Mydbops MyWebinar 37 This is a premiere of the Mydbops MyWebinar 37 held on October 25th, Friday Time: 3:30 PM - 4:15 PM IST Speaker: Praveen GR, Mydbops Topic: Mastering AWS Blue/Green Deployment for Databases Webinar Overview: Join us for an informative session on Mastering AWS Blue/Green Deployment for Databases, presented by Praveen GR. Th...
Mydbops@CTOtalk Summit 2024
มุมมอง 2302 หลายเดือนก่อน
🎉 Mydbops at CTOtalk Summit 2024! 🎉 We are proud to have been a sponsor of the CTOtalk Summit 2024 at ITC Grand Chola today. It was a day filled with insightful discussions on database optimization, cloud migration, and the future of AI-powered database solutions. A huge thank you to CTOtalk for organizing such a stellar event! 🙌 A big shoutout to everyone who visited our stall. A special thank...
What's New in MySQL 8.4? Mydbops MyWebinar Edition 36 - Vinoth Kanna, Founding Partner, Mydbops
มุมมอง 4343 หลายเดือนก่อน
What's New in MySQL 8.4? Mydbops MyWebinar Edition 36 - Vinoth Kanna, Founding Partner, Mydbops Join us as we explore the latest advancements in MySQL 8.4 and discover how these updates can enhance your database management. 👤 Speaker: Vinoth Kanna Ramiya Sriram, Founding Partner, Mydbops 🎙️ Topic: What's New in MySQL 8.4? 🗓 Premiere Date: Tuesday, Oct 1 🕒 Time: 3:00 PM IST Key highlights: * GTI...
Scaling Connections in PostgreSQL | PGBLR Meetup-2 | Aakash M, Mydbops
มุมมอง 1633 หลายเดือนก่อน
Scaling Connections in PostgreSQL | PGBLR Meetup-2 | Aakash M, Mydbops
What's New in PostgreSQL 17 - Mydbops MyWebinar Edition 35
มุมมอง 6044 หลายเดือนก่อน
What's New in PostgreSQL 17 - Mydbops MyWebinar Edition 35
Mydbops Client Success: KloudMate Improves Client Satisfaction with Mydbops' Database Expertise
มุมมอง 1134 หลายเดือนก่อน
Mydbops Client Success: KloudMate Improves Client Satisfaction with Mydbops' Database Expertise
Zero Downtime upgrade with TiProxy - Kabilesh PR, Mydbops
มุมมอง 1714 หลายเดือนก่อน
Zero Downtime upgrade with TiProxy - Kabilesh PR, Mydbops
What's New in MongoDB 8.0 - Mydbops MyWebinar Edition 34
มุมมอง 2715 หลายเดือนก่อน
What's New in MongoDB 8.0 - Mydbops MyWebinar Edition 34
Scale Your Database Traffic with Read/Write Splitting Using MySQL Router Mydbops Opensource Meetup16
มุมมอง 1735 หลายเดือนก่อน
Scale Your Database Traffic with Read/Write Splitting Using MySQL Router Mydbops Opensource Meetup16
Exploring the Intersection of Distributed Databases & AI -TiDB-Mydbops Open Source Database Meetup16
มุมมอง 1045 หลายเดือนก่อน
Exploring the Intersection of Distributed Databases & AI -TiDB-Mydbops Open Source Database Meetup16
MySQL InnoDB Storage Engine Deep Dive: Mydbops OpenSource Database Meetup 16
มุมมอง 5546 หลายเดือนก่อน
MySQL InnoDB Storage Engine Deep Dive: Mydbops OpenSource Database Meetup 16
Demystifying Real-Time Analytics with TiDB - Mydbops MyWebinar Edition 33
มุมมอง 1256 หลายเดือนก่อน
Demystifying Real-Time Analytics with TiDB - Mydbops MyWebinar Edition 33
Must-Know PostgreSQL Extensions for Developers and DBAs During Migration | Mydbops Database Meetup16
มุมมอง 1586 หลายเดือนก่อน
Must-Know PostgreSQL Extensions for Developers and DBAs During Migration | Mydbops Database Meetup16
Scale your database traffic with Read/Write split using MySQL Router - Mydbops MyWebinar Edition 31
มุมมอง 4157 หลายเดือนก่อน
Scale your database traffic with Read/Write split using MySQL Router - Mydbops MyWebinar Edition 31
Efficient MySQL Indexing & What's New in MySQL Explain - Mydbops MyWebinar Edition 32
มุมมอง 3117 หลายเดือนก่อน
Efficient MySQL Indexing & What's New in MySQL Explain - Mydbops MyWebinar Edition 32
Mastering MongoDB Atlas: Essentials of Diagnostics and Debugging in the Cloud - Mydbops Meetup 15
มุมมอง 4049 หลายเดือนก่อน
Mastering MongoDB Atlas: Essentials of Diagnostics and Debugging in the Cloud - Mydbops Meetup 15
AWS RDS MySQL in 2023 - What's New? Vinoth Kanna @ Mydbops OpenSource Database Meetup 15
มุมมอง 28110 หลายเดือนก่อน
AWS RDS MySQL in 2023 - What's New? Vinoth Kanna @ Mydbops OpenSource Database Meetup 15
Navigating Transactions: ACID Complexity in Modern Databases- Mydbops Open Source Database Meetup 15
มุมมอง 10110 หลายเดือนก่อน
Navigating Transactions: ACID Complexity in Modern Databases- Mydbops Open Source Database Meetup 15
Mastering Data Organization:A Deep Dive into Partitioning in PostgreSQL Mydbops MyWebinar Edition 30
มุมมอง 280ปีที่แล้ว
Mastering Data Organization:A Deep Dive into Partitioning in PostgreSQL Mydbops MyWebinar Edition 30
Understanding MongoDB Queryable Encryption for ultimate security Mydbops MyWebinar Edition 29
มุมมอง 388ปีที่แล้ว
Understanding MongoDB Queryable Encryption for ultimate security Mydbops MyWebinar Edition 29
its good but not ACID, i prefer use LMDBX
great explanation
Thank you
Seems helpful when a dba is performing the deletes manually, where he issues an additional command at the beginning to set the tagged GTID. How do we inject tagged gtid on an existing application which is performing deletes? Should we make changes on the application level, or is there a way to specify this tag on database server level which tags all delete operations/ or deletes coming from a specific user or host with the tag ?
Thanks for your query. The git id can be injected as a session with the deletes. Sample Syntax: SET gtid_next='automatic:<tag_name>'; -- Execute the delete operation DELETE FROM <table_name> WHERE <condition>;
Insightful explanation sir... Thank you❤
Glad you found it helpful. Thanks for your comment.
is the router is only used for the cluster environment ? Or can we use this for the PXC as well?
MySQL router supports Source - replica (master - replica) and InnoDB Cluster topologies. PXC (Galera) is not supported by MySQL Router. ProxySQL will be good choice for PXC.
@@MydbopsThank you so much for response
Hi, why use this over Kubernetes which can do the same thing and more? perhaps im missing something? and there is proxmox
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 .
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. th-cam.com/video/Qect5zCtpw0/w-d-xo.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: th-cam.com/video/QtvK-apLBwQ/w-d-xo.html Subscribe Mydbops for more database tech videos..!!
Full webinar video link: th-cam.com/video/QtvK-apLBwQ/w-d-xo.html Subscribe Mydbops for more database tech videos..!!
Full webinar video link: th-cam.com/video/QtvK-apLBwQ/w-d-xo.html Subscribe Mydbops for more database tech videos..!!
Full webinar video link: th-cam.com/video/QtvK-apLBwQ/w-d-xo.html Subscribe Mydbops for more database tech videos..!!
Full webinar video link: th-cam.com/video/QtvK-apLBwQ/w-d-xo.html Subscribe Mydbops for more database tech videos..!!
Full webinar video link: th-cam.com/video/rwjHRLGZ7pg/w-d-xo.html Subscribe Mydbops for more database tech videos..!!
Register now: us06web.zoom.us/webinar/register/WN_yWLiahLnTGmTnySK6dWp4w#/registration
Full webinar video link: th-cam.com/video/rwjHRLGZ7pg/w-d-xo.html Subscribe Mydbops for more database tech videos..!!
Full webinar video link: th-cam.com/video/rwjHRLGZ7pg/w-d-xo.html Subscribe Mydbops for more database tech videos..!!
Full webinar video link: th-cam.com/video/rwjHRLGZ7pg/w-d-xo.html Subscribe Mydbops for more database tech videos..!!
Full webinar video link: th-cam.com/video/rwjHRLGZ7pg/w-d-xo.html Subscribe Mydbops for more database tech videos..!!
Full webinar video link: th-cam.com/video/rwjHRLGZ7pg/w-d-xo.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: th-cam.com/video/rwjHRLGZ7pg/w-d-xo.html Subscribe Mydbops for more database tech videos..!!
Full webinar video link: th-cam.com/video/rwjHRLGZ7pg/w-d-xo.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: th-cam.com/video/d9qfpt5MHlc/w-d-xo.html
TiDB Architecture Full video link: th-cam.com/video/d9qfpt5MHlc/w-d-xo.html
TiDB Architecture Full video link: th-cam.com/video/d9qfpt5MHlc/w-d-xo.html
👌👌👌
Watch Full video th-cam.com/video/H94LSKDxSoA/w-d-xo.html Reply
Watch Full Video : th-cam.com/video/98Q5JGR4wQU/w-d-xo.html