ShardMatrix icon indicating copy to clipboard operation
ShardMatrix copied to clipboard

Can I perform data sharding according to the specified fields, add, delete, modify, and query data, and perform related operations on the associated table,

Open jasonccs opened this issue 2 years ago • 0 comments

Does Larravel have a plugin package with MySQL database sub databases and sub tables? My business data volume is very large, so I am considering it into databases and tables to handle queries on large data, in order to improve efficiency

If I have 4 tables in the same MySQL database and the table structure is the same, such as users01, users02, users03, users04,

public function up(): void
{
    Schema::create('users', function (Blueprint $table) {
        $table->id();
        $table->string('name');
        $table->string('email')->unique();
        $table->timestamp('email_verified_at')->nullable();
        $table->string('password');
        $table->rememberToken();
        $table->timestamps();
    });
}

Can I perform data sharding according to the specified fields, add, delete, modify, and query data, and perform related operations on the associated table,

jasonccs avatar Sep 22 '23 03:09 jasonccs