Mysql offline online database syncSynchronize MySQL databases between local and hosted servershow to sync...

Why does a single AND gate need 60 transistors?

What does "south of due west" mean?

In a post apocalypse world, with no power and few survivors, would Satnav still work?

Why write a book when there's a movie in my head?

Can you prevent a man in the middle from reading the message?

What is the meaning of "usr"?

Why is Shelob considered evil?

If we can’t finish all tasks, does this mean we are doing Scrum wrong?

Alternate timeline nomenclature

Would water spill from a bowl in a Bag of Holding?

Neglect higher order derivatives in expression

What if I miss a connection and don't have money to book next flight?

Why do single electrical receptacles exist?

Is it possible to have the same planeswalker from different editions in a Commander deck?

What could cause an entire planet of humans to become aphasic?

Linearity Assumption

Why can't I set the 'prototype' of a function created using 'bind'?

Taking an academic pseudonym?

Why is it that Bernie Sanders is always called a "socialist"?

Including proofs of known theorems in master's thesis

filecontents: select rows of group to display

two subject complements in passive form?

Players preemptively rolling, even though their rolls are useless or are checking the wrong skills

Is it possible to methodically find the total of ways to read a given phrase making a stack?



Mysql offline online database sync


Synchronize MySQL databases between local and hosted servershow to sync local mysql database and live server database?Mysql Replication - How it works offline?Live Database Sync. MySQL - SQL ServerMysql database offline-online synchronizationOffline to Online database synchronization programmatically using PHP and MySQLMysql replication, allow inserts while database is disconnectedMysql database replication with geo-distributed serversHow do I force an update of local transactions when a off line InnoDB multi-primary mode cluster member rejoins the cluster?Sync local mysql database and live server database?













0















We have built a software web-portal (Accounting Software) in PHP language.
But when the internet goes down in the stores, the software stops completely and the staff are not able to make bills till the time internet is live again!



Hence we want to build an offline module, which involves local server setup (wamp or easy-PHP)and deploying the code offline on the local machine/PC
The problem we are facing is syncing the offline and online MySQL databases.
Moreover, there are 6 different stores which will be running the offline billing module hence the problem increase here.



We want to build a program that can sync both the database offline and online periodically and when the internet goes down and resumes for 6 different stores.



please I need solution on the above.



We used PHP and MYSQL.









share







New contributor




noble is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

























    0















    We have built a software web-portal (Accounting Software) in PHP language.
    But when the internet goes down in the stores, the software stops completely and the staff are not able to make bills till the time internet is live again!



    Hence we want to build an offline module, which involves local server setup (wamp or easy-PHP)and deploying the code offline on the local machine/PC
    The problem we are facing is syncing the offline and online MySQL databases.
    Moreover, there are 6 different stores which will be running the offline billing module hence the problem increase here.



    We want to build a program that can sync both the database offline and online periodically and when the internet goes down and resumes for 6 different stores.



    please I need solution on the above.



    We used PHP and MYSQL.









    share







    New contributor




    noble is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.























      0












      0








      0








      We have built a software web-portal (Accounting Software) in PHP language.
      But when the internet goes down in the stores, the software stops completely and the staff are not able to make bills till the time internet is live again!



      Hence we want to build an offline module, which involves local server setup (wamp or easy-PHP)and deploying the code offline on the local machine/PC
      The problem we are facing is syncing the offline and online MySQL databases.
      Moreover, there are 6 different stores which will be running the offline billing module hence the problem increase here.



      We want to build a program that can sync both the database offline and online periodically and when the internet goes down and resumes for 6 different stores.



      please I need solution on the above.



      We used PHP and MYSQL.









      share







      New contributor




      noble is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.












      We have built a software web-portal (Accounting Software) in PHP language.
      But when the internet goes down in the stores, the software stops completely and the staff are not able to make bills till the time internet is live again!



      Hence we want to build an offline module, which involves local server setup (wamp or easy-PHP)and deploying the code offline on the local machine/PC
      The problem we are facing is syncing the offline and online MySQL databases.
      Moreover, there are 6 different stores which will be running the offline billing module hence the problem increase here.



      We want to build a program that can sync both the database offline and online periodically and when the internet goes down and resumes for 6 different stores.



      please I need solution on the above.



      We used PHP and MYSQL.







      mysql php





      share







      New contributor




      noble is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.










      share







      New contributor




      noble is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.








      share



      share






      New contributor




      noble is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 5 mins ago









      noblenoble

      1




      1




      New contributor




      noble is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      noble is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      noble is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






















          0






          active

          oldest

          votes











          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "182"
          };
          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: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          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
          });


          }
          });






          noble is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230573%2fmysql-offline-online-database-sync%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








          noble is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          noble is a new contributor. Be nice, and check out our Code of Conduct.













          noble is a new contributor. Be nice, and check out our Code of Conduct.












          noble is a new contributor. Be nice, and check out our Code of Conduct.
















          Thanks for contributing an answer to Database Administrators Stack Exchange!


          • 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.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230573%2fmysql-offline-online-database-sync%23new-answer', 'question_page');
          }
          );

          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







          Popular posts from this blog

          Szabolcs (Ungheria) Altri progetti | Menu di navigazione48°10′14.56″N 21°29′33.14″E /...

          Discografia di Klaus Schulze Indice Album in studio | Album dal vivo | Singoli | Antologie | Colonne...

          How to make inet_server_addr() return localhost in spite of ::1/128RETURN NEXT in Postgres FunctionConnect to...