MySQL Forums
Forum List  »  Federated Storage Engine

Use Federated tables to spread very large database
Posted by: Richard Hillström
Date: October 09, 2006 01:24AM

Hi,

I have a database on a single server, it will store several terabytes in 100 tables in a not so distant future, I am considering looking into using federated tables to move data to other physical servers. The database cpu load will be no problem, but the size of the database will be, therefore I want to move them to other servers. Anyone tried this? Any better ideas?

OS is Linux 2.6 on x86 hardware with only internal disks, maybe a real SAN solution would be the right path instead?

Opinions?

BR
Richard

Options: ReplyQuote


Subject
Views
Written By
Posted
Use Federated tables to spread very large database
9062
October 09, 2006 01:24AM


Sorry, you can't reply to this topic. It has been closed.

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.