Problem with CiviCRM configuration (auto_increment) with wordpress (4.x) website
Your hosting environment sounds unsuitable for running CiviCRM - CiviCRM does have some additional requirements beyond other PHP/MySQL apps like Wordpress and Drupal.

There are some places in CiviCRM code where it expects the database to increment IDs by 1. Where MySQL is running with eg replication, this will not be the case. There are also places where CiviCRM has checks for such settings, which are mostly to protect you against unexpected outcomes - even if there's no hard requirement for that setting to be the way CiviCRM "wants" it to be.

For your needs, the simple solution is not to address replication or patch CiviCRM, but simply to obtain hosting which is compatible with CiviCRM. Unless you are heavily invested in the existing hosting, switching hosts to someone who knows &amp; works with CiviCRM will be a much more straightforward solution than trying to make CiviCRM and that hosting service work together ...


CiviCRM's page on hosting (not an advert, just trying to save you time, money and grief)


For more technical detail, there's a related question from a site which specifically wanted to use MySQL replication + CiviCRM together - JIRA issues linked there:


MySQL Master-Master Replication on 2 servers