search

leokhoa / laragon

Laragon is a portable, isolated, fast & powerful universal development environment for PHP, Node.js, Python, Java, Go, Ruby. It is fast, lightweight, easy-to-use and easy-to-extend.
https://laragon.org
4.22k stars 355 forks source link

Multi MySQL Server Support #240

Open ImJacobChen opened 3 years ago

ImJacobChen commented 3 years ago

Hi there,

First of all thank you for building laragon. It has been extremely helpful for me over the past years.

Now, is it possible that support can be added to run multiple MySQL servers at the same time on different ports? I need this functionality for local development. Currently I run additional MySQL servers via windows command line alongside the laragon MySQL server but would love to have all servers in laragon.

If there is any way I can help bring this feature live please let me know.

Many thanks.

Jacob

bcs02123052 commented 3 years ago

Yeah it would be great if @leokhoa you can add multi MySQL support sometimes i have to work with MySQL 5.7 and sometimes i have to work with MySQL 8 I have to delete the MySQL data directory before switching

ImJacobChen commented 3 years ago

Yeah it would be great if @leokhoa you can add multi MySQL support sometimes i have to work with MySQL 5.7 and sometimes i have to work with MySQL 8 I have to delete the MySQL data directory before switching

Hey @bcs02123052, I think for your use case you would have the two directories such as

And also edit the my.ini for each installation to point to laragon/data/mysql57 & laragon/data/mysql8 respectively.

and then you can use Menu -> Mysql -> Version -> *The version you require*... Unless you want both versions running at the same time?

Which is kind of what I require. I require three separate instances running on separate ports at the same time

tharlab commented 3 years ago

my wish for a long time, with mariadb did it out of the box, but we need handle it carefully, switching the data can be disaster...

bcs02123052 commented 3 years ago

Yeah it would be great if @leokhoa you can add multi MySQL support sometimes i have to work with MySQL 5.7 and sometimes i have to work with MySQL 8 I have to delete the MySQL data directory before switching

Hey @bcs02123052, I think for your use case you would have the two directories such as

  • C:\laragon\bin\mysql\mysql-5.7.24-winx64
  • C:\laragon\bin\mysql\mysql-8.0.21-winx64

And also edit the my.ini for each installation to point to laragon/data/mysql57 & laragon/data/mysql8 respectively.

and then you can use Menu -> Mysql -> Version -> *The version you require*... Unless you want both versions running at the same time?

Which is kind of what I require. I require three separate instances running on separate ports at the same time

Thank you for this awesome trick 👍

JaservTECH commented 1 year ago

how about running mysql and maria db in same time with different port can laragon do this or maybe have another trick because i need 2 database server same time

borhanuddin commented 1 year ago

@JaservTECH MariaDB and MySQL have almost identical structure, you can put all your db in either MariaDB or MySQL

JaservTECH commented 1 year ago

Thanks bro, i have research yes its identical, option is maria or mysql , noted thanks bro ()

From: Borhanuddin Bin Haji Ahmad @.> Sent: Tuesday, October 11, 2022 3:01 PM To: leokhoa/laragon @.> Cc: Jafar Abdurrahman Albasyir @.>; Mention @.> Subject: Re: [leokhoa/laragon] Multi MySQL Server Support (#240)

@JaservTECHhttps://github.com/JaservTECH MariaDB and MySQL have almost identical structure, you can put all your db in either MariaDB or MySQL

— Reply to this email directly, view it on GitHubhttps://github.com/leokhoa/laragon/issues/240#issuecomment-1274258020, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AEOUDZCYIDNDAOOYV2D4LCTWCUND5ANCNFSM43ELZTNA. You are receiving this because you were mentioned.Message ID: @.***>

JaservTECH commented 3 weeks ago

Sorry for contacting you again bro but i have server using laragon but i need to know how passing parameter on laragon .ini I've upgrade my redis version using cygwin got problem on running cause laragon cannot found redis.conf I've research that need passing custom parameter still has error when launch from laragon · Issue #22 · redis-windows/redis-windows (github.com)https://github.com/redis-windows/redis-windows/issues/22 Unable to start redis built on cygwin from laragon · Issue #753 · leokhoa/laragon (github.com)https://github.com/leokhoa/laragon/issues/753

from

E:\Server\bin\redis\redis-x64-7.2.5\redis-server.exe E:\Server\bin\redis\redis-x64-7.2.5\redis.conf

to

E:\Server\bin\redis\redis-x64-7.2.5\redis-server.exe /cygdrive/E\Server\bin\redis\redis-x64-7.2.5\redis.conf

But on laragon.ini only got Version=..... QuickSetting=..... Use=....

Is there any way to add the command I know it can run by terminal or cmd directly but i hope i can easily just one click on start all service if it possible thanks bro

From: Jafar Abdurrahman Albasyir @.> Sent: Sunday, October 30, 2022 8:04 PM To: leokhoa/laragon @.> Subject: Re: [leokhoa/laragon] Multi MySQL Server Support (#240)

Thanks bro, i have research yes its identical, option is maria or mysql , noted thanks bro ()

From: Borhanuddin Bin Haji Ahmad @.> Sent: Tuesday, October 11, 2022 3:01 PM To: leokhoa/laragon @.> Cc: Jafar Abdurrahman Albasyir @.>; Mention @.> Subject: Re: [leokhoa/laragon] Multi MySQL Server Support (#240)

@JaservTECHhttps://github.com/JaservTECH MariaDB and MySQL have almost identical structure, you can put all your db in either MariaDB or MySQL

— Reply to this email directly, view it on GitHubhttps://github.com/leokhoa/laragon/issues/240#issuecomment-1274258020, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AEOUDZCYIDNDAOOYV2D4LCTWCUND5ANCNFSM43ELZTNA. You are receiving this because you were mentioned.Message ID: @.***>