Java-Gaming.org    
Featured games (81)
games approved by the League of Dukes
Games in Showcase (487)
Games in Android Showcase (112)
games submitted by our members
Games in WIP (553)
games currently in development
News: Read the Java Gaming Resources, or peek at the official Java tutorials
 
    Home     Help   Search   Login   Register   
Pages: [1]
  ignore  |  Print  
  MySQL and large user database  (Read 245 times)
0 Members and 1 Guest are viewing this topic.
Offline unenergizer

Junior Member


Medals: 3
Exp: 1 year


Work hard, practice often, and you will succeed!


« Posted 2014-03-20 07:23:33 »

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

JGO is AMAZING!
Steam: unenergizer
Online trollwarrior1
« Reply #1 - Posted 2014-03-20 07:25:29 »

Stop worrying about problems that don't exist.
Offline unenergizer

Junior Member


Medals: 3
Exp: 1 year


Work hard, practice often, and you will succeed!


« Reply #2 - Posted 2014-03-20 07:32:53 »

Stop worrying about problems that don't exist.

Sure they exist.  If they didn't I don't think topics about database optimization would be created.  Grin

http://stackoverflow.com/questions/579244/mysql-database-optimization-best-practices

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

JGO is AMAZING!
Steam: unenergizer
Games published by our own members! Check 'em out!
Legends of Yore - The Casual Retro Roguelike
Offline Danny02
« Reply #3 - Posted 2014-03-20 07:36:50 »

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.
Offline unenergizer

Junior Member


Medals: 3
Exp: 1 year


Work hard, practice often, and you will succeed!


« Reply #4 - Posted 2014-03-20 07:46:14 »

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.

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.

JGO is AMAZING!
Steam: unenergizer
Online trollwarrior1
« Reply #5 - Posted 2014-03-20 07:50:59 »

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.
Offline unenergizer

Junior Member


Medals: 3
Exp: 1 year


Work hard, practice often, and you will succeed!


« Reply #6 - Posted 2014-03-20 07:57:22 »

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.

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

JGO is AMAZING!
Steam: unenergizer
Pages: [1]
  ignore  |  Print  
 
 

 

Add your game by posting it in the WIP section,
or publish it in Showcase.

The first screenshot will be displayed as a thumbnail.

TehJavaDev (17 views)
2014-08-28 18:26:30

CopyableCougar4 (26 views)
2014-08-22 19:31:30

atombrot (39 views)
2014-08-19 09:29:53

Tekkerue (36 views)
2014-08-16 06:45:27

Tekkerue (33 views)
2014-08-16 06:22:17

Tekkerue (22 views)
2014-08-16 06:20:21

Tekkerue (33 views)
2014-08-16 06:12:11

Rayexar (67 views)
2014-08-11 02:49:23

BurntPizza (45 views)
2014-08-09 21:09:32

BurntPizza (36 views)
2014-08-08 02:01:56
List of Learning Resources
by Longor1996
2014-08-16 10:40:00

List of Learning Resources
by SilverTiger
2014-08-05 19:33:27

Resources for WIP games
by CogWheelz
2014-08-01 16:20:17

Resources for WIP games
by CogWheelz
2014-08-01 16:19:50

List of Learning Resources
by SilverTiger
2014-07-31 16:29:50

List of Learning Resources
by SilverTiger
2014-07-31 16:26:06

List of Learning Resources
by SilverTiger
2014-07-31 11:54:12

HotSpot Options
by dleskov
2014-07-08 01:59:08
java-gaming.org is not responsible for the content posted by its members, including references to external websites, and other references that may or may not have a relation with our primarily gaming and game production oriented community. inquiries and complaints can be sent via email to the info‑account of the company managing the website of java‑gaming.org
Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2013, Simple Machines | Managed by Enhanced Four Valid XHTML 1.0! Valid CSS!