MySQL

Comparison I have to disclaim that due to my limitation of knowledge, the following is just my personal opinion(according to my experience). So there may be some errors or omissions. If you have any suggestions, please let me know. Feature MySQL Operator Bitnami MySQL Percona XtraDB Cluster High Availability Yes Yes Yes Automatic Failover Yes No Yes Backup/Restore Yes No Yes Scaling Yes Limited Yes Custom Configurations Yes Limited Yes Multi-Master Replication Yes No Yes Ease of Setup Moderate Simple Moderate Community Support Weak Strong Strong Cloud Native Yes No Yes Installation Bitnami MySQL As to my concern, the bitnami one does not have a failover solution, so if the mater is down, it will be down for sure....

Migrate MySQL big table(50 Million) rows using insert into xxx select * from yyy and it said ERROR 1206 (HY000): The total number of locks exceeds the lock table size It’s due to MySQL MVCC control, the rows were in memory and exceeds the limit. You can use this command to quickly find the limit: SELECT @@innodb_buffer_pool_size/1024/1024/1024; For me, that’s 0.125. So I changed it by this command: SET GLOBAL innodb_buffer_pool_size = 1073741824; 10x the original size, so everything works fine....