MySQL Cluster and Auto Increment Primary Keys

xbox · #1 (**permalink**) 04-20-07, 10:15

I have most my tables using autoincrement as a primary keys. In mysql cluster can you have autoincrement as a primary keys for the tables?

aschk · #2 (**permalink**) 04-20-07, 11:10

I don't see why not. Would certainly make it difficult to use MySQL Cluster if primary autoincrement key were NOT available...
I personally don't have any experience with MySQL Cluster but I would be surprised if it wasn't implemented.

stewartsmith · #3 (**permalink**) 05-08-07, 01:33

Yes, MySQL Cluster fully supports auto_increment columns. We also prefetch auto_increment numbers for each MySQL Server connected to the cluster to increase performance.

Internet Services

Web Development

Digital Marketing

Consumer Tech