Switch to mariadb java connector
Closed, DeclinedPublic
Actions

Assigned To

None

Authored By

	Paladox
	Sep 18 2017, 6:45 PM

Description

we should switch to the mariadb java connector.

Reason is we use a mariadb database so by using a mariadb java connector we may improve performance or better support for mariadb features.

It’s also better maintained and also supports session based variables.

we can use it like

type = mariadb
hostname = <ip>
database = <db>
username = <username>
url = jdbc:mariadb://<ip>/<db>?sessionVariables=character_set_client=utf8,character_set_results=utf8,character_set_connection=utf8,collation_connection=utf8_unicode_ci,collation_database=utf8_unicode_ci,collation_server=utf8_unicode_ci

Details

	Subject	Repo	Branch	Lines +/-
	Gerrit: Switch to the mariadb connector	operations/puppet	production	+2 -2

Customize query in gerrit

Event Timeline

Paladox created this task.Sep 18 2017, 6:45 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSep 18 2017, 6:45 PM

• demon triaged this task as Low priority.Sep 18 2017, 6:50 PM

Removed the DBA project, but will remain subscribed just in case something is needed from us.

Paladox updated the task description. (Show Details)Oct 1 2017, 6:24 PM

One more reason to switch from mysql connector to mariadb connector is that in 2.15 it updated mysql connector to 6.0.6 which seems to be causing upgrades to fail (regression). Whereas mariadb connector is fine. I suggest we go with something stable here as mariadb gets more updates then the mysql one, leading to less bugs :).

mysql connector java 6.x is broken and it seems the connector is just unstable. I recommended upstream to recommend others to use the mariadb connector.

Change 384588 had a related patch set uploaded (by Paladox; owner: Paladox):
[operations/puppet@production] Gerrit: Switch to the mariadb connector

https://gerrit.wikimedia.org/r/384588

gerritbot added a project: Patch-For-Review.Oct 16 2017, 7:46 PM

Change 384588 had a related patch set uploaded (by Paladox; owner: Paladox):
[operations/puppet@production] Gerrit: Switch to the mariadb connector

https://gerrit.wikimedia.org/r/384588

@demon should we try doing this? :)

Paladox renamed this task from Switch to mariadb java connector once we upgrade to gerrit 2.14 to Switch to mariadb java connector.Apr 1 2018, 2:28 AM

Paladox raised the priority of this task from Low to Medium.

Paladox updated the task description. (Show Details)

Paladox added a project: DBA.Apr 4 2018, 9:45 PM

Hi,

What would you need from the DBAs?

Hi, we only need dba ok to do this (it requires dba approval because it’s touching dba related stuff) ie replacing a MySQL driver with a mariadb one.

I don't think this needs any DBA approval, as we are not responsible of how you connect to the DB itself ;-)

I think we can just decline this. NoteDB works around the problem and the underlying bug leading to this has gone away too.

Yep, in 2.16 / 3.0 groups will be migrated to notedb so only one last piece would be using the db (which i forget which one)

Change 384588 abandoned by Paladox:
Gerrit: Switch to the mariadb connector

Reason:
We will be upgrading to 2.16 very soon so no longer needed, I'm removing db support in https://gerrit.wikimedia.org/r/488093

https://gerrit.wikimedia.org/r/384588

Switch to mariadb java connectorClosed, DeclinedPublicActions

Description

Details

Event Timeline

Switch to mariadb java connector
Closed, DeclinedPublic
Actions