mysql - How to automate update process between 2 databases -
i'm quite new mysql , in database management in general.... i've solve scenario: in development stage web site has database in local machine , tables dedicated contain information data used application ,during development records of tables grow , when move production want update production server new data... can advise best practice automate update process local production database.
thanks in advance
the road doing have each database know how far has migrated.
you should absolute use liquibase or flyway it. if have simple database environment these 2 work. both of these track changes in version files database keep track of.
if need more complexity, in sharded environment, need roll own tool this.
Comments
Post a Comment