MySQL Forums
Forum List  »  General

MySQL table with partitions on remote servers (only paritions)
Posted by: Ali Saeidi
Date: November 12, 2024 01:41AM

Hello, in PostgreSQL you can create a table with let's say 4 paritions (hash)
and locate each parition on different servers (remote PostgreSQL servers) and it's called (Foregin 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 paritions. 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 paritions). Is there any solution in MySQL to make a table (Innodb) and spread its paritions on multiple remote MySQL servers ?

Options: ReplyQuote


Subject
Written By
Posted
MySQL table with partitions on remote servers (only paritions)
November 12, 2024 01:41AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.