LinkedIn
Twitter
Good day all
I am in the process of backfilling and streaming a large number of tables (>1000) using datastream.
When I click start stream it works for a few minutes and then I get the following error:
""(1129, "10.200.0.10' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'")""
I'd just like to know. Does datastream create a new MySQL connection for each table it backfills? And is this only for backfilling, or does it consume a connection for each table it streams as well?
These are my current Percona MySQL settings:
Any suggestions on the number I need to set here for this to work with 1000 tables?
