Mydbops
0 FOLLOWERS
Scaling database Operations. Mydbops delivers enterprise class support on MySQL and its forks. MySQL Performance, MySQL High Availability and 24*7 Monitoring for Databases.
Mydbops
3d ago
Struggling with slow databases as your data keeps growing? Regular databases can get overloaded when lots of users try to write information at once. This can make your application sluggish and risk losing data. But there's a solution! TiDB is a powerful database that can handle massive amounts of data. We will explain how TiDB's special write process keeps your data safe and fast, even as your application grows!
But that's not all! TiDB also offers powerful scheduling capabilities to automate tasks and optimize performance. To learn more about TiDB Scheduling, check out our dedicated blog post ..read more
Mydbops
1w ago
Worried about accidental data loss in your MariaDB database? MariaDB Flashback can be your hero! This powerful feature allows you to rewind your database to a specific point in time, saving you from the hassle of full backups and restores.
In this blog, we will see how to do a flashback recovery or rolling back the data in MariaDB, MySQL and Percona.
As we know the saying “All humans make mistakes”, following that in Database environment the data modified accidentally can bring havoc to any organisations.
Recover the lost data
The data can be recovered from the latest full backup or in ..read more
Mydbops
2w ago
Database performance tuning hinges on optimal index selection. However, this process is notoriously complex and time-consuming, even for seasoned database administrators. Even experienced experts struggle to identify the most effective indexing strategy for intricate workloads involving numerous tables (dozens or even hundreds) and countless SQL queries (thousands).
TiDB Index Advisor
TiDB Index Advisor is a command-line tool that can automatically recommend indexes based on the workload, statistics, and execution plan cost in TiDB, which can greatly reduce the workload of index maintenance in ..read more
Mydbops
3w ago
Thriving PostgreSQL Community at PGConf India 2024
The energy at PGConf India 2024 was truly infectious! As your trusted PostgreSQL management partner, Mydbops was thrilled to be at the heart of this vibrant event. The conference offered a fantastic platform for the PostgreSQL community in India to connect, share knowledge, and explore the latest advancements in the database world. From insightful presentations to engaging workshops, PGConf India 2024 proved to be a valuable learning experience for all attendees.
Mydbops @ PGConf India 2024Mydbops @ PGConf India 2024Mydbops @ PGConf India 2024 ..read more
Mydbops
3w ago
MySQL Group Replication offers high availability and data redundancy, but like any technology, it's essential to be prepared for unexpected events. In the dynamic world of database management, ensuring high availability and data integrity is paramount. In this blog, we'll explore the standard practices and procedures for recovering from complete failures in a Group Replication.
Recovery Methods
In MySQL Group Replication, recovery from complete failures involves two main methods: partial recovery and full recovery. Partial recovery involves reintegrating a single node after withdrawal fo ..read more
Mydbops
1M ago
PostGIS: A Spatial Database Extension for PostgreSQL
PostGIS stands as a spatial database extension tailored for PostgreSQL. This extension enhances PostgreSQL by introducing support for geographic objects, empowering the database to store, query, and analyze spatial data, encompassing points, lines, and polygons.
Key Features of PostGIS
Spatial Data Types: PostGIS introduces spatial data types (geometry and geography) for representing diverse shapes and geographical features.
Spatial Indexing: It equips PostgreSQL with spatial indexing for efficient queries, enabling faster retrieval of s ..read more
Mydbops
1M ago
The 15th Mydbops Opensource Database Meetup was not just an event; it was a convergence of minds, a celebration of innovation, and a testament to the boundless possibilities of database technology. As we reminisce about the enlightening moments of this remarkable gathering, let's delve deep into the insights shared by our esteemed speakers and explore why you shouldn't miss our next meetup.
Event Recap
Picture yourself back in time to Saturday, February 3rd, 2024, where the Bangalore International Centre in Bengaluru, Karnataka, served as the bustling hub for the 15th Mydbops Opensource Databa ..read more
Mydbops
1M ago
The introduction of support for incremental backup in pg_basebackup marks a significant advancement in PostgreSQL 17. This game-changing feature enhances data management and recovery capabilities by allowing users to efficiently back up only the changes made since the last backup, reducing both time and storage requirements.
As a heads up, pg_basebackup is a command line utility that allows taking base backup of a PostgreSQL server. A basebackup is a consistent snapshot of PostgreSQL server’s data directory.
Until PostgreSQL 16, pg_basebackup only supports full backup and to achieve incrementa ..read more
Mydbops
1M ago
In our exploration of MongoDB's advanced features, we previously delved into the diverse index types available within the database. However, MongoDB 4.4 introduces a compelling addition to this repertoire: the hidden index. This article serves as an in-depth guide to understanding the nuances of hidden indexes, exploring their utility, and mastering the techniques to seamlessly incorporate them into your MongoDB workflow.
Enhancing Query Performance with Indexes
Indexes are pivotal for efficient query performance in MongoDB. Before diving into hidden indexes, let's revisit the fundamental role ..read more
Mydbops
1M ago
Event Details
Date:Saturday, February 3rd, 2024
Time:10:00 AM - 1:00 PM
Location:Bangalore International Centre, 2nd Floor, 7, 4th Main Rd, Stage 2, Domlur, Bengaluru, Karnataka 560071 (View on Map)
The meetup promises an enriching experience, featuring an impressive lineup of speakers who will delve into various aspects of open-source databases.
Here's a sneak peek into what you can expect at this exciting event:
Speaker Lineup: Shivji Jha - Staff Engineer at Nutanix's Cloud Data Platforms
Topic: Navigating Transactions: ACID Complexity in Modern Databases
Explore modern datab ..read more