mysql - Create a web application for a large in php myadmin for a large firm -

mysql - Create a web application for a large in php myadmin for a large firm -

i planning create php myadmin inventory scheme big firm (at to the lowest degree 1000 branches)

there centralized server , database kept in 1 place. branches can insert , retrieve info centralized server. there @ to the lowest degree 2000 sales bill , 100 purchase bills (at to the lowest degree 1 gb info branch)

my uncertainty is technical feasible me utilize php , mysql (apache) project? info vast? need alter front end end jsp , end other database? dont know much php , mysql database....? 1 went through scenario help me.

i suspect question not remain open long, way generic, worth: yes, feasible, did similar project before.

you have careful data schema structure, , need tune mysql server quite bit, true database.

you might want employ local servers , replication central server.

your reporting server should separate, since workload should not impact main info performance.

these thoughts come mind.

php mysql apache tomcat project