3 ms·
I have been using MySQL's master-master scheme for a long while for fail-over situations. Though, my databases are relatively simplistic. The master-master th
by epoxyhockey 15y ago
I have been using MySQL's master-master scheme for a long while for fail-over situations. Though, my databases are relatively simplistic. The master-master thing is nice because one server uses even values on auto-increment fields and the other uses odd values. Thus, no chance for collisions if all of your tables are designed with an auto-increment id field.
- aphyr 15y agoThats a great way to handle it. In our case we had an, er, extensive legacy schema to preserve. Moral of the story: plan to scale early. You don't have to actually build that scaling infrastructure ... but keep its requirements in mind.