Ok, really don't know how to ask what I am looking to find out which is likely why my reading and research otherwise is yielding nothing relative per say. So what I currently have is a single MySQL database, and I know sooner or later the data is going to pile up and I will run out of room on this server. So before that happens I want to get stuff in line so I can have the database spread across multiple machines one for load balancing and two pure storage factor.
So my question is, how does that work? Maybe I am thinking too 1 Dimensional here but I can't figure out how that would work, is it one DB that spills over onto the next machine and the next as the data grows or is it individual DB's with the same schema's for each, either way I just can't picture in my head let alone get into a logic for future proofing whats being worked on currently. As we don't want to hit the wall and pull an all stop in the event when the data is just to much for one machine.
So what do I have to read, research, methods, practices, etc to get myself on the right track with this?