Start mysql server from asp.net core web application.

Question

User-1204637165 posted

Dear All,

I have a web application running on a local area network that I built with asp.net core and mysql db.

I want to konw if it is possible for my web application to kick start mysql server anytime the application is visited.

The web applicaiton should also be able to check if the web server is turned off.

So incase the mysql server is off the web application can call a bat command to restart it.

Answer 1

User475983607 posted

I want to konw if it is possible for my web application to kick start mysql server anytime the application is visited.

Try to open a connection.  You'll get a connection exception if the service is not running. 

The web applicaiton should also be able to check if the web server is turned off.

You want the web server to check if MySql is installed but the service is not started?  I think you need MySQL support for this type of requirement.

https://dev.mysql.com/doc/refman/8.0/en/windows-start-command-line.html

 

Answer 2

User-1204637165 posted

Thanks so is it possible to trigger the command to start the ssql server if it is off or trigger a bat file that would start that command.

Answer 3

User-474980206 posted

you will need to detect you are currently starting the mysql app, so you don't try to start more than 1 at a time. you will also want to decide if the idle exit of the core app, should kill the mysql process. normally you would have a handle to it, that you should close on exit.

note: normally you'd run mysql as service, not a child process of the web server

Answer 4

User-1204637165 posted

Tank u bruce,

Normally when I want to start mysql I just put that command in the shell:startup folder of windows. So I create a run.bat file referencing the path to were mysqld.exe is located.

I kept my run.bat file in my startup folder of windows OS.

so when I boot the system mysql comes on immediately. Please is that sufficient ??????. if it is then maybe I should not bother running or starting from asp.net core.

Thanks alot.

Answer 5

User1120430333 posted

IMHO, what you are talking about is a little far fetched and probably not viable.

Answer 6

User-854763662 posted

>>so when I boot the system mysql comes on immediately. Please is that sufficient ??????. if it is then maybe I should not bother running or starting from asp.net core.

Have you already achieved start mysql from .net core application?

In my option, we should avoid starting and stopping service from .net core application which is not reasonable. The mysql application is independent, and we should control the service lifecycle by ourself.

.Net Core application should only connect and operate the database when mysql is available.

Best Regards,

Sherry

 

Answer 7

User753101303 posted

Hi,

Usually when you have a server whatever you need to be up and running is just launched at startup.

For Windows it seems they recommend installing MySQL as a service: https://dev.mysql.com/doc/refman/8.0/en/windows-start-service.html