Advertisement
Guest User

Untitled

a guest
Mar 3rd, 2017
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.69 KB | None | 0 0
  1. [maxscale]
  2. threads=1
  3.  
  4. [MaxInfo]
  5. type=service
  6. router=maxinfo
  7. user=monitor
  8. passwd=EBD2F49C3B375812A8CDEBA632ED8BBC
  9.  
  10. [MaxInfo JSON Listener]
  11. type=listener
  12. service=MaxInfo
  13. protocol=HTTPD
  14. port=4002
  15.  
  16. [Replication]
  17. type=service
  18. router=binlogrouter
  19. version_string=5.6.17-log
  20. user=skysql
  21. passwd=skyvodka
  22. router_options=mariadb10-compatibility=1,server-id=999,user=skysql,password=skyvodka,binlogdir=/var/cache/maxscale/
  23. #router_options=send_slave_heartbeat=on,transaction_safety=on,semisync=1,mariadb10-compatibility=1,server-id=999,user=skysql,password=skyvodka,binlogdir=/var/lib/maxscale/
  24.  
  25.  
  26. [Replication Listener]
  27. type=listener
  28. service=Replication
  29. protocol=MySQLClient
  30. port=3306
  31.  
  32.  
  33. [MySQL Monitor]
  34. type=monitor
  35. module=mysqlmon
  36. servers=server1,server2
  37. user=skysql
  38. passwd=skyvodka
  39. monitor_interval=2000
  40. detect_stale_master=true
  41.  
  42. # Service definitions
  43. #
  44. # Service Definition for a read-only service and
  45. # a read/write splitting service.
  46. #
  47.  
  48. # ReadConnRoute documentation:
  49. # https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Routers/ReadConnRoute.md
  50.  
  51. [Read-Only Service]
  52. type=service
  53. router=readconnroute
  54. servers=server1
  55. user=skysql
  56. passwd=skyvodka
  57. router_options=slave
  58.  
  59. # ReadWriteSplit documentation:
  60. # https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Routers/ReadWriteSplit.md
  61.  
  62. [Read-Write Service]
  63. type=service
  64. router=readwritesplit
  65. servers=server1
  66. user=skysql
  67. passwd=skyvodka
  68. max_slave_connections=100%
  69.  
  70. # This service enables the use of the MaxAdmin interface
  71. # MaxScale administration guide:
  72. # https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Reference/MaxAdmin.md
  73.  
  74. [MaxAdmin Service]
  75. type=service
  76. router=cli
  77.  
  78. # Listener definitions for the services
  79. #
  80. # These listeners represent the ports the
  81. # services will listen on.
  82. #
  83.  
  84.  
  85. [Write Connection Router]
  86. type=service
  87. router=readconnroute
  88. router_options=master
  89. servers=server1,server2
  90. user=skysql
  91. passwd=skyvodka
  92. enable_root_user=true
  93.  
  94.  
  95. [Read-Only Listener]
  96. type=listener
  97. service=Read-Only Service
  98. protocol=MySQLClient
  99. port=4008
  100.  
  101. [Write-Only Listener]
  102. type=listener
  103. service=Write Connection Router
  104. protocol=MySQLClient
  105. port=4007
  106.  
  107. [Read-Write Listener]
  108. type=listener
  109. service=Read-Write Service
  110. protocol=MySQLClient
  111. port=4006
  112.  
  113. #[MaxAdmin Listener]
  114. #type=listener
  115. #service=MaxAdmin Service
  116. #protocol=maxscaled
  117. #socket=default
  118.  
  119.  
  120. # Internet Socket
  121. [CLI Inet Listener]
  122. type=listener
  123. service=MaxAdmin Service
  124. protocol=maxscaled
  125. address=0.0.0.0
  126. port= 3307
  127.  
  128. [server2]
  129. type=server
  130. address=192.168.0.41
  131. port=5056
  132. protocol=MySQLBackend
  133.  
  134. [server1]
  135. type=server
  136. address=192.168.0.41
  137. port=5055
  138. protocol=MySQLBackend
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement