[JIRA] Created: (MYO-103) Allow for user's to do 'selective read/write splitting' by embedding SQL-Router url properties inside of a query

Discussion:

Edward Archibald (JIRA)

2009-08-14 14:15:46 UTC

Permalink

Allow for user's to do 'selective read/write splitting' by embedding SQL-Router url properties inside of a query
----------------------------------------------------------------------------------------------------------------

Key: MYO-103
URL: https://forge.continuent.org/jira/browse/MYO-103
Project: Tungsten Connector
Type: New Feature

Components: Configuration
Reporter: Edward Archibald
Assigned to: Edward Archibald

User's who want to use read/write splitting but who can't easily allocate separate connection pools, or who cannot just send all reads to a slave, need to be able to selectively router specific queries to a slave. This can easily be done by having the user embed a comment with a specific marker inside of an SQL statement.

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://forge.continuent.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira

Gilles Rayrat (JIRA)

2009-08-14 15:51:46 UTC

Permalink

[ https://forge.continuent.org/jira/browse/MYO-103?page=comments#action_15700 ]

Gilles Rayrat commented on MYO-103:
-----------------------------------

Hi Ed,
Can I transform your EmbeddedPropertyProcessor#main into a junit test case so it gets run by cruise control?
Also, I think we can remove the code from MYO-89 (tungsten commands). It's not exactly the same behavior but I'm not sure there's a need for switching qos permanently. What do you think?
Cheers,
Gilles.

Post by Edward Archibald (JIRA)
Allow for user's to do 'selective read/write splitting' by embedding SQL-Router url properties inside of a query
----------------------------------------------------------------------------------------------------------------
Key: MYO-103
URL: https://forge.continuent.org/jira/browse/MYO-103
Project: Tungsten Connector
Type: New Feature
Components: Configuration
Reporter: Edward Archibald
Assignee: Edward Archibald
User's who want to use read/write splitting but who can't easily allocate separate connection pools, or who cannot just send all reads to a slave, need to be able to selectively router specific queries to a slave. This can easily be done by having the user embed a comment with a specific marker inside of an SQL statement.

Gilles Rayrat (JIRA)

2009-08-14 18:05:46 UTC

Permalink

[ https://forge.continuent.org/jira/browse/MYO-103?page=comments#action_15701 ]

Gilles Rayrat commented on MYO-103:
-----------------------------------

Test case commited
3 bugs fixed (see revision 639, forgot to add bug reference)

Gilles Rayrat (JIRA)

2010-02-08 18:37:46 UTC

Permalink

[ https://forge.continuent.org/jira/browse/MYO-103?page=all ]

Gilles Rayrat closed MYO-103:
-----------------------------

Resolution: Fixed

EmbeddedPropertyProcessor tests transfered into EmbeddedPropertyProcessorTestCase
MYO-89 feature stays in since it forces the QoS until another marker is found, whereas this only forces the QoS on the query that's on the same line

Post by Edward Archibald (JIRA)
Allow for user's to do 'selective read/write splitting' by embedding SQL-Router url properties inside of a query
----------------------------------------------------------------------------------------------------------------
Key: MYO-103
URL: https://forge.continuent.org/jira/browse/MYO-103
Project: Tungsten Connector
Type: New Feature
Components: Configuration
Reporter: Edward Archibald
Assignee: Edward Archibald
Fix For: 0.6.8
User's who want to use read/write splitting but who can't easily allocate separate connection pools, or who cannot just send all reads to a slave, need to be able to selectively router specific queries to a slave. This can easily be done by having the user embed a comment with a specific marker inside of an SQL statement.