Sample Header Ad - 728x90

MySQL table with partitions on multiple remote servers (only partitions)

1 vote
1 answer
76 views
in PostgreSQL you can create a table with let's say 4 partitions (hash) and locate each partition on different servers (remote PostgreSQL servers) and it's called (Foreign Data Wrapper). Now in MySQL i heard there is a Federated engine which you can connect to a remote server with it but it just work for a table not its partitions. I know i can use NDB but i want to have multiple MySQL servers and manage data spread by my self (based on the table partitions). Is there any solution in MySQL to make a table (Innodb) and spread its partitions on multiple remote MySQL servers ?
Asked by user216085 (13 rep)
Nov 12, 2024, 07:56 AM
Last activity: Nov 12, 2024, 06:56 PM