We are running Mysql on CentOS 5.5. And are using the database sharding approach. As it is an erp app, there are about 300 tables for each new Application/company. At the moment we have around 600 databases in our mysql server. (250 GB, 24 GB Ram) But the server crashes rather often. 1. Is there a known limit with mysql and the no of databases it can support reliably. i went through the other threads and blogs , but could not find any clear analysis of no. of databases vs mysql server crashes/availability.
On the other hand, i would also like advice from anyone who has done db admin for a complicated app like ERP. 2. Is it a reliable model? How would you change it to make it more reliable?