Is RDS for MySQL Compatible with MariaDB?
MariaDB is a branch of the MySQL source code. It is maintained by the open-source community and uses GPL licensing. One of the reasons for developing MariaDB is that Oracle acquired MySQL, so there is a chance that MySQL could become closed source. The community developed MariaDB to protect against this risk. MariaDB is compatible with MySQL for the most part. It was designed to be a drop-in replacement for MySQL, including the APIs and commands. There is no difference for front-end applications (such as PHP, Perl, Python, Java, .NET, MyODBC, Ruby, and MySQL C connector). As for the storage engine, MariaDB uses XtraDB to replace the InnoDB of MySQL. XtraDB is fully compatible with InnoDB and InnoDB tables can be converted into XtraDB tables by default.
Although MariaDB is a branch of MySQL, some changes have been made to MariaDB. Common applications that used MySQL databases can normally switch to MariaDB databases for data additions, deletions, modifications, or queries. But MariaDB is different from MySQL in terms of some new features. To ensure that MariaDB fits your application perfectly, a proof of concept (POC) is required.
Product Consulting FAQs
- What Should I Pay Attention to When Using RDS?
- What Is the Availability of RDS DB Instances?
- How Do I Distinguish Between General-Purpose and Dedicated RDS for MySQL Instances Using Cloud SSDs?
- Will My RDS DB Instances Be Affected by Other User Instances?
- Does RDS Support Cross-AZ High Availability?
- Can RDS Primary/Standby DB Instances Be Changed to Single DB Instances?
- What Are the Browsers Supported By RDS?
- What Can I Do About Slow Responses of Websites When They Use RDS?
- Can I Change the Replication Mode Between Primary DB Instances and Read Replicas?
- What Is the Time Delay for Primary/Standby Replication?
- Does a Primary/Standby Switchover Have Impact on Services?
- Can Multiple ECSs Connect to the Same RDS DB Instance?
- Can I Encrypt the Disk After Purchasing an RDS DB Instance?
- Will Backups Be Encrypted After Disk Encryption Is Enabled for My RDS Instance?
- Does RDS for MySQL Support Encryption Functions?
- What Are the Restrictions on RDS for MySQL DB Instances After GTID Is Enabled?
- Will Different RDS DB Instances Share CPU and Memory Resources?
- How Many Databases Can Run on an RDS DB Instance?
- Is RDS for MySQL Compatible with MariaDB?
- Does RDS for MySQL Support TokuDB?
- What Is the Maximum Size Allowed for a Single Table in RDS for MySQL Instances?
- Why Can't I Purchase Read Replicas on the RDS Console?
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbotmore