> > Hold on, "(it should be, its the same file)", you're saying that db2 on > server1 and server2 are using the same database files (datadir)? If that's > the case, why? That doesn't make any sense. > > > Atle > - > Flying Crocodile Inc, Unix Systems Administrator >
Im replying from another account here .. that's the whole point ... server1 supposed to be read only .. while other server (2-4) the ones that take the role in writing it i know it's kind of weird, but hey, if it should work in theory, why not trying it .. that's why what i ask in the first place is "is it a locking issue? is it mysql part or filesystem issue)" i already found a work around for this problem with scheduling, but that's not the prettiest solution that i hoped for :) or maybe there are other solution?