MySQL Bugs: #12322: views in federated tables

Bug #12322	views in federated tables
Submitted:	2 Aug 2005 16:01	Modified:	21 Jul 2006 3:08
Reporter:	douglas anderson	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:		OS:
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
If federated tables could access a view (dynamic or generated table) on a remote server, a single SQL call could be distributed across multiple servers at one time thus distributing cpu and/or IO. Machines could be optimised for their particular tasks for greater cost/benefit ratios. 

How to repeat:
Current routing problems to complicated for single machine.

Federated tables that references views appear to work just fine in MySQL 5.1.