here<\/b><\/a><\/span><\/p>\n[MySQL Monitor]\r\ntype=monitor\r\nmodule=mysqlmon\r\nservers=Production-DB, Archive-DB\r\nuser=maxscaleuser\r\npasswd=maxscaleuserpassword\r\nmonitor_interval=5000<\/pre>\nThe monitor will use the user maxscaleuser with the password maxscalepassword to connect to the servers and query them for their state. In the servers parameter we have listed both of the Production-DB and Archive-DB servers. The monitor_interval parameter controls how often the monitor will poll the servers for status. For this tutorial, we’ve set it to 5000 milliseconds.<\/span><\/p>\nNext step is the configuration of the Production and Archive services. The Production service will be the main access point to the system.<\/span><\/p>\n[Production-DB]\r\ntype=service\r\nrouter=readconnroute\r\nservers=Production-DB\r\nuser=maxscaleuser\r\npasswd=maxscaleuserpassword\r\nfilters=Tee\r\n\r\n[Archive-DB]\r\ntype=service\r\nrouter=readconnroute\r\nservers=Archive-DB\r\nuser=maxscaleuser\r\npasswd=maxscaleuserpassword\r\nfilters=MQ Filter<\/pre>\nThe filters parameters for the services refer to the filters we will be creating next. The Production service will use the Tee filter to duplicate INSERT, UPDATE and DELETE statements to the Archive service. The statements passed to the Archive service will use the MQ Filter to send the canonical versions of the statements to the RabbitMQ broker. The Production service will use the Production-DB server and the Archive service will use the Archive-DB server. Both services user the maxscaleuser user with the maxscalepassword password.<\/span><\/p>\nNext we will configure the listeners for these two services.<\/span><\/p>\n[Production Listener]\r\ntype=listener\r\nservice=Production\r\nprotocol=MySQLClient\r\nport=4000\r\n\r\n[Archive Listener]\r\ntype=listener\r\nservice=Archive\r\nprotocol=MySQLClient\r\nport=4001<\/pre>\nThe port parameter controls which port the listener will listen on and where the client connections should be made. The service parameter tells which listener belongs to which service.<\/span><\/p>\nAfter the services and their listeners are configured we will configure the two filters we’ll use. We begin with the Tee filter.<\/span><\/p>\n[Tee]\r\ntype=filter\r\nmodule=tee\r\nservice=Archive\r\nmatch=\\(insert\\)\\|\\(update\\)\\|\\(delete\\)<\/pre>\nThe service parameter controls which service we want to duplicate the statements to. This needs to be set to the section name of the archive service: Archive. The match parameter is a regular expression which, if matched, cause the statement to be duplicated. Here we will want a regular expression which will match the INSERT, UPDATE and DELETE statements.<\/span><\/p>\nAfter the Tee filter is configured, we will configure the Mqfilter to communicate with the RabbitMQ server we’ve set up.<\/span><\/p>\n[MQ Filter]\r\ntype=filter\r\nmodule=mqfilter\r\nhostname=192.168.56.101\r\nport=5672\r\nusername=msguser\r\npassword=msgpwd\r\nexchange=msg-ex-1\r\nqueue=msg-queue-1\r\nkey=MaxScale\r\n<\/pre>\nThe hostname is the address and the port is the port of the RabbitMQ server. For username and password we will use the msguser and msgpwd credentials we created earlier. The exchange is the name of the RabbitMQ exchange we’re using and the key is the key used for all the sent messages. The messages will be stored in the mxs-queue-1 queue.<\/span><\/p>\nThe next thing to configure is the administration interface.<\/span><\/p>\n[MaxAdmin Service]\r\ntype=service\r\nrouter=cli\r\n\r\n[MaxAdmin Listener]\r\ntype=listener\r\nservice=MaxAdmin Service\r\nprotocol=maxscaled\r\nport=6603<\/pre>\nWe have created MaxScale configuration file in \u00a0\/etc\/maxscale.cnf , Here is the complete configuration file: <\/span><\/p>\n# The production and archive servers\r\n[Production-DB]\r\ntype=server\r\naddress=192.168.56.101\r\nport=3306\r\nprotocol=MySQLBackend\r\n\r\n[Archive-DB]\r\ntype=server\r\naddress=192.168.56.102\r\nport=3000\r\nprotocol=MySQLBackend\r\n\r\n# MySQL server monitor\r\n[MySQL Monitor]\r\ntype=monitor\r\nmodule=mysqlmon\r\nservers=Production-DB, Archive-DB\r\nuser=maxscaleuser\r\npasswd=maxscalepassword\r\nmonitor_interval=5000\r\n\r\n# Production service\r\n[Production]\r\ntype=service\r\nrouter=readconnroute\r\nservers=Production-DB\r\nuser=maxscaleuser\r\npasswd=maxscalepassword\r\nfilters=Tee\r\n\r\n# Archive service\r\n[Archive]\r\ntype=service\r\nrouter=readconnroute\r\nservers=Archive-DB\r\nuser=maxscaleuser\r\npasswd=maxscalepassword\r\nfilters=MQ Filter\r\n\r\n# Listeners for the services\r\n[Production Listener]\r\ntype=listener\r\nservice=Production\r\nprotocol=MySQLClient\r\nport=4000\r\n\r\n[Archive Listener]\r\ntype=listener\r\nservice=Archive\r\nprotocol=MySQLClient\r\nport=4001\r\n\r\n# Tee filter to duplicate insert, update and delete\r\n# statements to the archive server\r\n[Tee]\r\ntype=filter\r\nmodule=tee\r\nservice=Archive\r\nmatch=\\(insert\\)\\|\\(update\\)\\|\\(delete\\)\r\n\r\n# Mqfilter to log the canonical versions of the archive\r\n# server queries to a RabbitMQ broker\r\n[MQ Filter]\r\ntype=filter\r\nmodule=mqfilter\r\nhostname=192.168.56.101\r\nport=5672\r\nusername=msguser\r\npassword=msgpwd\r\nexchange=msg-ex-1\r\nqueue=msg-queue-1\r\nkey=MaxScale\r\n\r\n# Administration interface setup\r\n[MaxAdmin Service]\r\ntype=service\r\nrouter=cli\r\n\r\n[MaxAdmin Listener]\r\ntype=listener\r\nservice=MaxAdmin Service\r\nprotocol=maxscaled\r\nport=6603\r\n\r\n\r\n<\/pre>\n
![\"\"](\"http:\/\/minervadb.com\/wp-content\/uploads\/2019\/06\/Screenshot-2019-06-18-at-12.08.10-AM-1024x626.png\")
<\/a><\/p>\n