Redirect mysql connectionsIssue NATing server private interface to loopback (for MySQL)Unable to connect to...
Is a stroke of luck acceptable after a series of unfavorable events?
Why are there no referendums in the US?
Was Spock the First Vulcan in Starfleet?
How do I go from 300 unfinished/half written blog posts, to published posts?
Is oxalic acid dihydrate considered a primary acid standard in analytical chemistry?
How do I extract a value from a time formatted value in excel?
Is HostGator storing my password in plaintext?
Failed to fetch jessie backports repository
How to safely derail a train during transit?
Is there a korbon needed for conversion?
Would this custom Sorcerer variant that can only learn any verbal-component-only spell be unbalanced?
Is this apparent Class Action settlement a spam message?
Do the temporary hit points from the Battlerager barbarian's Reckless Abandon stack if I make multiple attacks on my turn?
What is the best translation for "slot" in the context of multiplayer video games?
What can we do to stop prior company from asking us questions?
How did Arya survive the stabbing?
Replace character with another only if repeated and not part of a word
How can I quit an app using Terminal?
Go Pregnant or Go Home
Two monoidal structures and copowering
Is expanding the research of a group into machine learning as a PhD student risky?
Avoiding estate tax by giving multiple gifts
Was a professor correct to chastise me for writing "Prof. X" rather than "Professor X"?
How to be diplomatic in refusing to write code that breaches the privacy of our users
Redirect mysql connections
Issue NATing server private interface to loopback (for MySQL)Unable to connect to any of the specified MySQL hosts. when trying to connect mysqliptables not allowing mysql connections to aliased ips?HAProxy's Flooding MySQL ConnectionsTPROXY Not working with HAProxy, Ubuntu 14.04HaProxy giving - 503 Service UnavailableMySQL server is unreachable from OpenVZ containerUse HaProxy to add credentials under the hoodmysql on ec2 linux AMI crashed occasionallyUnable to access mongodb from my desktop
I have MySQL server on Azure. I have one common server which has public IP and whole outside traffic first hits on this server and then redirects to concern server. I call it a monitoring server.
On the monitoring server, I have Haproxy installed.
Haproxy config is as follows.
listen server2-mysql x.x.x.2:3306
mode tcp
balance roundrobin
server server2-mysql x.x.x.5:3306
x.x.x.2 is monitoring server private ip
x.x.x.5 is mysql server private ip
Now I want to connect to MySQL using WorkBench installed on my local centOS machine. I'm trying to connect to mysql using monitoring server's public ip but unable to connect it. How to do that.
mysql haproxy
asked 6 mins ago
innervoiceinnervoice
32
add a comment |
I have MySQL server on Azure. I have one common server which has public IP and whole outside traffic first hits on this server and then redirects to concern server. I call it a monitoring server.
On the monitoring server, I have Haproxy installed.
Haproxy config is as follows.
listen server2-mysql x.x.x.2:3306
mode tcp
balance roundrobin
server server2-mysql x.x.x.5:3306
x.x.x.2 is monitoring server private ip
x.x.x.5 is mysql server private ip
Now I want to connect to MySQL using WorkBench installed on my local centOS machine. I'm trying to connect to mysql using monitoring server's public ip but unable to connect it. How to do that.
mysql haproxy
asked 6 mins ago
innervoiceinnervoice
32
add a comment |
I have MySQL server on Azure. I have one common server which has public IP and whole outside traffic first hits on this server and then redirects to concern server. I call it a monitoring server.
On the monitoring server, I have Haproxy installed.
Haproxy config is as follows.
listen server2-mysql x.x.x.2:3306
mode tcp
balance roundrobin
server server2-mysql x.x.x.5:3306
x.x.x.2 is monitoring server private ip
x.x.x.5 is mysql server private ip
Now I want to connect to MySQL using WorkBench installed on my local centOS machine. I'm trying to connect to mysql using monitoring server's public ip but unable to connect it. How to do that.
mysql haproxy
asked 6 mins ago
innervoiceinnervoice
32
I have MySQL server on Azure. I have one common server which has public IP and whole outside traffic first hits on this server and then redirects to concern server. I call it a monitoring server.
On the monitoring server, I have Haproxy installed.
Haproxy config is as follows.
listen server2-mysql x.x.x.2:3306
mode tcp
balance roundrobin
server server2-mysql x.x.x.5:3306
x.x.x.2 is monitoring server private ip
x.x.x.5 is mysql server private ip
Now I want to connect to MySQL using WorkBench installed on my local centOS machine. I'm trying to connect to mysql using monitoring server's public ip but unable to connect it. How to do that.
mysql haproxy
mysql haproxy
asked 6 mins ago
innervoiceinnervoice
32
asked 6 mins ago
innervoiceinnervoice
32
asked 6 mins ago
innervoiceinnervoice
32
asked 6 mins ago
innervoiceinnervoice
32
asked 6 mins ago
innervoiceinnervoice
32
32
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
});
}
});
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%2f960375%2fredirect-mysql-connections%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
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%2f960375%2fredirect-mysql-connections%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
