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
Last activity: Nov 12, 2024, 06:56 PM