The Design And Implementation Of Cassandra Migration Tool

Nowadays,most applications need to manage a lot of enterprise data.Development teams engaged in such projects often treated database and application as the separate entities.The reason for this phenomenon is that the organization separates the database team from the application development teams.This separation leads to some problems: manual changes to the database,the database can not be shared with other members of the team change,alter database using inconsistent methods or data,use inefficient manual methods to manage database versions.These practices are inefficient,so that developers can not be changed to keep pace with the data.Moreover,it results in the data inconsistencies and data corruption.In view of the problem manually migrate databases,enterprise development prefer to use the automated migration tool to complete the migration of the database,such as Flyway.However,most of these existing tools are oriented to traditional relational databases,it can be a good support for SQL scripts.But for the new Nosql,such as Cassandra that our used,we have no much choice.This paper presents the design of a Cassandra automated database migration tool.Cassandra uses CQL language to define and write the data model and supports JAVA client.The goal of the tool is to detect and analysis CQL scripts and JAVA scripts under the indicated directory,decide which script has been executed or not executed,and then generate a list of tasks to perform.Then according to the task list,it executes scripts one by one,records the execution log to facilitate developers to debug later,and keep track of the status of the process in a database table called VersionTable.The tool uses the Java language and use Maven as a project management tool to automate deployment.By Maven configuration in local,the existing platform takes advantage of this tool well.After testing,it reached the goal: the developers understand well the state of the database,know what the script has been executed with the use of the database migration tool.They correct grammatical errors according to the script execution log.This greatly improves production efficiency.