I am thinking the best and most simplest way to do this is add a decimal to the ID attribute.
So the ID number after the decimal indicates the remote app server number and guarantees uniqueness of ID in the Master AIM app
Example:
- Server 1 ID = 10210.1
next 10211.1
Server 2 ID = 14358.2
next 14359.2
Server 2 ID = 23647.3
next 23648.3
Some questions:
1. Is this a good idea - will it impact performance. Integer vs Decimal
2. I am not an expert in stored procedures or triggers (MySQL). I would want the ID change to happen dynamically as the new records are being created. Any suggestion on how I could do this using a stored procedure or trigger. Some help on this and best practice would be greatly appreciated.
3 Are there any other suggestions, ideas, concepts on how to sync two AIM databases?