[Maria-developers] [GSoC'15] Running MaxScale and MariaDB servers on single machine
Hi All, I tried running 2 MariaDB servers and MaxScale on my laptop. I gave different configurations to both MariaDB servers with separate data and log directories. Referred this <http://www.ducea.com/2009/01/19/running-multiple-instances-of-mysql-on-the-same-machine/> for it. Also have set up MaxScale from "MaxScale for rest of us" series on MariaDB blog. 1. https://mariadb.com/blog/maxscale-rest-us-part-1 2. https://mariadb.com/blog/maxscale-rest-us-part-2 3. https://mariadb.com/blog/maxscale-rest-us-part-3 4. https://mariadb.com/blog/maxscale-rest-us-part-4 So, i tried to set up the readwritesplit router with 1 master and 1 slave. Here, the replication mechanism worked fine but the queries are always executed on the master server. Example output for a read query: mysql -h localhost -u maxuser -p test -e "select c1, @@server_id from t1" Enter password: +------+-------------+ | c1 | @@server_id | +------+-------------+ | 1 | 1 | +------+-------------+ server_id for master is 1 whereas for slave it is 11, which is never displayed in the output. Can someone help me with this? Should I try the same config with one more slave? Are there any better resources for setting up MaxScale? Thanks, Sriram
Hi, The first step would be to inspect the state the servers are in. The easiest way to do is to use the maxadmin interface. To enable this, configure the following into MaxScale's config file [CLI] type=service router=cli [CLI Listener] type=listener service=CLI protocol=maxscaled port=6603 Executing the 'show servers' should give you a list of the servers and their states. If this doesn't give any clues the next step would be to enable MaxScale's tracelog. The log can be enabled by adding 'log_trace=1' under the [maxscale] section. Here you can see the routing logic of the router and the reasons why the queries are routed to the master. Markus On Tue, 2015-03-10 at 00:57 +0530, sriram patil wrote:
Hi All,
I tried running 2 MariaDB servers and MaxScale on my laptop. I gave different configurations to both MariaDB servers with separate data and log directories. Referred this for it.
Also have set up MaxScale from "MaxScale for rest of us" series on MariaDB blog. 1. https://mariadb.com/blog/maxscale-rest-us-part-1 2. https://mariadb.com/blog/maxscale-rest-us-part-2 3. https://mariadb.com/blog/maxscale-rest-us-part-3 4. https://mariadb.com/blog/maxscale-rest-us-part-4
So, i tried to set up the readwritesplit router with 1 master and 1 slave. Here, the replication mechanism worked fine but the queries are always executed on the master server.
Example output for a read query:
mysql -h localhost -u maxuser -p test -e "select c1, @@server_id from t1"
Enter password: +------+-------------+ | c1 | @@server_id | +------+-------------+ | 1 | 1 | +------+-------------+
server_id for master is 1 whereas for slave it is 11, which is never displayed in the output.
Can someone help me with this? Should I try the same config with one more slave? Are there any better resources for setting up MaxScale?
Thanks,
Sriram
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
-- Markus Mäkelä, Software Engineer MariaDB Corporation t: +358 40 7740484 | Skype: markus.j.makela
Hi Markus, I got an error. It says "Error : No Master can be determined". Here's how my config file looks like [maxscale] threads=1 log_trace=1 [srv1] type=server address=localhost port=3306 protocol=MySQLBackend [srv2] type=server address=localhost port=3307 protocol=MySQLBackend [MariaDB10 Monitor] type=monitor module=mysqlmon servers=srv1,srv2 user=maxmon passwd=maxpwd [RW Split Router] type=service router=readwritesplit servers=srv1,srv2 user=maxuser passwd=maxpwd [RW Split Listener] type=listener service=RW Split Router protocol=MySQLClient port=4006 [CLI] type=service router=cli [CLI listener] type=listener service=CLI protocol=maxscaled address=localhost port=6603 I have granted all privileges to "maxmon". Does it help in pin pointing the error? Thanks, Sriram On Tue, Mar 10, 2015 at 1:22 AM, Markus Mäkelä <markus.makela@mariadb.com> wrote:
Hi,
The first step would be to inspect the state the servers are in. The easiest way to do is to use the maxadmin interface. To enable this, configure the following into MaxScale's config file
[CLI] type=service router=cli
[CLI Listener] type=listener service=CLI protocol=maxscaled port=6603
Executing the 'show servers' should give you a list of the servers and their states. If this doesn't give any clues the next step would be to enable MaxScale's tracelog. The log can be enabled by adding 'log_trace=1' under the [maxscale] section. Here you can see the routing logic of the router and the reasons why the queries are routed to the master.
Markus
On Tue, 2015-03-10 at 00:57 +0530, sriram patil wrote:
Hi All,
I tried running 2 MariaDB servers and MaxScale on my laptop. I gave different configurations to both MariaDB servers with separate data and log directories. Referred this for it.
Also have set up MaxScale from "MaxScale for rest of us" series on MariaDB blog. 1. https://mariadb.com/blog/maxscale-rest-us-part-1 2. https://mariadb.com/blog/maxscale-rest-us-part-2 3. https://mariadb.com/blog/maxscale-rest-us-part-3 4. https://mariadb.com/blog/maxscale-rest-us-part-4
So, i tried to set up the readwritesplit router with 1 master and 1 slave. Here, the replication mechanism worked fine but the queries are always executed on the master server.
Example output for a read query:
mysql -h localhost -u maxuser -p test -e "select c1, @@server_id from t1"
Enter password: +------+-------------+ | c1 | @@server_id | +------+-------------+ | 1 | 1 | +------+-------------+
server_id for master is 1 whereas for slave it is 11, which is never displayed in the output.
Can someone help me with this? Should I try the same config with one more slave? Are there any better resources for setting up MaxScale?
Thanks,
Sriram
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
-- Markus Mäkelä, Software Engineer MariaDB Corporation t: +358 40 7740484 | Skype: markus.j.makela
Hi, Is the cluster set with replication? The readwritesplit needs at least one master and one slave to work. Using the maxadmin interface should verify this. The client binary can be found in the same folder as the maxscale binary. Default user name is admin and the password is skysql. Markus On Mar 9, 2015 10:29 PM, "sriram patil" <spsrirampatil@gmail.com> wrote:
Hi Markus,
I got an error. It says "Error : No Master can be determined".
Here's how my config file looks like
[maxscale] threads=1 log_trace=1
[srv1] type=server address=localhost port=3306 protocol=MySQLBackend
[srv2] type=server address=localhost port=3307 protocol=MySQLBackend
[MariaDB10 Monitor] type=monitor module=mysqlmon servers=srv1,srv2 user=maxmon passwd=maxpwd
[RW Split Router] type=service router=readwritesplit servers=srv1,srv2 user=maxuser passwd=maxpwd
[RW Split Listener] type=listener service=RW Split Router protocol=MySQLClient port=4006
[CLI] type=service router=cli
[CLI listener] type=listener service=CLI protocol=maxscaled address=localhost port=6603
I have granted all privileges to "maxmon". Does it help in pin pointing the error?
Thanks, Sriram
On Tue, Mar 10, 2015 at 1:22 AM, Markus Mäkelä <markus.makela@mariadb.com> wrote:
Hi,
The first step would be to inspect the state the servers are in. The easiest way to do is to use the maxadmin interface. To enable this, configure the following into MaxScale's config file
[CLI] type=service router=cli
[CLI Listener] type=listener service=CLI protocol=maxscaled port=6603
Executing the 'show servers' should give you a list of the servers and their states. If this doesn't give any clues the next step would be to enable MaxScale's tracelog. The log can be enabled by adding 'log_trace=1' under the [maxscale] section. Here you can see the routing logic of the router and the reasons why the queries are routed to the master.
Markus
On Tue, 2015-03-10 at 00:57 +0530, sriram patil wrote:
Hi All,
I tried running 2 MariaDB servers and MaxScale on my laptop. I gave different configurations to both MariaDB servers with separate data and log directories. Referred this for it.
Also have set up MaxScale from "MaxScale for rest of us" series on MariaDB blog. 1. https://mariadb.com/blog/maxscale-rest-us-part-1 2. https://mariadb.com/blog/maxscale-rest-us-part-2 3. https://mariadb.com/blog/maxscale-rest-us-part-3 4. https://mariadb.com/blog/maxscale-rest-us-part-4
So, i tried to set up the readwritesplit router with 1 master and 1 slave. Here, the replication mechanism worked fine but the queries are always executed on the master server.
Example output for a read query:
mysql -h localhost -u maxuser -p test -e "select c1, @@server_id from t1"
Enter password: +------+-------------+ | c1 | @@server_id | +------+-------------+ | 1 | 1 | +------+-------------+
server_id for master is 1 whereas for slave it is 11, which is never displayed in the output.
Can someone help me with this? Should I try the same config with one more slave? Are there any better resources for setting up MaxScale?
Thanks,
Sriram
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
-- Markus Mäkelä, Software Engineer MariaDB Corporation t: +358 40 7740484 | Skype: markus.j.makela
Hi, I have set up the replication. I have also confirmed that is works fine. The maxadmin also displays that there are two servers. But, Master ID = -1. Here's the output from maxadmin "show servers" Server 0x39c3520 (srv1) Server: localhost Status: Running Protocol: MySQLBackend Port: 3306 Server Version: 5.5.41-MariaDB-1ubuntu0.14.04.1 Node Id: 0 Master Id: -1 Slave Ids: Repl Depth: -1 Number of connections: 0 Current no. of conns: 0 Current no. of operations:0 Server 0x39c3410 (srv2) Server: localhost Status: Running Protocol: MySQLBackend Port: 3307 Server Version: 5.5.41-MariaDB-1ubuntu0.14.04.1 Node Id: 0 Master Id: -1 Slave Ids: Repl Depth: -1 Number of connections:0 Current no. of conns: 0 Current no. of operations:0 "show monitors" Name: MariaDB10 Monitor Monitor running Sampling interval: 10000 milliseconds MaxScale MonitorId: 77358052 Replication lag: disabled Detect Stale Master: disabled Connect Timeout: 3 seconds Read Timeout: 1 seconds Write Timeout: 2 seconds Monitored servers: localhost:3306, localhost:3307 I will try to set this up from the beginning again, let's see if I have any luck this time. Thanks, Sriram On Tue, Mar 10, 2015 at 2:05 AM, Markus Mäkelä <markus.makela@mariadb.com> wrote:
Hi,
Is the cluster set with replication? The readwritesplit needs at least one master and one slave to work. Using the maxadmin interface should verify this. The client binary can be found in the same folder as the maxscale binary. Default user name is admin and the password is skysql.
Markus On Mar 9, 2015 10:29 PM, "sriram patil" <spsrirampatil@gmail.com> wrote:
Hi Markus,
I got an error. It says "Error : No Master can be determined".
Here's how my config file looks like
[maxscale] threads=1 log_trace=1
[srv1] type=server address=localhost port=3306 protocol=MySQLBackend
[srv2] type=server address=localhost port=3307 protocol=MySQLBackend
[MariaDB10 Monitor] type=monitor module=mysqlmon servers=srv1,srv2 user=maxmon passwd=maxpwd
[RW Split Router] type=service router=readwritesplit servers=srv1,srv2 user=maxuser passwd=maxpwd
[RW Split Listener] type=listener service=RW Split Router protocol=MySQLClient port=4006
[CLI] type=service router=cli
[CLI listener] type=listener service=CLI protocol=maxscaled address=localhost port=6603
I have granted all privileges to "maxmon". Does it help in pin pointing the error?
Thanks, Sriram
On Tue, Mar 10, 2015 at 1:22 AM, Markus Mäkelä <markus.makela@mariadb.com
wrote:
Hi,
The first step would be to inspect the state the servers are in. The easiest way to do is to use the maxadmin interface. To enable this, configure the following into MaxScale's config file
[CLI] type=service router=cli
[CLI Listener] type=listener service=CLI protocol=maxscaled port=6603
Executing the 'show servers' should give you a list of the servers and their states. If this doesn't give any clues the next step would be to enable MaxScale's tracelog. The log can be enabled by adding 'log_trace=1' under the [maxscale] section. Here you can see the routing logic of the router and the reasons why the queries are routed to the master.
Markus
On Tue, 2015-03-10 at 00:57 +0530, sriram patil wrote:
Hi All,
I tried running 2 MariaDB servers and MaxScale on my laptop. I gave different configurations to both MariaDB servers with separate data and log directories. Referred this for it.
Also have set up MaxScale from "MaxScale for rest of us" series on MariaDB blog. 1. https://mariadb.com/blog/maxscale-rest-us-part-1 2. https://mariadb.com/blog/maxscale-rest-us-part-2 3. https://mariadb.com/blog/maxscale-rest-us-part-3 4. https://mariadb.com/blog/maxscale-rest-us-part-4
So, i tried to set up the readwritesplit router with 1 master and 1 slave. Here, the replication mechanism worked fine but the queries are always executed on the master server.
Example output for a read query:
mysql -h localhost -u maxuser -p test -e "select c1, @@server_id from t1"
Enter password: +------+-------------+ | c1 | @@server_id | +------+-------------+ | 1 | 1 | +------+-------------+
server_id for master is 1 whereas for slave it is 11, which is never displayed in the output.
Can someone help me with this? Should I try the same config with one more slave? Are there any better resources for setting up MaxScale?
Thanks,
Sriram
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
-- Markus Mäkelä, Software Engineer MariaDB Corporation t: +358 40 7740484 | Skype: markus.j.makela
That does look like a proper configuration of MaxScale. I hope this is just a small issue with your setup and that you will get it fixed. I'll take a closer look at the way the tutorial configures the servers. Markus On Mar 9, 2015 10:47 PM, "sriram patil" <spsrirampatil@gmail.com> wrote:
Hi,
I have set up the replication. I have also confirmed that is works fine. The maxadmin also displays that there are two servers. But, Master ID = -1. Here's the output from maxadmin
"show servers" Server 0x39c3520 (srv1) Server: localhost Status: Running Protocol: MySQLBackend Port: 3306 Server Version: 5.5.41-MariaDB-1ubuntu0.14.04.1 Node Id: 0 Master Id: -1 Slave Ids: Repl Depth: -1 Number of connections: 0 Current no. of conns: 0 Current no. of operations:0 Server 0x39c3410 (srv2) Server: localhost Status: Running Protocol: MySQLBackend Port: 3307 Server Version: 5.5.41-MariaDB-1ubuntu0.14.04.1 Node Id: 0 Master Id: -1 Slave Ids: Repl Depth: -1 Number of connections:0 Current no. of conns: 0 Current no. of operations:0
"show monitors" Name: MariaDB10 Monitor Monitor running Sampling interval: 10000 milliseconds MaxScale MonitorId: 77358052 Replication lag: disabled Detect Stale Master: disabled Connect Timeout: 3 seconds Read Timeout: 1 seconds Write Timeout: 2 seconds Monitored servers: localhost:3306, localhost:3307
I will try to set this up from the beginning again, let's see if I have any luck this time.
Thanks, Sriram
On Tue, Mar 10, 2015 at 2:05 AM, Markus Mäkelä <markus.makela@mariadb.com> wrote:
Hi,
Is the cluster set with replication? The readwritesplit needs at least one master and one slave to work. Using the maxadmin interface should verify this. The client binary can be found in the same folder as the maxscale binary. Default user name is admin and the password is skysql.
Markus On Mar 9, 2015 10:29 PM, "sriram patil" <spsrirampatil@gmail.com> wrote:
Hi Markus,
I got an error. It says "Error : No Master can be determined".
Here's how my config file looks like
[maxscale] threads=1 log_trace=1
[srv1] type=server address=localhost port=3306 protocol=MySQLBackend
[srv2] type=server address=localhost port=3307 protocol=MySQLBackend
[MariaDB10 Monitor] type=monitor module=mysqlmon servers=srv1,srv2 user=maxmon passwd=maxpwd
[RW Split Router] type=service router=readwritesplit servers=srv1,srv2 user=maxuser passwd=maxpwd
[RW Split Listener] type=listener service=RW Split Router protocol=MySQLClient port=4006
[CLI] type=service router=cli
[CLI listener] type=listener service=CLI protocol=maxscaled address=localhost port=6603
I have granted all privileges to "maxmon". Does it help in pin pointing the error?
Thanks, Sriram
On Tue, Mar 10, 2015 at 1:22 AM, Markus Mäkelä < markus.makela@mariadb.com> wrote:
Hi,
The first step would be to inspect the state the servers are in. The easiest way to do is to use the maxadmin interface. To enable this, configure the following into MaxScale's config file
[CLI] type=service router=cli
[CLI Listener] type=listener service=CLI protocol=maxscaled port=6603
Executing the 'show servers' should give you a list of the servers and their states. If this doesn't give any clues the next step would be to enable MaxScale's tracelog. The log can be enabled by adding 'log_trace=1' under the [maxscale] section. Here you can see the routing logic of the router and the reasons why the queries are routed to the master.
Markus
On Tue, 2015-03-10 at 00:57 +0530, sriram patil wrote:
Hi All,
I tried running 2 MariaDB servers and MaxScale on my laptop. I gave different configurations to both MariaDB servers with separate data and log directories. Referred this for it.
Also have set up MaxScale from "MaxScale for rest of us" series on MariaDB blog. 1. https://mariadb.com/blog/maxscale-rest-us-part-1 2. https://mariadb.com/blog/maxscale-rest-us-part-2 3. https://mariadb.com/blog/maxscale-rest-us-part-3 4. https://mariadb.com/blog/maxscale-rest-us-part-4
So, i tried to set up the readwritesplit router with 1 master and 1 slave. Here, the replication mechanism worked fine but the queries are always executed on the master server.
Example output for a read query:
mysql -h localhost -u maxuser -p test -e "select c1, @@server_id from t1"
Enter password: +------+-------------+ | c1 | @@server_id | +------+-------------+ | 1 | 1 | +------+-------------+
server_id for master is 1 whereas for slave it is 11, which is never displayed in the output.
Can someone help me with this? Should I try the same config with one more slave? Are there any better resources for setting up MaxScale?
Thanks,
Sriram
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
-- Markus Mäkelä, Software Engineer MariaDB Corporation t: +358 40 7740484 | Skype: markus.j.makela
participants (2)
-
Markus Mäkelä -
sriram patil