Vertx Mysql Connection Pool initialization and query timeout
312 views
Skip to first unread message
Chandramouli Rangarajan
Dec 20, 2021, 7:16:16 PM12/20/21
to ve...@googlegroups.com
Hi, I had previous posted a couple of questions related to some vertx features here:
and
I had some questions based on our previous discussion:
1) You had mentioned that there was some plan to support a factory method for the pool in order to perform Connection initialization for every connection (similar to name:value pairs in jdbcURL for setting session variables). Is this supported yet?
2) For MySql pipelining, is the following: https://github.com/eclipse-vertx/vertx-sql-client/pull/875 going to be part of a future release?
3) When using the reactive MySql client, is there any option to set a per-query timeout/retry for reads? I didn't find any option to do that, but I was wondering if I can wrap the mysql query call within a vertx circuit breaker? What happens to the pending read query if the circuit breaker is triggered?
Thank you
--Chandramouli
Thomas SEGISMONT
Dec 21, 2021, 5:03:09 AM12/21/21
to ve...@googlegroups.com
Hi Chandramouli,
Le mar. 21 déc. 2021 à 01:16, Chandramouli Rangarajan <mahe...@gmail.com> a écrit :
Hi, I had previous posted a couple of questions related to some vertx features here:andI had some questions based on our previous discussion:1) You had mentioned that there was some plan to support a factory method for the pool in order to perform Connection initialization for every connection (similar to name:value pairs in jdbcURL for setting session variables). Is this supported yet?
Yes this is available already: https://vertx.io/docs/apidocs/io/vertx/mysqlclient/MySQLPool.html#connectHandler-io.vertx.core.Handler-
2) For MySql pipelining, is the following: https://github.com/eclipse-vertx/vertx-sql-client/pull/875 going to be part of a future release?
We'll do our best to make it land in 4.3.0
3) When using the reactive MySql client, is there any option to set a per-query timeout/retry for reads? I didn't find any option to do that, but I was wondering if I can wrap the mysql query call within a vertx circuit breaker? What happens to the pending read query if the circuit breaker is triggered?
The pending query result will be ignored, I think.
--Thank you----Chandramouli
You received this message because you are subscribed to the Google Groups "vert.x" group.
To unsubscribe from this group and stop receiving emails from it, send an email to vertx+un...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/vertx/CAJWMOKrh7G94Lc%2BXbVSua_yU5RAyxPUz%2BL1PqUzXvKCrgegMzQ%40mail.gmail.com.
Chandra R.
Dec 21, 2021, 6:45:56 PM12/21/21
to vert.x
1) https://vertx.io/docs/apidocs/io/vertx/mysqlclient/MySQLPool.html#connectHandler-io.vertx.core.Handler-
Thank you, I'll take a look at this.
2) https://github.com/eclipse-vertx/vertx-sql-client/pull/875 : We'll do our best to make it land in 4.3.0
Thanks!
3) vertx CircuitBreaker with Reactive mysql: The pending query result will be ignored, I think.
Got it, I will try this out.
I believe the CircuitBreaker doesn't cancel pending queries but instead retries and ignores "older" responses. Is that correct?
Thomas SEGISMONT
Dec 22, 2021, 5:35:18 AM12/22/21
to ve...@googlegroups.com
Le mer. 22 déc. 2021 à 00:46, Chandra R. <mahe...@gmail.com> a écrit :
1) https://vertx.io/docs/apidocs/io/vertx/mysqlclient/MySQLPool.html#connectHandler-io.vertx.core.Handler-Thank you, I'll take a look at this.2) https://github.com/eclipse-vertx/vertx-sql-client/pull/875 : We'll do our best to make it land in 4.3.0Thanks!3) vertx CircuitBreaker with Reactive mysql: The pending query result will be ignored, I think.Got it, I will try this out.I believe the CircuitBreaker doesn't cancel pending queries but instead retries and ignores "older" responses. Is that correct?
Yes
--On Tuesday, December 21, 2021 at 2:03:09 AM UTC-8 tsegi...@gmail.com wrote:Hi Chandramouli,Le mar. 21 déc. 2021 à 01:16, Chandramouli Rangarajan <mahe...@gmail.com> a écrit :Hi, I had previous posted a couple of questions related to some vertx features here:andI had some questions based on our previous discussion:1) You had mentioned that there was some plan to support a factory method for the pool in order to perform Connection initialization for every connection (similar to name:value pairs in jdbcURL for setting session variables). Is this supported yet?Yes this is available already: https://vertx.io/docs/apidocs/io/vertx/mysqlclient/MySQLPool.html#connectHandler-io.vertx.core.Handler-2) For MySql pipelining, is the following: https://github.com/eclipse-vertx/vertx-sql-client/pull/875 going to be part of a future release?We'll do our best to make it land in 4.3.03) When using the reactive MySql client, is there any option to set a per-query timeout/retry for reads? I didn't find any option to do that, but I was wondering if I can wrap the mysql query call within a vertx circuit breaker? What happens to the pending read query if the circuit breaker is triggered?The pending query result will be ignored, I think.--Thank you----Chandramouli
You received this message because you are subscribed to the Google Groups "vert.x" group.
To unsubscribe from this group and stop receiving emails from it, send an email to vertx+un...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/vertx/CAJWMOKrh7G94Lc%2BXbVSua_yU5RAyxPUz%2BL1PqUzXvKCrgegMzQ%40mail.gmail.com.
You received this message because you are subscribed to the Google Groups "vert.x" group.
To unsubscribe from this group and stop receiving emails from it, send an email to vertx+un...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/vertx/135e716e-abf6-4e43-b386-1b3f605c8f3an%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages