New answers tagged

0 votes

Availability Group - Core cluster resources switch to being owned by secondary node after windows patching reboots

[...] but is this something I should be worried about, like if the secondary datacenter goes offline? That entirely depends on the design of the cluster. If there is a scenario where the core cluster ...
user avatar
0 votes

What is the best solution for synchronous sync and load balancing an InnoDB database

Either InnoDB Cluster (with MySQL 8.0) or Galera (preferrably with a recent MariaDB version) M/M (Primary-Primary) is a partial solution to HA and scaling; not worth considering, given the above ...
user avatar
  • 68.7k
0 votes

What is the best solution for synchronous sync and load balancing an InnoDB database

NDB is the only solution you mention that supports horizontal scalability. That is, part of the data resides on each node, so the more nodes you have, the greater the write capacity. The others are ...
user avatar
  • 9,746

Top 50 recent answers are included