Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum. |
Notices |
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Are you new to LinuxQuestions.org? Visit the following links:
Site Howto |
Site FAQ |
Sitemap |
Register Now
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
|
 |
09-10-2014, 04:28 AM
|
#1
|
LQ Newbie
Registered: Sep 2014
Posts: 12
Rep: 
|
Production server configuration
Hello, I'm new here, so sorry if I've choosen wrong forum section.
I have a problem, that i'd like to address to you. We are creating an webapp that shows infos and statistics. And we have a problem about how to 'do right' our server configuration
The thing is that our apps use crons to do few things, and crons sometimes blocks our database, and when that happens, whole application is frozen, which means no user input, no pages loading etc.
What should we do to prevent this from happening? is there a way to mirror the database and hold two of them one for backend and one for frontend, or we should limit connections to the database, or maybe we should use some other method.
Any help would be appreciated
|
|
|
09-10-2014, 10:08 AM
|
#2
|
LQ Guru
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 27,794
|
Quote:
Originally Posted by bgcadmit
Hello, I'm new here, so sorry if I've choosen wrong forum section.
I have a problem, that i'd like to address to you. We are creating an webapp that shows infos and statistics. And we have a problem about how to 'do right' our server configuration The thing is that our apps use crons to do few things, and crons sometimes blocks our database, and when that happens, whole application is frozen, which means no user input, no pages loading etc.
What should we do to prevent this from happening? is there a way to mirror the database and hold two of them one for backend and one for frontend, or we should limit connections to the database, or maybe we should use some other method.
|
Not much we can tell you, since you give us no details. You don't tell us what version/distro of Linux, what database you're using, what the cron jobs do, when they do it, what applications are running, how many users, what kind of hardware, what storage device(s) hold the database, etc. We can't guess.
Depending on the database and what you're using for backups, there are ways to do a 'hot' backup of a database (that is, back it up while it's running). MySQL has the mysqldump utility, that will take a copy of a database, and shove it into a file. You can restore it from that file later, and you don't have to take the DB down to do it.
Provide some details, and we can try to help.
|
|
|
All times are GMT -5. The time now is 09:36 PM.
|
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.
|
Latest Threads
LQ News
|
|