Re: slave to master

Am 29.04.2016 um 17:20 schrieb Mahmoud Alshinhab:
> Master/slave connection selection
>
> It’s the application that has to decide to use master or slave
> connection (the master connection is set by default).
> Switching the type of connection is done by using JDBC
> connection.setReadOnly(boolean readOnly)
> <http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#setReadOnly%28boolean%29>
> method. Setting read-only to true will use the slave connection, false,
> the master connection.
>
> [1]
> https://mariadb.com/kb/en/mariadb/failover-and-high-availability-with-mariadb-connector-j/
>
> So I think it is not implemented yet. as "the application has to decide
> to use master or slave connection (the master connection is set by
> default)."

so what's the benfit to use it?

https://mariadb.com/products/mariadb-maxscale/database-scaling

* Replication aware dynamic routing
* Query load balancing
* Client to database connection multiplexing

https://mariadb.com/products/mariadb-maxscale/minimize-maintenance-downtime

Whether you need to take a database node of a cluster out of service for 
maintenance or add a database node back to cluster, MaxScale?s load 
balance routing and monitoring plugins will assure that database traffic 
is always routed to database nodes in service without impacting the 
applications.

https://mariadb.com/products/mariadb-maxscale

MariaDB MaxScale is designed to hide the database setup complexity from 
the application so that the app still believes it connects to a single 
database instance but actually it connects to MariaDB MaxScale which 
sits on top of a growing MariaDB or MySQL database farm.

The concept of a data-centric proxy isn?t new, but MariaDB MaxScale is 
different because it leverages the deep server and parser knowledge of 
MariaDB to ensure that queries are processed in the exactly the same way 
inside MariaDB server. This makes it faster, more efficient and more 
transparent than any other database proxy on the market.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iEYEARECAAYFAlcjfQkACgkQhmBjz394AnmEwwCfVGyrytyd4qG7jil2KIT0qiJJ
pVAAn0xuXQ1HZhcoKC+iNQJeuonAkDfq
=aLUC
-----END PGP SIGNATURE-----