Posted this before, but beware: federated tables do NOT use indices. Every
select is a full table scan, and if you're talking about a logging table
that could become very expensive very fast.
On Wed, Dec 9, 2009 at 4:13 PM, Neil Aggarwal <neil@stripped>wrote:
> > Is this possible to do? To make a connection, inside the
> > stored procedure
> > to a completely different machine and access the mysql there?
> The only way I know to access tables from different servers
> from a single connection is federated tables:
> Once you do that, you are accessing it like a local table.
> I hope this helps.
> Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net
> Host your MySQL database on a CentOS VPS for $25/mo
> Unmetered bandwidth = no overage charges, 7 day free trial
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1