I use MySQL federation to let one MySQL database access another's data tables. This has worked fine for more than a year, but today (from out of the blue) a stored routine reported this MySQL error:
Error Code: 1429. Unable to connect to foreign data source: Too many connections
If I try to access the federated table with a
SELECT, I get
Error Code: 1030 Got error 1 from storage engine
Moving on to the MySQL server which hosts the data, I can actually
SELECT the desired data, so it seems to be working.
The server accessing the data is version 5.0.51a24 and the host server is 5.0.96-0. Old stuff, that is.
How do I solve the problem? Couldn't find much help in the MySQL documention.