MySQL Router 2.1  /  MySQL Router Frequently Asked Questions

Appendix A MySQL Router Frequently Asked Questions

A.1. Where do I install MySQL Router?
A.2. Can I run more than one instance of the router application?
A.3. How do I make the router application highly available?
A.4. Does the router inspect packets?
A.5. Does the router impact performance?
A.6. Can I bind the router to multiple IP addresses?
A.7. What is the difference between round-robin and first-available scheduling modes?
A.8. How many concurrent connections does each MySQL Router instance support?

A.1.

Where do I install MySQL Router?

For best performance, MySQL Router is typically installed on the same host as the application that uses it. Doing so can decrease network latency, allow a local unix domain socket connection to the application instead of TCP/IP, and typically application server's are easiest to scale. But, this is not a requirement as Router can be installed on any host, even its own.

Note: Unix domain sockets can function with applications connecting to MySQL Router, but not for MySQL Router connecting to a MySQL Server.

A.2.

Can I run more than one instance of the router application?

Yes, see also the --directory bootstrap option.

A.3.

How do I make the router application highly available?

Use MySQL Router as part of InnoDB cluster. For additional details, see InnoDB Cluster.

A.4.

Does the router inspect packets?

No.

A.5.

Does the router impact performance?

Whenever you introduce a component in a communication stream there will be a certain amount of overhead incurred and is affected heavily by workload. Fortunately, performance testing on the current release has shown approximately 1% within the same speed as a direct connection for simple redirect connection routing.

A.6.

Can I bind the router to multiple IP addresses?

No, the bind_address option in the configuration file accepts only one address. However, it is possible to use bind_addres = 0.0.0.0 to bind to all ports on the localhost.

A.7.

What is the difference between round-robin and first-available scheduling modes?

Round-robin differs from first-available in that it will cycle through the list of servers specified in the destinations option in a circular manner retrying servers that may have failed previously while first-available will stop once it reaches the end of the list.

Round-robin scheduling is enabled by using the read-only mode and first-available scheduling is enabled by using the read-write mode.

A.8.

How many concurrent connections does each MySQL Router instance support?

Currently just over 500 due to our internal use of select().


PREV   HOME   UP  
User Comments
Sign Up Login You must be logged in to post a comment.