maria-developers team mailing list archive

[sriram patil <spsrirampatil@xxxxxxxxx>]

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