ShardMatrix
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,
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,