Hi everybody, I have the following scenario. Several computers with shared disk in a LAN. Each of these computer has a MySQL server that serves several databases. I have several clients that communicate with a Java process that I have in each computer to answer queries for a given database (it connects to the MySQL server). I also have a Java process that updates continuously the databases; this process executes only in the local computer: it takes advantage from the fact that the disk is shared in order to update all the databases as quick as possible when it is needed.
I am observing some problems: 1) It seems to be a consistency problem. Updates that are performed by the process that updates the databases are not always seen by the clients. 2) Sometimes, it seems that some tables get corrupted, as clients get errors relative to the table handler. Do I need to do something special to ensure the consistency? Does this scenario make sense to you? I know that I could use different processes in each computer to perform the updates (not taking advantage of the shared disk) but then I would have to synchronize these processes to perform the updates at the same time (the updates are the result of a simulation, and they must be performed at specific relative times). Thanks in advance for any suggestion, Sergio P.S. I also get sometimes an error: General error, message from server: "Can't lock file (errno: 116)". -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
