Modern applications generate a tidal wave of data. But what happens to all that information as it accumulates? Just like a cluttered attic, a database overflowing with old data can lead to sluggish performance and wasted storage costs. As data grows, it becomes increasingly important to manage the lifetime of data to maintain system performance and reduce costs. TiDB, a distributed SQL database, offers a powerful feature called TTL (Time to Live) to automate the data lifetime at row level. In this blog post, we'll explore how you can leverage TiDB's TTL feature to efficiently manage your data ..read more

Mark your calendars, database enthusiasts! The Mydbops Open Source Database Meetup 16 is happening on June 8th, 2024, and we're seeking passionate experts like YOU to share your insights with the community. This is your chance to: Showcase your expertise: Do you have in-depth knowledge of a particular open-source database technology? This is the perfect platform to present your research, experiences, and best practices to a dedicated audience. Network with like-minded individuals: Connect with fellow open-source database enthusiasts, share ideas, and build lasting connections within the co ..read more

TiDB, the distributed SQL database, is renowned for its horizontal scalability, strong consistency, and compatibility with MySQL. One of the standout features that enhance its performance and flexibility is the Smart Engine Selection. This feature intelligently chooses the most suitable storage engine for different types of workloads, optimizing both transactional and analytical queries. Additionally, TiDB offers functionalities like automatic indexing to further streamline database management. This blog dives into TiDB's innovative Smart Engine Selection feature, a game-changer for simplifyin ..read more

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

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

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

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

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

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

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