Shulou(Shulou.com)06/01 Report--

Summary of data transfer from radius Billing system to Blue Ocean Billing system

This paper is for reference only, and the test is successful in the actual environment. You are welcome to ask questions.

1. First of all, we must have a clear train of thought and a clear goal.

This billing migration mainly migrates users of the old billing radius management system to the Blue Ocean billing system. Because there are similarities and differences between the old billing system and Blue Ocean billing system. Therefore, it is necessary to modify the data format of the old billing system to meet the requirements of blue ocean billing (blue ocean billing has provided a standard format for data import). Only in this way can the old accounting be safely introduced into the Blue Ocean system and the billing system can be migrated smoothly.

two。 Preparatory work

2-1 the first step is to collect the data format of the new and old billing system and the relevant permissions of the database.

2-2 collect the requirements that need to be migrated, and this migration is not to migrate all users to the Blue Ocean system. According to the needs of the company's battalion commander, the data will be exported to the old system and then imported into the new system.

2-3 in order to ensure the security of the billing system, the database of the old system needs to be backed up to the test environment for testing. At the same time, it is necessary to do a good job in the export time of the database.

2-4 do the product import of some data first. Observe the effect of import and then study the follow-up work.

2-5 as the data is imported into the blue ocean billing system, data testing will also be carried out in the later operation.

2-6 collect the relevant data of the new and old systems, this time mainly collect package information and tariff information of the data.

3 risk

3-1 if this data migration fails, all migrated users will not be able to use the network correctly. Users entered manually by Blue Ocean system will not be affected. For the smooth completion of this transfer, through consultation with the camp. First, 10 users of a very small community are migrated, ready to recover at any time, and effective processing is made according to the reflection of the users.

3-2 for a period of time after the completion of the data migration, no one shall delete the data of the old plan and ensure that it is running all the time for a period of one month or more.

3-3 if the migration fails, all users involved in the migration will not be able to dial properly. Therefore, it is necessary to do a good job of billing recovery, cutting prior notice, and doing a good job of customer service.

3-4 the migration time should be in the period when the number of users surfing the Internet is small.

4 time

4-1 this migration is arranged by the company to conduct an one-time migration of data on the basis of the success of the test migration. The plan takes 10 hours to minimize as much time as possible.

5. Resource scheduling

5-1 this migration requires the participation of relevant personnel of the R & D department of the Technology Department, senior administrators of the billing camp, colleagues of the network cut-off department, colleagues of the network management department and customer service colleagues to do a good job of notification and explanation, so as to effectively prevent network interruption.

6. Implementation steps:

6-1 use putty to connect to the old billing linux system through ssh

6-2 perform a database backup operation with the obtained database account, with the following command:

Mysqldump-h227.0.0.1-uroot-pxxxx radius > radius_201512310800.sql

6-3 perform the following database restore operations in the built test database environment.

Create database radius

Mysql-h227.0.0.1-uroot-p* radius'2015-05-31'

6-8 import the exported csv into Blue Ocean Billing through the data import function under database management. Pay attention to the prompt message of Blue Ocean Billing during the import process. If you find an error, please analyze it carefully.

6-9 as the data involves the company's secrets, it will not be attached one by one again.

This is the end of this article.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.