Ticket Server

Ticket server is used by Flicker — online phtoo serice. The idea is you have a server just for generating primary key inconstrast to Multi-master replication ID generator — which the web server itself will generate the ID and pass it to a centralised database.

This ticket server use auto_increment to increase the ID

Pros:

• Numeric IDs
• Easy to implement, works for small-medium applications

Cons:

• Single point of failure
  • If ticket server down then everything else also go down