Skip to content

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

@jasonccs

Description

@jasonccs

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,

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions