MilosZ at 09:09, 29 October 2021

2021-10-29T09:09:23Z

MilosZ: Created page with "Check if you are getting always Slave servers id in maxscale '''SELECT''': > SELECT @@server_id AS "Server ID"; 1. Create te..."

2021-10-29T09:09:02Z

Created page with "Check if you are getting always Slave servers id in maxscale '''SELECT''': <syntaxhighlight lang="MySQL"> > SELECT @@server_id AS "Server ID"; </syntaxhighlight> 1. Create te..."

New page

Check if you are getting always Slave servers id in maxscale '''SELECT''':
<syntaxhighlight lang="MySQL">
> SELECT @@server_id AS "Server ID";
</syntaxhighlight>

1. Create test database
<syntaxhighlight lang="MySQL">
CREATE TABLE test.readwrite_test (
id INT PRIMARY KEY AUTO_INCREMENT,
write_id INT
);
</syntaxhighlight>

2. Insert few values with server id's trough maxscale connection
<syntaxhighlight lang="MySQL">
INSERT INTO test.readwrite_test (write_id) VALUES (@@server_id);
INSERT INTO test.readwrite_test (write_id) VALUES (@@server_id);
INSERT INTO test.readwrite_test (write_id) VALUES (@@server_id);
</syntaxhighlight>

3. Check values from previous step and confirm that correct server id was used for '''INSERT''''s
<syntaxhighlight lang="MySQL">
SELECT readwrite.id AS "Primary Key",
current.id AS "Current Server ID",
readwrite.write_id AS "Stored Server ID"
FROM (
SELECT @@server_id AS id
) AS current
INNER JOIN (
SELECT id, write_id
FROM test.readwrite_test
) AS readwrite;

</syntaxhighlight>
<syntaxhighlight lang="MySQL">
+-------------+-------------------+------------------+
| Primary Key | Current Server ID | Stored Server ID |
+-------------+-------------------+------------------+
| 1 | 168103696 | 1078250471 |
| 2 | 168103696 | 1078250471 |
| 3 | 168103696 | 1078250471 |
+-------------+-------------------+------------------+
3 rows in set (0.01 sec)
</syntaxhighlight>

@@ Line 1: / Line 1: @@
 Check if you are getting always Slave servers id in maxscale '''SELECT''':
 <syntaxhighlight lang="MySQL">
-> SELECT @@server_id AS "Server ID";
+SELECT @@server_id AS "Server ID";
 </syntaxhighlight>
@@ Line 19: / Line 19: @@
 </syntaxhighlight>
-. Check values from previous step and confirm that correct server id was used for '''INSERT''''s
+. Check values from previous step and confirm that correct server id was used for '''INSERT'''
 <syntaxhighlight lang="MySQL">
 SELECT readwrite.id AS "Primary Key",

Test MariaDB MaxScale readwrite - Revision history

MilosZ at 09:09, 29 October 2021

MilosZ: Created page with "Check if you are getting always Slave servers id in maxscale '''SELECT''': > SELECT @@server_id AS "Server ID"; 1. Create te..."