maria-developers team mailing list archive

[sriram patil <spsrirampatil@xxxxxxxxx>]

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
>>>
>>>
>>