title: MySQL InnoDB auto_increment value increases by 2 instead of 1. Virus?
body: <p>There's an InnoDB table for storing comments for blog posts used by a custom built web application.</p>
  <p>Recently I noticed that the auto incremented primary key values for the comments are incrementing by 2 instead of just 1.</p>
  <p>I also noticed that in another MySQL table which is used for remembering the last few commenter's footprint signature (e.g. ip, session id, uagent string, etc) the name of the PHP session starts with &quot;viruskinq&quot; which is weird because I thought it should always be a hexadecimal md5-like string.</p>
  <p>Google yields only a couple of results for &quot;viruskinq&quot;, all in Turkish. It is interesting because approximately a year ago the website in question was defaced by Turkish villains. (I'm 100% sure that the attackers didn't succeed because of any security holes in my app, because other websites, hosted by the same company, were defaced too at that time.)</p>
  <p>The site is on a shared host, using Linux.</p>
  <p>Do you think it is possible that the server itself may still be under the influence of those hackers? Examining the comment's id values revealed that this doubling phenomena exists since this May, but the defacing happened almost a year ago.</p>
  <p>What other causes could there be that explain the weird behavior of the auto increment value? The application hasn't been changed and at older comments the auto incremented primary key values are in order.</p>
  <h1>Edit: Summary of the solution</h1>
  <p>The hosting company informed me that the reason of the doubled auto increment value is because they use a Master-Slave MySQL architect and according to them this phenomena is normal.</p>
  <p>They also admitted that various hackers are constantly attacking their servers, &quot;especially the sessions&quot; and they cannot do anything about it.</p>
  <p>I think I better start packing my things and move to a better webhost.</p>