206 Commits

Author SHA1 Message Date
Markus Mäkelä
5724338959
MXS-3892: Document the change in behavior
It is worth documenting this change as the amount of queries done by
MaxScale is likely to decrease by a significant amount. This change can
also have a negative effect on the worst-case delay of the database
mapping but this isn't really a practical problem.
2021-12-31 15:25:18 +02:00
Markus Mäkelä
1185098e41
MXS-3836: Document refresh_databases "behavior"
The fact that the parameter does nothing in 2.4 and newer versions is now
at least documented. Fixing it this late in 2.4 could result in unwanted
changes in behavior.
2021-11-10 15:30:24 +02:00
Markus Mäkelä
27a43fdf9d
Merge branch '2.3' into 2.4 2020-12-11 16:38:43 +02:00
Markus Mäkelä
e3aff8babe
MXS-3314: Document causal_reads limitations
Also documented the fact that CCRFilter doesn't support prepared
statements.
2020-12-11 16:34:08 +02:00
Markus Mäkelä
4a2831e731
Clarify transaction_replay documentation
The parameter controls three other parameters and overrides their
configured values.
2020-12-09 12:24:27 +02:00
Markus Mäkelä
caedf79464
Merge branch '2.3' into 2.4 2020-08-28 14:24:16 +03:00
Markus Mäkelä
ebdb9655e6
MXS-3143: Route FOUND_ROWS to last used target
This will cause the query to be routed to the same server where a possible
SQL_CALC_FOUND_ROWS was executed.
2020-08-28 11:49:07 +03:00
Markus Mäkelä
727aeb4a08
Merge branch '2.3' into 2.4 2020-06-02 10:53:05 +03:00
Markus Mäkelä
11960a1e93
Document transaction_replay_max_size inner workings
The documentation didn't explain how to estimate how much memory a
transaction takes and whether it was a global limit or a per session
limit.
2020-06-02 10:17:39 +03:00
Markus Mäkelä
6cc16ac16b
Document idle session behavior with fail_on_write
The behavior is not very obvious. To prevent excessive numbers of idle
sessions, a idle timeout should be configured.
2020-05-25 10:27:52 +03:00
Markus Mäkelä
7b4d26e26a
Document prepared statement tmp table limitation
Also moved the transaction replay limitations to the limitations section.
2020-05-13 13:48:22 +03:00
Markus Mäkelä
927db1fc6e
Clarify master_accept_reads 2020-04-09 11:48:46 +03:00
Markus Mäkelä
c1fc7bd742
Document avrorouter diagnostic output 2020-02-18 14:26:29 +02:00
Markus Mäkelä
be508fe5d9
MXS-2873: Document more router diagnostics
Documented readconnroute and schemarouter router diagnostics. The
duplicated fields that are already in the general service diagnostic
output are not documented with the hopes that they can be eventually
removed.
2020-02-18 09:45:02 +02:00
Markus Mäkelä
2bc2ab2196
MXS-2873: Document readwritesplit router diagnostics
The REST API output is now documented in the router documentation. The
same will be done for other routers as well.
2020-02-18 09:23:13 +02:00
Markus Mäkelä
6c14ac7829
MXS-2834: Make retrying of trx deadlocks configurable
The behavior is not desirable in all cases and should be enabled only if
needed.
2020-01-11 11:53:01 +02:00
Markus Mäkelä
08aba4b3c9
MXS-2498: Document temp tables in multi-statments
When a temporary table is created with a multi-statement query, it won't
be detected by MaxScale.

