trjhtr

I have been trying to use the new async/await feature of Node 8 with node-mysql module. Have been partial successful in incorporating async/await with mysql. When I create a cluster pool connection with node-mysql client I am unable to do this without the callback. If I write callback I am able to get the data from MySQL but when I am using async/await I am getting weird errors. Although I have been able to write the getConnection function in async/await form but no luck with the connection.query part. Can anybody help in this context ?

 **SAMPLE CODE**
**//pool-cluster.js** <br>
var poolCluster = mysql.createPoolCluster();
var masterConfig = ...;
var slaveConfig1 = ...;
poolCluster.add('MASTER', masterConfig);
poolCluster.add('SLAVE1', slaveConfig1);
poolCluster.getConnection = util.promisify(poolCluster.getConnection());
module.exports.PoolCluster = poolCluster;

**//connect-cluster-pool.js**

var poolClusterSrv = require('../pool-cluster');<br>
async fetchRecord() <br>
 let queryStr = 'select * from customers';<br>
 console.log("inside fetchRecord()...");<br>
 try <br>
 let connection = await <br>poolClusterSrv.PoolCluster.getConnection('SLAVE1'); --<b>this is working</b>
 console.log("Connected to SLAVE1::", connection.threadId); 
 //getting new threadId every time
 let results = await util.promisify(connection.query(queryStr)); 
 //this is not working / working only with callback</b>
 console.log(results);
 return results;
 <br>
 catch (error) 
 console.log("error in fetchRecord()::", error);
 <br>
 <br>