title: What's the right way to work with many MySQL servers from Node.js simultaneously?
body: <p>I develop mobile social network. All data stored in MySQL (via shards). Hot data stored in Redis, and there is shards map in Redis too. </p>
  
  <p>Backend = node.js (express)</p>
  
  <p>What is the right way of fast requests to a different MySQL servers within one request to the back-end from mobile client?</p>
  
  <p>Example:</p>
  
  <p>The client requests the server to the user profile with id = 1, which we store on the server mysql-1 shard #1. At the same moment another  client requests the server to the user profile with id = 2, which we store on the server mysql-2 shard #2.</p>
  
  <p>Number of mysql servers will grow. And the number of requests to the server will grow too. Initialize a new connection to MySQL on each request to the backend - I think that isn't good idea.</p>