Using MySQL cluster as my datasource.

[ramakrid]

MySQL is my datasource. We so far have been using a single instance and connection is smooth. Now, we want to setup MySQL as a cluster so that we can improve reliability. How can I use MySQL cluster as my data source ? 

We were thinking about using this approach 

https://dev.mysql.com/doc/x-devapi-userguide/en/connecting-dns-srv.html

to setup multiple nodes. 

Any pointers or suggestion for a different approach to have a reliable MySQL and at the same time connect to Power BI seamlessly would be very helpful. 

[v-alq-msft]

Hi, @ramakrid 

I'd like to suggest you use 'Python script' connector to do it. As is said in the document, you may try the Python codes.

Python Code

session = mysqlx.get_session(host="tcp.example.com", dns_srv=True)

For further information, you may refer the following document.

Run Python scripts in Power BI Desktop 

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.