Recently I was discussing with some colleagues the possibility of consolidating some MySQL servers. While the servers are not heavily loading (averaging less than 1,000 queries a second) they are pretty large in terms of storage requirements. Each server has roughly 200 databases on each with approximatley 50 tables. Thats 10,000 tables per server. Each server contains up to 1 terabyte of data so if you consolidated servers at a 10:1 ratio you would have 10 terabytes of data, 2,000 databases and 100,000 tables with 10,000 queries per second average load.
Alright, that's a lot. And without testing I don't know if it would work. It probably wouldn't. But it might. And if it did, it would save the company a significant amount of money. But, while discussing this, someone brought up that open files limit might be a problem. Open files limit is the maximum number of files the …[Read more]