Sharding Made Easy with MginDB in 5 Minutes

John JustGo — Tue, 21 May 2024 14:23:20 +0000

Hello, developers!

Sharding can be a complex task, but with MginDB, it's a breeze. Today, I'll show you how to set up sharding with MginDB in just a few minutes. Whether you're scaling up or down, MginDB handles the heavy lifting for you and manages it automatically.

Let’s get started!

Install MginDB

Install MginDB on your master server and on all your shards:
mgindb.com/documentation.html

Sharding

Sharding is a database architecture pattern that partitions data across multiple servers, enhancing the system's scalability and performance. MginDB will take care of everything automatically when you add or remove a shard and will redistribute the data without having to transfer any data manually nor changing the sharding scheme and keys.

Setting Up Sharding:

Configure Sharding Type: Open config.json for all your servers and set SHARDING_TYPE to MASTER for your main server and SHARDING_TYPE to SLAVE for all your shard servers. Or use the CLI command:

   CONFIG SET SHARDING_TYPE MASTER
   CONFIG SET SHARDING_TYPE SLAVE

Adding a Shard: To add a new server to the shard list, use the following command:

   CONFIG SET SHARDS ADD serverip/domain

This command registers serverip/domain as a new shard where data can be distributed.

Removing a Shard: To remove an existing server from the shard list, use the command:

   CONFIG SET SHARDS DEL serverip/domain

This removes serverip/domain from the list of shards, redistributing any data it held to remaining shards.

Activating Sharding: To activate sharding and start distributing data across the configured shards, execute:

   CONFIG SET SHARDING 1

Ensure you add the necessary shards before activating sharding to distribute data evenly.

Deactivating Sharding: To deactivate sharding and consolidate all data back to the master server, use:

   CONFIG SET SHARDING 0

This command centralizes the data, ceasing its distribution among shards.

Additional Sharding Commands:

Backup and Rollback: Data is always backed up before resharding. If an error occurs, it rolls back to the last backup, ensuring data integrity.
Sharding Batch Size: Set the size of commands sent to shards per batch (default: 100):

  CONFIG SET SHARDING_BATCH_SIZE value

Each of these commands needs to be executed on each server where MginDB is installed, either using the Web CLI (client.html) or Server CLI (mgindb client).

These settings play a crucial role in managing the distribution of data and the operational scale of your system, allowing for flexibility in handling workload and data management strategies.

Feel free to reach out with any questions or feedback. We're excited to see what you'll build with MginDB!

Link: mgindb.com

Documentation: mgindb.com/documentation.html

Happy coding!

MginDB: In-Memory, Schema-less, and Limitless

John JustGo — Tue, 21 May 2024 04:15:20 +0000

Hello, Developers!

Redis and SQL are amazing, but what if you need the best of both all in one?

If you like the speed of Redis and the power of SQL, you're going to love MginDB. It’s a hybrid in-memory database system that combines the agility of NoSQL systems with the robustness of traditional databases. Let’s dive into what makes MginDB a game-changer for your development stack.

What is MginDB?

MginDB is designed for developers who need rapid data access and flexible management. Whether you're building web, mobile, or IoT applications, MginDB’s in-memory storage mechanisms minimize access times and maximize throughput, making your data operations lightning-fast.

Schema Flexibility

One of the things you'll appreciate about MginDB is its support for schema-less data storage. This flexibility allows you to manage your data the way you want, without being constrained by rigid schemas. You get to decide how your data should be structured, using relational indices to keep things organized.

Advanced Querying

MginDB’s powerful querying functions are built to handle complex relational data efficiently. Whether you're doing simple lookups or running intricate analytical queries, MginDB has you covered. This makes exploring and analyzing your data not just possible, but straightforward and efficient.

Scalability & Sharding

As developers, we know the importance of scalability. MginDB is designed with horizontal scalability in mind, supporting sharding to meet growing demands and volumes. As your application grows, MginDB grows with it, allowing you to scale your data operations seamlessly.

Real-time Updates

For those of us who need real-time data capabilities, MginDB’s WebSocket connections ensure that you receive data updates instantly. This is backed by a robust publish/subscribe mechanism, keeping your data synchronized across your applications.

Usage

Integrating MginDB into your development stack can transform your data handling capabilities. From simple CRUD operations to complex transactions and real-time updates, MginDB’s comprehensive toolset supports it all. Ensuring data integrity and consistency, even in distributed environments, makes MginDB a reliable choice for modern applications.

CLI / GUI

MginDB offers a user-friendly web interface that simplifies executing complex queries and accessing real-time data insights. Monitor and manage your in-memory databases, analyze and update data, execute deep queries, and scale instantly. You can write, test, and validate your queries before deploying them, ensuring smooth and efficient data operations.

Ready to Get Started?

Explore MginDB and take your data operations to the next level. For more details, visit our documentation and get started today.