SQL vs MySQL Enterprise Active/Active solution

Topics: Administration
Jun 23, 2015 at 9:58 PM
Edited Jun 24, 2015 at 4:27 PM

We have been doing research on migrating our Orchard databases from SQL to MySQL, so far the results have shown the performance is very similar. However this has only been on a local server without any serious enterprise environment setup.

What we plan to do in production is host a distributed MySQL solution across two data centers (Active/Active). My biggest questions are:

Has anyone done something similar? Migrating from SQL To MySQL Orchard databases in an enterprise active/active environment, using synchronized keys between the servers (i.e. data center 1 has odd index, data center 2 has even indexes)?

Also what were the performance implications of the production solution after switching from SQL?

Any help or feedback is appreciated.