[Maria-discuss] ask tool mariadb auto update latest for windows
hi,i have 5-15 pc as server using mariadb.i always copy and update latest release one by one to server.is there any tool to download, stop service and extract update my mariadb in windows.maybe some one know it thanks b4
Am 13.05.2016 um 19:20 schrieb Irwanto:
hi, i have 5-15 pc as server using mariadb. i always copy and update latest release one by one to server. is there any tool to download, stop service and extract update my mariadb in windows. maybe some one know it
not that i know
just use a proper operating system for a large amount of servers where you can script package-updates - linux distributions typically do the restart after update apckages automatically (while i build my own packages because i decide when to restart which is not always the same point of time where i deploy updates)
You can most easily automate it by writing a shell script using Cygwin.
Hint: The NET SERVICE command can stop and start services.
Sent from my iPhone
On May 13, 2016, at 9:17 PM, Reindl Harald h.reindl@thelounge.net wrote:
Am 13.05.2016 um 19:20 schrieb Irwanto: hi, i have 5-15 pc as server using mariadb. i always copy and update latest release one by one to server. is there any tool to download, stop service and extract update my mariadb in windows. maybe some one know it
not that i know
just use a proper operating system for a large amount of servers where you can script package-updates - linux distributions typically do the restart after update apckages automatically (while i build my own packages because i decide when to restart which is not always the same point of time where i deploy updates)
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
If you're using MSIs, It is possible. You can install /upgrade MariaDB on a remote servers, e.g by using psexec (remoting tool from sysinternals) that runs msiexec in quiet mode
The whole command I used to install 10.1.13 and later upgrade to 10.1.14 psexec \remote-box-address -u<admin_user_name_on_remote_box> -p <passwd> msiexec /i http://mirror.jmu.edu/pub/mariadb//mariadb-10.1.14/winx64-packages/mariadb-1... SERVICENAME=MariaDB /qn
- psexec is downloadable from here https://technet.microsoft.com/en-us/sysinternals/psexec.aspx - msiexec handles database shutdown before upgrade and restart after it - SERVICENAME parameter is used by MSI as indicator that service needs to be installed (used only by original installation, not by upgrade). You can add more parameters as described here https://mariadb.com/kb/en/mariadb/installing-mariadb-msi-packages-on-windows...
You'll need to figure out the nearest download mirror and the exact download URL. The exact download link on download page I got was https://downloads.mariadb.org/f/mariab-10.1.14/winx64-packages/mariadb-10.1.... , and this lead to couple of redirects, which msiexec, does not seem to handle well.
Good luck, Wlad
On 5/13/2016 7:20 PM, Irwanto wrote:
hi, i have 5-15 pc as server using mariadb. i always copy and update latest release one by one to server. is there any tool to download, stop service and extract update my mariadb in windows. maybe some one know it
thanks b4
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
participants (4)
-
Irwanto -
Justin Swanhart -
Reindl Harald -
Vladislav Vaintroub