geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dennis Cartier" <dennis.cart...@gmail.com>
Subject Re: Deploying clustered database pools under G2.1.X
Date Wed, 30 Jul 2008 13:04:28 GMT
Thanks for the tip on the Generic Tranql adapter. My temporary
workaround was to put the comma separated list of servers into the
server field (E.g. ServerA,ServerB) and append the MySQL parameters
onto the end of the database name (E.g.
MyDatabase?failOverReadOnly=false&autoReconnectForPools=true). This
was based on speculation on my part on how Tranql was assembling the
final JDBC connection URL. It deploys fine, and does work for a single
database, but I have yet to test the failover to make sure both
servers are being used.

As to if this is exposed in the MySQL datasource, it appears that you
can configure these by either appending to the driver URL, by passing
in a key/value pairs in a properties object when making the connection
or by using the set* methods on the java.sql.DataSource  when
implemented by the com.mysql.jdbc.jdbc2.optional.MysqlDataSource or
com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource classes.

Hope this helps to clear this up in the future.

Thanks,

Dennis

On Tue, Jul 29, 2008 at 6:20 PM, David Jencks <david_jencks@yahoo.com> wrote:
> Do you know if this can be configured on mysql datasources or just with a
> driver url?  Tranql now has Datasource based mysql adapters which provide
> more checkable configuration for the properties you can set on the
> datasource.  If clustering can be set on the datasource we should look into
> supporting it in tranql.
>
> If not, and meanwhile, you can deploy using the generic tranql adapter
> rather than the mysql specific one, just like you did in geronimo 1.x.  If
> you are using the console wizard just don't say you are using mysql -- I
> think there's an "other" -- and it should use the generic adapter.
>
> hope this helps
> david jencks
>
>
>
> On Jul 29, 2008, at 12:14 PM, Dennis Cartier wrote:
>
>> Upon trying both 2.1.1 and 2.1.3-SNAPSHOT I have been unable to figure
>> out how to deploy a clustered database pool. In past versions of
>> Geronimo the "JDBC Connect URL" field was exposed and for my database
>> (MySQL) I could directly edit this field to expose the databases to
>> Geronimo E.g
>> "jdbc:mysql://ServerA,ServerB/MyDatabase?failOverReadOnly=false&autoReconnectForPools=true".
>>
>> How does one do this under Geronimo 2.1.x? I tried creating a plan
>> with an added "<config-property-setting name="ConnectionURL">..."
>> section and deployed it from the command line but get the message:
>>
>>   Error: Unable to distribute tranql-connector-mysql-local-1.2.rar:
>>   The plan is trying to set attributes: [ConnectionURL]
>>
>> I tried this under the Release of 2.1.1 as well as the latest Snapshot
>> of 2.1.3 and both exhibit this behaviour. I get the impression that
>> G2.1.x has hidden all the 'complexity' of the constructed JDBC
>> connection URL behind a subset of fields, but for someone in my
>> position, this poses a problem.
>>
>> Thanks,
>>
>> Dennis
>
>



-- 
"It is impossible to design fool proof systems, because fools are so clever."

Authour unknown
--

"The music business is a cruel and shallow money trench, a long
plastic hallway where thieves and pimps run free, and good men die
like dogs. There's also a negative side. "

Hunter S. Thompson, US journalist (1939 – 2005)

Mime
View raw message