New answers tagged wamp
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