MySQL and large user database

Newbie & Debugging Questions
#1

Hi JGO,

I am writing today because I have a question about mysql and java. I don’t need any code nor am I asking for some. However I do need some advice. What is the proper way to connect your software to a database for gaming. What is the best way to be able to keep up with requests from 1k - 30k+ clients making connections and updates all at once.

Since I am still new to programming (only 15 months learning experience) I am not able to create video games, which is my dream. So I have decided to get some practice in during my off times from school and work programming a Minecraft network. Now, I know this is not the place to be talking about this game. However I am posting because there are custom services that exist that have over 30k users online at one time. If I am going to develop a competing framework then I need to be prepared to handle all these connections. Because the service is going to need an array of servers then all the data needs to be hosted in a database (obviously). So this is where I am at. Does anyone have experience with doing mysql work on “large scare” operations?

Now, I know this might not come close to the competitor service, but it is still programming experience under the belt. If I am going to use my free time programming, then I might as well do it the best I can.

I appreciate all of your opinions.

-une

#2

Stop worrying about problems that don’t exist.

#3

Sure they exist. If they didn’t I don’t think topics about database optimization would be created. ;D

I am googling this information, but a lot of it is dating back to 2009. If someone has some information about best practices and optimization techniques for java 6 or 7 I would appreciate your links.

Thanks for your time!

-une

#4

The things is that you don’t have this problem. You don’t have 30k users atm and shouldn’t worry about this yet.
Back on topic, nowadays as a start up one would probably rent some cloud solution which can easily scale to any user base possible.

#5

Ah I see what you guys mean now. I apologize for the misunderstanding. I thought trollwarrior1 was saying that mysql doesn’t have optimization techniques. That being said, I am OCD when it comes to planning a project. I suppose in a way you guys are just telling me to wing it, and then come back to that code later if it becomes a problem? For some reason that sounds like extra work. Thinking about it now though, maybe it is faster to put a prototype of something together then just improve it? I appreciate your opinions and experience.

Thank you.

#6

That’s like getting kidnapped and told to write a full game and if the first time you run it you encounter a bug, you will be killed. What I mean is you can spend entire life trying to figure out if it will work and in the end it will still not work. You can only tell after actually running it.

#7

Hahahaha this made me literally laugh out loud. I do worry about problems that don’t exist. I never thought about that though until you guys pointed that out. This is brilliant advice. I spend loads of time planning and less time coding. I have started projects, coded them 90%, then decided, “I can do it better” then I start them over. This is my 5th restart on the projects code. However I can say it has improved each time.

Thank you for pointing this out to me. It makes a world of difference thinking about it now.

I should prolly hush up and get to coding!

Thank you guys for your awesome experience and wisdom (and a good laugh)!

-une