Abstract

Abstract This paper deeply studies the compatibility and performance verification methods of domestic database replacement Oracle database and focuses on the application of Replay technology in database migration. By comparing and analyzing the key technologies such as Oracle Real Application Testing, SQL Server Profiler, iReplay, OceanBase Migration Assessment, and Kreplay, this paper proposes a migration verification scheme based on Kreplay. This scheme comprehensively evaluates the compatibility and performance of domestic databases by capturing the actual workload of the production environment and replaying it in the test environment to simulate the real scene. The experimental results show that Kreplay has obvious advantages in heterogeneous database migration and transaction complete capture, and it can effectively find and solve compatibility and performance problems in the migration process. The research in this paper provides technical support for the promotion and application of domestic databases and references for future database replacement technology development.