Tag Info

New answers tagged

0

For something like this, you may want to think about a unique architecture known as a Star Topology. Picture the following: Server HQDB with 25 databases (1 for each branch) Server BranchDB001 with database `branch001`` Server BranchDB002 with database branch002 ... Server BranchDB025 with database branch025 Setup Data for HQDB On HQDB, create the 25 ...


0

The authors of High Performance MySQL describe part of your problem fairly succinctly (p. 234): MySQL can’t execute a single query in parallel on many CPUs. This is a feature offered by some other database servers, but not MySQL. Running a single stored procedure will use no more than 1 of your CPU cores for executing queries, with a little extra on ...



Top 50 recent answers are included