Hello guys,
I’m trying to drive MySQL database uploaded on Render following this tutorial - Deploy MySQL – Render Docs but unfortunately I have this errors.
Can anyone help with resolving this issues, please ?
Images can be uploaded directly onto this forum. Please do not link out to external image hosts.
Alternatively, since we’re likely dealing with text errors, it’s probably more efficient to copy/paste the text itself instead.
- You’re going to experience data loss running MySQL on Render, see Persistent Disks – Render Docs
- You’re running MySQL as a Web Service, Web Services must response to Web Requests, which MySQL will not do. You should be running MySQL as a Private Service.
Thank you for your reply, Jason-Render
I followed the steps you told me but the error is still there.
Please help, thanks.
What service are you sending the request from?
Sorry, I didn’t get your question.
You mean the request API or the MySQL service address ?
What page were you viewing when you received that error in your Developer Console?
The page I’m trying to view is https://pokrivalanet.onrender.com/ with request API from https://pokrivalanet-api.onrender.com/api/price/truckcovers-prices.
Do you want also to send you the MySQL private service address ?
Static Sites do not have Private Network access ( Private Network – Render Docs ), necessary for accessing Private Services.
Okay, but how to proceed in this situation ?
The service that accesses MySQL needs to be a Web Service. Alternatively, use a non-Render MySQL host that will allow a MySQL instance to be publicly reachable.
Additionally, you don’t want a Static Site connecting to private resources, because all the (generated) source code of a Static Site is publicly readable.
What is a non-Render MySQL host and how to make it to allow a MySQL instance to be publicly reachable ?
A non-Render MySQL host is company that provides MySQL service that isn’t Render. Some examples off the top of my head are Amazon’s RDS or Aurora on AWS, or JawsDB. There are lots of MySQL providers in the world.
Render does not currently have an easy mechanism to make non-web applications publicly reachable.
Okay, but can I create for example JawsDB MySQL to use the API and the client part from the app which is hosted in Render ?
You would host MySQL via an external service provider. All application services would still be hosted on Render.
Alright, so they will can connect with no problem or I’m confused ?