On Wed, Jul 20, 2016 at 1:19 PM, Akila Ravihansa Perera <[email protected]> wrote:
> Hi Imesh, > > mysqladmin client need not be installed on host machine since Mesos will > run this command as a "docker run" command which will be executed inside > the container. MySQL official image contains mysqladmin tool so this is not > a problem. > I thought this was regarding the check we need to make before deploying the WSO2 server containers to wait until MySQL containers become ready. Thanks > Thanks. > > On Wed, Jul 20, 2016 at 12:46 PM, Imesh Gunaratne <[email protected]> wrote: > >> Hi Akila, >> >> On Mon, Jul 18, 2016 at 4:58 PM, Akila Ravihansa Perera < >> [email protected]> wrote: >> >>> Hi Imesh, >>> >>> I've switched to command based health check for MySQL services. It will >>> basically run "mysqladmin -u $MYSQL_USER -p$MYSQL_PASSWORD status". This >>> will ensure MySQL service is ready to serve SQL requests. >>> >> >> Wouldn't this make it mandatory to have mysqladmin client installed in >> the host machine where the deployment script is run? >> >> Thanks >> >> >>> >>> Thanks. >>> >>> On Mon, Jul 18, 2016 at 9:56 AM, Imesh Gunaratne <[email protected]> wrote: >>> >>>> >>>> >>>> On Thu, Jul 7, 2016 at 10:51 AM, Isuru Haththotuwa <[email protected]> >>>> wrote: >>>> >>>>> Hi, >>>>> >>>>> Yes, myself and Pubudu also faced this issue, lets fix it properly. >>>>> >>>>> On Wed, Jul 6, 2016 at 10:57 PM, Pubudu Gunatilaka <[email protected]> >>>>> wrote: >>>>> >>>>>> Hi Akila, >>>>>> >>>>>> Yes we faced several issues related to this. Apart from what you have >>>>>> mentioned, we encountered mysql app name is not getting resolved. This >>>>>> could be the delay in updating Mesos DNS. For these issues we looking >>>>>> into >>>>>> following options. >>>>>> >>>>>> *Option 1:* >>>>>> Use a sleep before deploying a carbon server. Not the best option. >>>>>> >>>>>> *Option 2:* >>>>>> Depend on the health status results. >>>>>> >>>>>> Currently, we do use a health check for mysql apps. Using dcos CLI we >>>>>> can check the status of the app whether the app is alive or not. But this >>>>>> cannot guarantee the DBs are ready to serve requests and Mesos DNS is >>>>>> updated. >>>>>> >>>>> >>>> >>>>> What if we query the Mesos DNS in addition to port checking to see if >>>>> its updated? AFAIR what we are seeing is an java.net.UnknownHostException, >>>>> related to the DB hostname. >>>>> >>>> >>>> May be we can wait for MySQL sockets as we do for Carbon server >>>> transports. >>>> >>>> Thanks >>>> >>>> -- >>>> *Imesh Gunaratne* >>>> Software Architect >>>> WSO2 Inc: http://wso2.com >>>> T: +94 11 214 5345 M: +94 77 374 2057 >>>> W: https://medium.com/@imesh TW: @imesh >>>> lean. enterprise. middleware >>>> >>>> >>>> _______________________________________________ >>>> Dev mailing list >>>> [email protected] >>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>> >>>> >>> >>> >>> -- >>> Akila Ravihansa Perera >>> WSO2 Inc.; http://wso2.com/ >>> >>> Blog: http://ravihansa3000.blogspot.com >>> >> >> >> >> -- >> *Imesh Gunaratne* >> Software Architect >> WSO2 Inc: http://wso2.com >> T: +94 11 214 5345 M: +94 77 374 2057 >> W: https://medium.com/@imesh TW: @imesh >> lean. enterprise. middleware >> >> > > > -- > Akila Ravihansa Perera > WSO2 Inc.; http://wso2.com/ > > Blog: http://ravihansa3000.blogspot.com > -- *Imesh Gunaratne* Software Architect WSO2 Inc: http://wso2.com T: +94 11 214 5345 M: +94 77 374 2057 W: https://medium.com/@imesh TW: @imesh lean. enterprise. middleware
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
