Vertx Mysql Connection Pool initialization and query timeout

312 views
Skip to first unread message

Chandramouli Rangarajan

unread,
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:
https://groups.google.com/g/vertx/c/Z1FNdAwrmD8/m/43tGxyCSDgAJ
and
https://groups.google.com/g/vertx/c/Zvxl_KMFb9M/m/zhDudH_nBAAJ

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

unread,
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:
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?


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.

unread,
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

unread,
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.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?

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:
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?


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.

--
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.
Reply all
Reply to author
Forward
0 new messages