Mysql clusters or replication -
im building application should work online , off-line.
i have application on fisical stores , administration on web application should systems installed locale on store.
i have actions insert , update system web should execute , systems local keep insert , update actions time, cannot depends of internet, because need database local.
i try use galera clusters , replication master master,
galera clusters work nice when node offline node stop work, node store , store cannot stop.
replication master master generate primary key conflit.
which tool me on situation.
updated
to simplification,
all data generated stored offline wont should affect other store, mean orders, clients, payments. datas can on database, store see self data.
system admnistration online, should see datas of stores , have actions insert , update above stores like, block clientes, aprove orders, generated stoke,
but actions system admnistration online able, store not able, example, system admnistration online can create products, make stoke , block clients.
Comments
Post a Comment