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

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,

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

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