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 <n...@jammconsulting.com>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: > http://dev.mysql.com/doc/refman/5.0/en/federated-use.html > > Once you do that, you are accessing it like a local table. > > I hope this helps. > > Neil > > -- > 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=vegiv...@tuxera.be > >
