Enhancing MySQL Database Security with MySQL Enterprise Transparent Data Encryption

Abstract

. With the increasing threats to data security and the potential consequences of data breaches, the demand for data security has steadily risen. Protecting sensitive information, particularly stored in databases, has become a crucial aspect of data management. Considering this, this study focuses on a specific solution for data protection within databases, MySQL Transparent Data Encryption, specifically in the case of PT ABC, an information and technology company. MySQL Transparent Data Encryption was implemented as a potential solution to enhance data security. The implementation of MySQL Transparent Data Encryption was tested by benchmarking to evaluate the effectiveness and efficiency of the solution before and after the implementation using JMeter, a widely recognized and reliable tool for performance testing. The research findings demonstrate that implementing MySQL Transparent Data Encryption could effectively secure the database while having a minimal impact on performance. This is a significant finding, as it shows that enhanced data security only sometimes comes at the cost of reduced performance. The encryption implementation resulted in a less than 10% decrease in database performance, indicating that the advantages of securing data outweigh the minor performance decrease. In conclusion, this study confirms the reliability of MySQL Transparent Data Encryption as a solution for securing data within a MySQL database. It confirms that this method of encryption is effective in enhancing data security and efficient in maintaining the performance of the database.