title: mariaDB(mysql) replication after slave is up after down
body: <p>I have remote host (centos6) with mariadb (10.0.17-MariaDB-log - MariaDB Server) as master:</p>
  
  <pre><code>server-id   = 1
  log-bin=mysql-bin
  binlog_do_db = mydatabase
  </code></pre>
  
  <p>and local (win8.1) with mariadb (10.0.16-MariaDB-log - mariadb.org binary distribution) as a slave:</p>
  
  <pre><code>server-id = 2
  </code></pre>
  
  <p>As initial procedure I've dumped database on remote host, imported it on local host, then executed SHOW MASTER STATUS, get filename and offset and run:</p>
  
  <pre><code>CHANGE MASTER TO MASTER_HOST='$host', MASTER_USER='$user', MASTER_PORT = $port, MASTER_PASSWORD='$pass', MASTER_LOG_FILE='$fname', MASTER_LOG_POS=$pos
  STOP SLAVE
  START SLAVE
  </code></pre>
  
  <p>Replication starts. Everything I do with table on master is reflected to slave. </p>
  
  <p>But if slave goes down, after it is up no changes (made on master) while slave was offline reflected to slave! So it looks like my slave should always be online, but it's a laptop!
  However after slave is up realtime replication still works - it doesn't remember all changes from offline, but if I change database on master when slave is online and started all changes are perfectly reflected to slave. Of course I know that replication is statement based, so I get not data diff but instructions. But I thought master remembers what it sent and what did not. So on next operation it just sends all non-delivered changes. Am I wrong?</p>
  
  <p>My replication scenario: master server interacts with clients (mobile devices) and they change the database. From time to time I launch my laptop, start replication, get updated database and do some heavy analysis (it's too hard for my 2-core cheap server). 
  Maybe there is a better method? Is there a way to get "offline changes" like in ICQ messenger? :) 
  For now I can see only one solution - full db dump, but it is inconvenient,  takes too much time and loads master heavily. </p>