Re: [PHP] operational musings

Without any more than a few minutes worth of work, you can make MySQL do that with replication. Your in-store system could act as a slave to for the central system databases (any central updates trickle down to the slave automatically) and your in-store machine could be the master for the store_xyz database(s).

Network disconnect? No problem!
Network reconnect? Easy!
In-store machine failure? No problem! Just update the tables from the central master!
Work? Almost none!

And since this is a PHP list...

<?= 'jon' ?>

Jay Blanchard wrote:
Howdy cats and kittens!

I had an interesting thought after watching a demo of a POS system and
wondered if the same type of methodology could be applied in a PHP
application. I haven't thought this all the way through, but a
fully-hatched idea like this could signal a major change in applications
designed with PHP.

In the POS if the network connectivity was lost the store could continue
to operate, once the network connectivity was restored the data from
each store would sync back up and data would be sent to the central
server, yadda, yadda, yadda. Of course this is in a client/server
application with an executable residing on each workstation.

So, if you wanted to do this with PHP you would likely have to have a
local web /database server (each store), establish a socket (primary and
store servers?) to watch for an outage/restore and then write the code
to support the sync up. Can it be done with PHP? It would definitely be
worth the trouble given the frequency that connections to stores get
lost.

Thanks in advance for ideas, thoughts, etc.

.

Relevant Pages

  • Re: [PHP] operational musings
    ... wondered if the same type of methodology could be applied in a PHP ... In the POS if the network connectivity was lost the store could ... server, yadda, yadda, yadda. ...
    (php.general)
  • Re: [PHP] Persistent Objects
    ... way to create a persistent object in PHP? ... Normally you have to recrate your objects in every request. ... store your objects. ... Also you can store our session with memcached or sql too. ...
    (php.general)
  • Total Newbie Question
    ... I've completed reading my "PHP and MySQL Web ... I'm not sure how to store ... My database is basically a list of teachers and students. ...
    (comp.lang.php)
  • RE: [PHP] operational musings
    ... environment, with a Linux server in every store, talking to the POS ... those transactions to a central server (which isn't running Linux, PHP, ... I'm finding the PHP socket support to be unreliable, ...
    (php.general)
  • Re: databases
    ... because i only know how to store text in the database. ... which command should i use (php) in order to retrieve these ... according to file extension and making the above header() call relative to ...
    (comp.lang.php)