We have developed an ERP application which should run in a LAN network, when we make any entries it should be stored in the local DB first then updated in the web server DB. If there is no internet connection still the entries needs to be saved in the local dB and then when the internet is back it should automatically updated in the web dB.
Please help me with the steps of how to do it.
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
wow! i’m so happy to see this, i am about to build an erp system that performs the same function of syncing offline to online database. my question are as follows: should i host the application on a shared hosting or cloud hosting? and can i build the erp system with php and mysql?
please what other tools or tutorials do i need?
i am also using vanilla php with no frameworks.
thanks in anticipation.
If you are using Microsoft SQL server on windows then I have no idea how to replicate from it to Linux but maybe same instructions can work, however if you are using mysql on windows then it is the same.
As for the second question the Linux server which is the replication slave needs to connect to Windows which is the replication master, so you need to provide it with either an IP address on your router and setup port forwarding from the router to your Windows however this needs a fixed public IP address, if you cannot get it I think you can setup VPN server on Linux and then setup your router as a VPN client then you can connect from the server to windows using its private IP address which you can easily control it.
Sorry for making this too long but I hope it helps out, if you still have any other questions please do not hesitate to write back here.
Mouhsen Ibrahim
A simple guide for setting up your first web server. you will only cover PHP, MySQL database and Apache webserver.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.