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.mak...@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" <spsrirampa...@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.mak...@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
>>>
>>>
>>
_______________________________________________
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
