Offloading query load from the database to another serverMySQL connection spike out of nowhereCloud hosting:...
Is there a ternary operator in math
How do you say "powers of ten"?
In the comics Did Thanos "kill" just sentient beings or all creatures with the snap?
Second-rate spelling
Is it possible to convert a suspension fork to rigid by drilling it?
Tcolorbox as an item in list environment
Difference between 'stomach' and 'uterus'
Where is the line between being obedient and getting bullied by a boss
Avoiding unpacking an array when altering its dimension
Where is the fallacy here?
Did 5.25" floppies undergo a change in magnetic coating?
What is better: yes / no radio, or simple checkbox?
Where was Karl Mordo in Infinity War?
Is there a frame of reference in which I was born before I was conceived?
Is there any relevance to Thor getting his hair cut other than comedic value?
Logistics of a hovering watercraft in a fantasy setting
What can I substitute for soda pop in a sweet pork recipe?
I encountered my boss during an on-site interview at another company. Should I bring it up when seeing him next time?
Infrastructure damage from sudden thickening of water
If a druid in Wild Shape swallows a creature whole, then turns back to her normal form, what happens?
What does 'acting greedily' mean?
Did Amazon pay $0 in taxes last year?
Sometimes a banana is just a banana
How do ISS astronauts "get their stripes"?
Offloading query load from the database to another server
MySQL connection spike out of nowhereCloud hosting: do we need it?MySQL queries hang siteSystem Requirements of a write-heavy applications serving hundreds of requests per secondBuilding a future-proof webappHow can I estimate the request/second my server is capable of?Website slowing down when many users access simultaneouslyUsing lvm2 snapshot of MySQL InnoDB file-per-table, do I need to stop the server for backup?mysql stops responding periodicallyMysql DB can't establish connection
I have a server installed in a fixed container with limited bandwidth and CPU.
On this server, I have a website that makes a lot of requests to its database.
One request every 5 seconds via AJAX. Unsustainable in a fixed container after a few hundred stay on the site for more than 10 minutes simultaneously.
I want to divert these requests, from the web app's MySQL database, to another server without a fixed limit of requests per minute, without moving the entire website to it.
Is there an easier method? Like MySQL load balancers or caching systems or MySQL slaves replication?
mysql amazon-web-services amazon-api-gateway
asked 7 mins ago
MauMau
1012
New contributor
Mau is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I have a server installed in a fixed container with limited bandwidth and CPU.
On this server, I have a website that makes a lot of requests to its database.
One request every 5 seconds via AJAX. Unsustainable in a fixed container after a few hundred stay on the site for more than 10 minutes simultaneously.
I want to divert these requests, from the web app's MySQL database, to another server without a fixed limit of requests per minute, without moving the entire website to it.
Is there an easier method? Like MySQL load balancers or caching systems or MySQL slaves replication?
mysql amazon-web-services amazon-api-gateway
asked 7 mins ago
MauMau
1012
New contributor
Mau is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I have a server installed in a fixed container with limited bandwidth and CPU.
On this server, I have a website that makes a lot of requests to its database.
One request every 5 seconds via AJAX. Unsustainable in a fixed container after a few hundred stay on the site for more than 10 minutes simultaneously.
I want to divert these requests, from the web app's MySQL database, to another server without a fixed limit of requests per minute, without moving the entire website to it.
Is there an easier method? Like MySQL load balancers or caching systems or MySQL slaves replication?
mysql amazon-web-services amazon-api-gateway
asked 7 mins ago
MauMau
1012
New contributor
Mau is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have a server installed in a fixed container with limited bandwidth and CPU.
On this server, I have a website that makes a lot of requests to its database.
One request every 5 seconds via AJAX. Unsustainable in a fixed container after a few hundred stay on the site for more than 10 minutes simultaneously.
I want to divert these requests, from the web app's MySQL database, to another server without a fixed limit of requests per minute, without moving the entire website to it.
Is there an easier method? Like MySQL load balancers or caching systems or MySQL slaves replication?
mysql amazon-web-services amazon-api-gateway
mysql amazon-web-services amazon-api-gateway
asked 7 mins ago
MauMau
1012
New contributor
Mau is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 7 mins ago
MauMau
1012
New contributor
Mau is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 6 secs ago
Mau
asked 7 mins ago
MauMau
1012
New contributor
Mau is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 7 mins ago
MauMau
1012
asked 7 mins ago
MauMau
1012
1012
New contributor
Mau is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Mau is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Mau is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "2"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Mau is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f956828%2foffloading-query-load-from-the-database-to-another-server%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Mau is a new contributor. Be nice, and check out our Code of Conduct.
Mau is a new contributor. Be nice, and check out our Code of Conduct.
Mau is a new contributor. Be nice, and check out our Code of Conduct.
Mau is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Server Fault!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f956828%2foffloading-query-load-from-the-database-to-another-server%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
