title: Local Database for Java application
body: <p>I have a client server based application.
  The server is PHP with MySQL, no big functionality, just for keeping my data and providing and administration interface.
  The client is a Java (FX) application.</p>
  
  <p>Unfortunately the connection between the client and server is not permanent, so  I have to have a local copy of the database for the case the server if not accessible.
  Most of the times the client only reads data from the database but there are a few cases when it needs to update it.</p>
  
  <p>My question is: what is the better solution to keep up a local copy of a MySQL database and track changes (to be updated in MySQL next time it is available).</p>
  
  <p>It is a complicator factor that I do not need the full database locally, it would be too large, I need only the user specific information (user is authenticated by local machine username)</p>
  
  <p>Do you have any idea? :)</p>
  
  <p>Thanks:
  Levente</p>