I often talk with people who are very interested in the features of Percona XtraDB Cluster (PXC) such as synchronous and parallel replication, multi-node writing and high availability. However some get confused when operating a real PXC cluster because they do not fully realize the implications of these features. So here is a fun way to test your PXC knowledge: try to solve these 12 questions related to PXC! (you will find the answers at the end of the post.)
Workload
1. With Galera 3.x, support for MyISAM is experimental. When can
we expect to have full MyISAM support?
a. This will never happen as Galera is designed for transactional
storage engines.
b. This is planned for Galera 4.0.
2. Why aren’t all workloads a good fit for PXC?
a. Execution plans can change compared to a regular MySQL server,
so performance is sometimes not as good as with a regular MySQL
server.
b. Large …