title: Mysql Master - Slave
body: <p>We are planning to make one master and two slave configuration. we have objective as below. we have huge incoming records, hence we are planning to do below:</p>
  
  <blockquote>
    <p>Master - has only past 7 days records  Slave 1 - as same as Master
    (only 7 days records) but we are going to run some stored procedure to
    consolidate the records </p>
    
    <p>Slave 2 - has all the records ( mostly last 3 months records ) ( we
    are planning to use SET sql_log_bin = 0 to stored procedure when ever
    we delete the records ( olderthan 7 days records in master ))</p>
  </blockquote>
  
  <p>Here we have question,</p>
  
  <p>is it okay to run store procedure in slaves to consolidate and delete the data?</p>
  
  <p>what are the operation can we perform in slave other than reads?</p>
  
  <p>is it safe use <code>sql_log_bin = 0</code>?</p>