maria-developers team mailing list archive

[Markus Mäkelä <markus.makela@xxxxxxxxxxx>]

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@xxxxxxxxx> 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@xxxxxxxxxxx>
> 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@xxxxxxxxx> 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@xxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>>>> > 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
>>>>
>>>>
>>>
>