Rails - Aug 2006 - Custom id field auto_increment increment and offset?

Hi all,
in mysql, you can set the following environment variables:

set @@auto_increment_offset    = 4;
set @@auto_increment_increment =10;

such that:

create table people (id int auto_increment primary key, name char(100));
insert into people set name=''Giuseppe'';
insert into people set name=''Laura'';
select * from people;
+----+----------+
| id | name     |
+----+----------+
|  4 | Giuseppe |
| 14 | Laura    |
+----+----------+

As you can see, thosee two variables determine the id that will be used 
for the first insert, and the increment for all subsequent inserts.

ActiveRecord seems to ignore this. In fact, if you use Rails to append 
new records to this table, the third row will get an id of 15 (instead 
of 24, as I would like).

I have unsuccessfully gone through the AR lib in search of the mechanism 
used by AR to determine ids for new records in a mysql connection.

Could anyone suggest a DRY way to either get AR to follow the scheme set 
in mysql or to override AR''s behavior and impose custom 
increment/offsets for id fields?

Incidentally, this request stems from the need to set up multiple-master 
database replication 
(http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html?page=1)

Cheers, Giuseppe

-- 
Posted via http://www.ruby-forum.com/.