Also removed the wrong limitations section from the document.
2019-12-19 08:53:32 +02:00
Markus Mäkelä
9dceff7d9d
Merge branch '2.3' into 2.4 2019-12-03 10:05:34 +02:00
Markus Mäkelä
1e57c2cb67
MXS-2643: Mention Galera in causal_reads documentation
causal_reads does not work with servers that update their state via
mechanisms other than the standard replication. In practice this is just
another Galera limitation.
2019-12-03 09:58:23 +02:00
Markus Mäkelä
2a93d86f1a
MXS-2655 Document session command limitation 2019-09-04 15:40:52 +03:00
Markus Mäkelä
0261b65529
Fix avrorouter parameters
The two new parameters weren't documented and `server_id` used the wrong
type.
2019-07-05 14:12:59 +03:00
Markus Mäkelä
25c6713162
MXS-2577: Document avrorouter direct replication mode
A new section in the avrorouter documentation provides the necessary
information to configure the avrorouter for direct replication from a
server.
2019-06-26 10:21:26 +03:00
Niclas Antti
3cb05813a0 MXS-2555 Add SmartRouter documentation 2019-06-24 14:54:06 +03:00
Marko
ba13692032 MXS-2477 Extend the example to show more use cases 2019-06-02 19:20:35 +03:00
Marko
af92fef510 MXS-2477 Update schemarouter documentation 2019-05-21 13:57:32 +03:00
Esa Korhonen
0af1f6e690 Merge branch '2.3' into develop 2019-05-21 11:18:40 +03:00
Esa Korhonen
bb706394f6 MXS-2473 Simplify regular expression settings documentation
The settings "match", "exclude" and "options" are now explained once
in the general documentation. The individual filter documentation refers
to the general explanation.
2019-05-20 11:18:03 +03:00
Markus Mäkelä
29e5af1ded
Move router limitations to router documentation
This way the limitations are easier to find and are consistent across the
modules.
2019-05-17 14:44:49 +03:00
Markus Mäkelä
24ca503b0f
Document transaction_replay_attempts
Also added the new readwritesplit parameters to the 2.4.0 release notes.
2019-05-17 14:44:12 +03:00
Markus Mäkelä
0d13e694e4
Merge branch '2.3' into develop 2019-05-10 09:28:39 +03:00
Johan Wikman
034dc6a67e MXS-2472 Update BLR docs on secondary masters 2019-05-09 17:14:57 +03:00
Johan Wikman
aa3057695b MXS-2329 Use durations in schema router 2019-04-30 13:02:53 +03:00
Johan Wikman
ea243fd8ba MXS-2329 Use durations in readwritesplit 2019-04-30 13:02:53 +03:00
Johan Wikman
0f5972e010 MXS-2329 Use durations with BLR:[heartbeat|connect_retry] 2019-04-30 13:02:53 +03:00
Markus Mäkelä
810dc06d5c
Document removal of ndbclustermon and mmmon 2019-04-24 14:06:27 +03:00
Markus Mäkelä
88a9ca8b68
Document removal of debugcli and telnetd 2019-04-24 14:01:31 +03:00
Markus Mäkelä
f812302d62
Document readwritesplit behavior with server states 2019-04-04 13:00:35 +03:00
Markus Mäkelä
e659c6cc73
Merge branch '2.3' into develop 2019-04-01 13:24:30 +03:00
Markus Mäkelä
3977207d12
Update transaction_replay documentation
Removed the confusing paragraph.
2019-03-29 14:23:15 +02:00
Markus Mäkelä
4f8d6d1853
Fix transaction_replay documentation
The documentation stated that MVCC reads weren't safe with
transaction_replay when in reality they are not safe in general and
transaction_replay has no effect on it.
2019-03-29 10:35:41 +02:00
Esa Korhonen
841bdf4d0f Merge branch '2.3' into develop 2019-03-28 15:33:09 +02:00
Markus Mäkelä
6bc2c54081
Merge commit 'a78f0fbe2537542dc7f3f0dd8b19b93ac8d9d7f8' into develop 2019-03-28 13:53:40 +02:00
Esa Korhonen
c4b82b7d83 MXS-2359 Route statements with database but no table dependence
Queries such as SHOW TABLES FROM db1 are now routed to the backend with db1.
This gives the correct result as long as db1 is not sharded to multiple
backends.
2019-03-27 13:46:36 +02:00
Esa Korhonen
ee88180c54 MXS-2409 Check that prepared statement exists
If the PREPARE is malformed, the extracted statement is null.
2019-03-27 13:46:36 +02:00
Esa Korhonen
c6ce4c2234 MXS-2359 Update schemarouter documentation
Moved limitations to the router documentation. Documented which queries get
exceptional handling.
2019-03-27 10:30:29 +02:00
Markus Mäkelä
9ddd186550
MXS-2313: Update rank documentation
Updated the value types, added a simpler example and created a separate
section in readwritesplit documentation on the behavior of ranked servers.
2019-03-18 13:12:59 +02:00
Esa Korhonen
f05a2317d9 Merge branch '2.3' into develop 2019-03-12 11:22:34 +02:00
Esa Korhonen
b4c5500fa1 MXS-2362 Document SchemaRouter table-sharding limitations 2019-03-11 17:39:07 +02:00
Markus Mäkelä
24ea222ed6
MXS-2350: Allow lazy connection creation
The lazy connection creation reduces the burden that short sessions place
on the backend servers. This also prevents the problems caused by early
disconnections that happen when only one server is used but multiple
connections are created. This does not solve the problem (MXS-619) but it
does mitigate it to acceptable levels.

This commit also adds a change to the weighting algorithm that prefers
existing connections over unopened ones. This helps avoid the
flip-flopping that happens when the absolute scores are very similar. The
hard-coded value might need to be tuned once testing is done.
2019-03-08 08:20:44 +02:00
Markus Mäkelä
3a40faf77d
MXS-2288: Document source parameter behavior 2019-02-06 12:11:06 +02:00