Multi-version coexistence in the app background

Source: Internet
Author: User
Tags diff scp command

The problem lies in:

The app has been online for one months now, the number of users uh, uh, barely 2000 registered users. Then the 1.3 version of the app will be ready for development.

Then on-line, 1.1,1.2 should be able to keep. iOS and Android are the same.

One: First, the interface version

I think the solution is that each version of the separate deployment of V1,V2,V3 before the interface does not change. Deploy the new API directly. This is convenient to deploy, but there is a big hidden danger is that if you modify a logic before all the items have this logical version will need to be modified.

II: Changes in the database

Each version of the interface will be more or less database changes, additions and deletions and other things.

Update steps:

1. First determine the table differences between the latest version and the original version of the database structure.

2. Set all the new table structures to a reasonable default value, placing an insert with an error.

3. Downtime update (temporarily not considering the non-stop update), temporarily scheduled at 11 o'clock in the evening, first stop the service and then transfer the old database data to the new database.

4. Simple test to see if there are any errors.

The most important step is to compare the differences in the database table structure, in the approximate steps:

1. Export the table structure of two database tables

Mysqldump–uroot–p–d speedjump > Speedjump1.sql

Use SCP command to transfer to a server

Mysqldump–uroot–p–d speedjump > Speedjump2.sql

-d means that only the structure is exported and no data is exported.

2. Compare

Use the diff command to compare

Diff Speedjump1.sql Speedjump2.sql > diff.txt

3. Some information is useless must be self-increment ID value, preferably removed

-i ‘s/AUTO_INCREMENT=[0-9]\{1,\}//‘ SPEEDJUMP1.sql


Multi-version coexistence in the app background

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.