mySQL 自动增量增加 10 (ClearDB & Node)

Question

我在 ClearDB 中有一个简单的表:

CREATE TABLE `users` (

`id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(100) DEFAULT NULL,
`message` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`)

) ENGINE=INNODB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

我正在使用 Node 通过以下方式将数据插入表中:

var post = {username: response.user.name, message: message.text};

           connection.query("INSERT INTO users SET ?", post, function(err, rows, fields) {

                 if (err) {
                       console.log('error: ', err);
                       throw err;
                 }

           });

但是每当我插入我的 id 字段时增加 10 而不是 1(它从 12 开始:

id 用户名消息

12测试测试

22测试测试

32测试测试

42测试测试

知道为什么会这样吗？

谢谢!

Answer 1

这是 ClearDB 的策略。 Here is the explanation from ClearDB's website.

当您使用 ClearDB 时，您不能更改此 auto_increment 步骤。

---

这是上面链接的解释。

ClearDB uses circular replication to provide master-master MySQL support. As such, certain things such as auto_increment keys (or sequences) must be configured in order for one master not to use the same key as the other, in all cases. We do this by configuring MySQL to skip certain keys, and by enforcing MySQL to use a specific offset for each key used. The reason why we use a value of 10 instead of 2 is for future development.