We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

synchronizing Database operations

Medium Priority
563 Views
Last Modified: 2013-11-13
Hi,

I have developed the web application using struts 2.0 as front end and mysql as back end.

many users accessing web site , so i want to synchronize the database operations either in mysql or sending the queries synchronously to mysql db in java.

How can i achieve this functionality???

Thanks,
Ajay
Comment
Watch Question

Top Expert 2012

Commented:
Don't quite understand your question.  You said your application already uses mysql as back end.  To me that means you're already able to save, edit, delete and read from the database.  What other operations do you want "synchronized"?

Author

Commented:
hi


I have many users accessing the web site ..  so i am getting large impact on the database.. so how can i reduce the burden on db?

Thanks,
ajay
Top Expert 2012
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
If you have access to phpmyadmin use it to see whether the issue is with the mysql database under (process)/status phpmyadmin provides information on where items need to be corrected. i.e. not enough tmp table size, etc.

Do you have separate web and database servers?
Are you looking to setup a master/master replication?
Each server is both the master and the slave to the other server.
http://www.howtoforge.com/mysql_master_master_replication
This way if you have two web server they can each query and get data from the local with the other as a failover.  This way you can distribute the load.

Note that you MUST make sure to monitor the replication (mysql slave status) as soon as the replication breaks, you need to correct it.  If too much time is allowed to pass, the faster corrective method will be to reestablish the replication on the node where the error occured.
CERTIFIED EXPERT
Top Expert 2007
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks for ur valuable suggestions.

Thanks,
Ajay
Top Expert 2012

Commented:
Ajayvegesna02, I don't mind not getting any points myself, but I think you should give credit to those who took time to help.  You yourself have said you received valuable suggestions, so why not just close the question the usual way?
Top Expert 2012

Commented:
I vote for #3 and just spread the points to 35452983, 35453086, 35514580.  The author gave a very general question, and all of the suggestions were technically sound, so all just spread the points evenly.
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
I think http:#a35457571 rather than http:#a35514580 should be included in the point split as referenced in the http:#a35693231.
Top Expert 2012

Commented:
Yeah, you're right arnold, wrong copy+paste on my part.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.