How to Automatically synchronize phpmyadmin on two lampservers?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
My setup for my website is that i have a load balancer server, and two lamp servers and on the two lamp servers i have phpmyadmin installed.
I have synced the two lamp servers /var/www folders with unison and work perfectly..
What i am wanting to know is or does anyone know how to synchronize phpmyadmin database for the one website( As this whole setup is for 1 website only..)?
because i use the Load balancer server to direct traffic to either server and the website is on both lamp servers...
Just want to know is there a way that i can synchronize the databases as i am using phpmyadmin or can it be done that the 1st lampserver is configured to the phpmyadmin installed on there and that the 2nd lampserver can connect to the 1st lampserver's phpmyadmin is that possible?
first machine: zen load balancer (server)
second machine: lampserver (webserver1) holds the website files that sync with webserver 2
third machine: lampserver (webserver2) holds the website files that sync with webserver 1
or should i create another machine that just has phpmyadmin on it and holds the database for website directing the two lamp servers to connect to this machine?? How can this be done??
any help would be much appreciated..
all servers except zen load balancer are running ubuntu 12.04 lTS server OS
server apache2 mysql lamp phpmyadmin
asked May 25 '13 at 13:31
user161690user161690
111
add a comment |
My setup for my website is that i have a load balancer server, and two lamp servers and on the two lamp servers i have phpmyadmin installed.
I have synced the two lamp servers /var/www folders with unison and work perfectly..
What i am wanting to know is or does anyone know how to synchronize phpmyadmin database for the one website( As this whole setup is for 1 website only..)?
because i use the Load balancer server to direct traffic to either server and the website is on both lamp servers...
Just want to know is there a way that i can synchronize the databases as i am using phpmyadmin or can it be done that the 1st lampserver is configured to the phpmyadmin installed on there and that the 2nd lampserver can connect to the 1st lampserver's phpmyadmin is that possible?
first machine: zen load balancer (server)
second machine: lampserver (webserver1) holds the website files that sync with webserver 2
third machine: lampserver (webserver2) holds the website files that sync with webserver 1
or should i create another machine that just has phpmyadmin on it and holds the database for website directing the two lamp servers to connect to this machine?? How can this be done??
any help would be much appreciated..
all servers except zen load balancer are running ubuntu 12.04 lTS server OS
server apache2 mysql lamp phpmyadmin
asked May 25 '13 at 13:31
user161690user161690
111
add a comment |
My setup for my website is that i have a load balancer server, and two lamp servers and on the two lamp servers i have phpmyadmin installed.
I have synced the two lamp servers /var/www folders with unison and work perfectly..
What i am wanting to know is or does anyone know how to synchronize phpmyadmin database for the one website( As this whole setup is for 1 website only..)?
because i use the Load balancer server to direct traffic to either server and the website is on both lamp servers...
Just want to know is there a way that i can synchronize the databases as i am using phpmyadmin or can it be done that the 1st lampserver is configured to the phpmyadmin installed on there and that the 2nd lampserver can connect to the 1st lampserver's phpmyadmin is that possible?
first machine: zen load balancer (server)
second machine: lampserver (webserver1) holds the website files that sync with webserver 2
third machine: lampserver (webserver2) holds the website files that sync with webserver 1
or should i create another machine that just has phpmyadmin on it and holds the database for website directing the two lamp servers to connect to this machine?? How can this be done??
any help would be much appreciated..
all servers except zen load balancer are running ubuntu 12.04 lTS server OS
server apache2 mysql lamp phpmyadmin
asked May 25 '13 at 13:31
user161690user161690
111
My setup for my website is that i have a load balancer server, and two lamp servers and on the two lamp servers i have phpmyadmin installed.
I have synced the two lamp servers /var/www folders with unison and work perfectly..
What i am wanting to know is or does anyone know how to synchronize phpmyadmin database for the one website( As this whole setup is for 1 website only..)?
because i use the Load balancer server to direct traffic to either server and the website is on both lamp servers...
Just want to know is there a way that i can synchronize the databases as i am using phpmyadmin or can it be done that the 1st lampserver is configured to the phpmyadmin installed on there and that the 2nd lampserver can connect to the 1st lampserver's phpmyadmin is that possible?
first machine: zen load balancer (server)
second machine: lampserver (webserver1) holds the website files that sync with webserver 2
third machine: lampserver (webserver2) holds the website files that sync with webserver 1
or should i create another machine that just has phpmyadmin on it and holds the database for website directing the two lamp servers to connect to this machine?? How can this be done??
any help would be much appreciated..
all servers except zen load balancer are running ubuntu 12.04 lTS server OS
server apache2 mysql lamp phpmyadmin
server apache2 mysql lamp phpmyadmin
asked May 25 '13 at 13:31
user161690user161690
111
asked May 25 '13 at 13:31
user161690user161690
111
asked May 25 '13 at 13:31
user161690user161690
111
asked May 25 '13 at 13:31
user161690user161690
111
asked May 25 '13 at 13:31
user161690user161690
111
111
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Because each LAMP server is running its' own instance of MySQL, phpMyAdmin running on either server will only connect to the local MySQL instance on that machine. It's possible to set up MySQL to have server replication (master to slave) and for that you would have to delve into the MySQL manuals for setting that up. That would keep the databases synchronized and phpMyAdmin on either server would display the same database information (relative to the timing of the MySQL server replication process).
The other option is to use a single MySQL server to serve your databases and have regular backups set for the MySQL data.
answered May 25 '13 at 17:02
douggrodouggro
2,12131222
i understand thanks for the information i will look into it
– user161690
May 25 '13 at 19:25
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "89"
};
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%2faskubuntu.com%2fquestions%2f299895%2fhow-to-automatically-synchronize-phpmyadmin-on-two-lampservers%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Because each LAMP server is running its' own instance of MySQL, phpMyAdmin running on either server will only connect to the local MySQL instance on that machine. It's possible to set up MySQL to have server replication (master to slave) and for that you would have to delve into the MySQL manuals for setting that up. That would keep the databases synchronized and phpMyAdmin on either server would display the same database information (relative to the timing of the MySQL server replication process).
The other option is to use a single MySQL server to serve your databases and have regular backups set for the MySQL data.
answered May 25 '13 at 17:02
douggrodouggro
2,12131222
i understand thanks for the information i will look into it
– user161690
May 25 '13 at 19:25
add a comment |
Because each LAMP server is running its' own instance of MySQL, phpMyAdmin running on either server will only connect to the local MySQL instance on that machine. It's possible to set up MySQL to have server replication (master to slave) and for that you would have to delve into the MySQL manuals for setting that up. That would keep the databases synchronized and phpMyAdmin on either server would display the same database information (relative to the timing of the MySQL server replication process).
The other option is to use a single MySQL server to serve your databases and have regular backups set for the MySQL data.
answered May 25 '13 at 17:02
douggrodouggro
2,12131222
i understand thanks for the information i will look into it
– user161690
May 25 '13 at 19:25
add a comment |
Because each LAMP server is running its' own instance of MySQL, phpMyAdmin running on either server will only connect to the local MySQL instance on that machine. It's possible to set up MySQL to have server replication (master to slave) and for that you would have to delve into the MySQL manuals for setting that up. That would keep the databases synchronized and phpMyAdmin on either server would display the same database information (relative to the timing of the MySQL server replication process).
The other option is to use a single MySQL server to serve your databases and have regular backups set for the MySQL data.
answered May 25 '13 at 17:02
douggrodouggro
2,12131222
Because each LAMP server is running its' own instance of MySQL, phpMyAdmin running on either server will only connect to the local MySQL instance on that machine. It's possible to set up MySQL to have server replication (master to slave) and for that you would have to delve into the MySQL manuals for setting that up. That would keep the databases synchronized and phpMyAdmin on either server would display the same database information (relative to the timing of the MySQL server replication process).
The other option is to use a single MySQL server to serve your databases and have regular backups set for the MySQL data.
answered May 25 '13 at 17:02
douggrodouggro
2,12131222
answered May 25 '13 at 17:02
douggrodouggro
2,12131222
answered May 25 '13 at 17:02
douggrodouggro
2,12131222
answered May 25 '13 at 17:02
douggrodouggro
2,12131222
2,12131222
i understand thanks for the information i will look into it
– user161690
May 25 '13 at 19:25
add a comment |
i understand thanks for the information i will look into it
– user161690
May 25 '13 at 19:25
i understand thanks for the information i will look into it
– user161690
May 25 '13 at 19:25
i understand thanks for the information i will look into it
– user161690
May 25 '13 at 19:25
add a comment |
Thanks for contributing an answer to Ask Ubuntu!
- 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%2faskubuntu.com%2fquestions%2f299895%2fhow-to-automatically-synchronize-phpmyadmin-on-two-lampservers%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
