replication-manager

This is the 2nd release candidate of Replication Manager for MySQL/MariaDB/Percona series.

Changelog

• Fixed several issues with Arbitrator server
• RM will not overrule ProxySQL on read-only flag detections
• Last RW server is now correctly set to master instead of standalone
• ProxySQL can now be bootstrapped from the RM config
• Maintenance toggle was broken and has been fixed
• Fixed issues with slave down calling for replication checks
• Clean up some unnecessarily verbose log messages
• Fixed configuration typos
• Preferred and Ignored servers are now shown in the dashboard
• Graphs tab will be disabled if Graphite hasn't been configured
• Fixed switchover to preferred master on CLI
• Fixed Could not set replication channel when a db server has no binlog (#198)
• Rewrote Dockerfile to work with 2.x series

This is a release candidate version of Replication Manager 2.0.
Please refer to https://docs.signal18.io/ for configuration changes.

• Replication Manager API
• Rewritten MaxScale Proxy monitoring
• Support of MySQL replication
• Support of OpenSVC enterprise
• New unified configuration syntax
• Support for ProxySQL
• Arbitrator in standalone package
• Refactored internal logging
• Improved HTTP Interface
• Improved packaging
• Multi Master Ring support
• Consul Support
• Maintenance Mode support
• Failover using Pseudo GTID support
• Rewritten HAProxy support
• Shard Proxy (Spider) support
• Sphinx support
• Grafana integration
• Refactored monitoring logic
• Too many bug fixes to be listed here

• Arbitration bugfixes

This is a bug fix release to address issues with cascading failover and autorejoin not functioning.

General Availability Release for replication-manager 1.1.1

Fixes:

• Fix slave stuck in suspect mode
• Fix gtid_slave_pos in dbhelper
• Change wait apply relay log for GTID Position in MariaDB
• Fix inserting fake transaction during failover
• Fix arbitration issue where a SQLite transaction was left open
• Fix MaxScale provisioning
• Various logging fixes

• Fix issue when reintroducing slave
• Fix error messages

Release notes

• Added MySQL 5.7 GTID support and 5.6 positional support
• Improved multi-MRM cluster
• More support for Multi-Tiered Slaves
• Multiple topologies can now be bootstrapped
• Improved errors
• Arbitrator now uses sqlite instead of mysql
• Improved service files
• Added MariaDB 10.2 Support
• Included mysqlbinlog
• Support for MariaDBShardProxy (Spider)
• Too many bug fixes to be listed here
• Improved documentation

• Support for Multi Cluster
• Rejoin Cluster via mysqldump
• Rejoin Cluster via Flashback (MariaDB 10.2)
• Improved testing framework
• Auto-enforce mode
• Maxscale mode improvements
• Many small bugs corrected

Know issues

Http authentication should not be used causing memory leak if browser stay open
Standby server does not follow topology. Already fixed in dev

Release notes

• Fix EL6 initscript issues

Release notes

• Fixed a panic issue with configuration file not found or unreadable
• Fixed version numbering issues
• Added a warning vs. using http-auth

Known issues

• http-auth currently leaks memory if a browser is open on the dashboard while it is activated

This is a General Availability release of replication-manager for MariaDB 10.x databases.
Please upgrade your 0.7 installations to this version which is recommended for production usage.

Release Notes

Features

• Rewritten config system allowing configuration groups
• Event Scheduler failover
• Failure counter reset option
• Dashboard HTTP authentication
• Add alerts for stopped slave and delayed slave

Fixes

• HAProxy will now failover before unlock of the demoted leader
• HAProxy check interval used the wrong resolution
• IPv6 wasn't handled properly
• Various dashboard AngularJS fixes
• Fixed failover priority now based on IO thread instead of SQL thread
• Fixed a couple of debug exceptions

• Added option to notify MaxScale of changes
• More regression tests
• Heartbeat table support for active/passive mode
• Do not failover automatically if slaves are up
• Privilege check fixes
• Check long sleeping transactions
• AngularJS and Bootstrap are now supplied statically

Release notes

Features

• Smaller Docker image (thanks to Thiago Caxias)
• Preliminar Spider support
• Semi-sync state control
• Force failover option
• Regression tests
• AES Password Encryption
• Settings advisor (Issue #76)
• Preliminary systemd support

Bug fixes

• Failover limit now properly toggles manual failover (Issue #71)
• MRM now waits for slaves to have read all relay logs before failing over (Issue #73)
• Post-failover is now properly called once instead of twice
• Privileges are now correctly checked with the local IP of MRM
• In some cases, the demoted master could still be in RO mode (Issue #84)
• Config file parsing errors now return an error
• gtidcheck option is now properly documented (Issue #78)
• Log File is not overwritten anymore at each MRM start

1416b1e Formatting
96ecf3d Remove spurious debug msg
7adbeec Fix regressions brought by last commit
048cb29 Fixing multi master failover + multi master topology detection + doc
4bf57a6 Adding additional test for All threads Stopped
3e6a5de Fix spelling of title to respect lower case
25d89d7 Add additionall documentation on grant definition
a5b8893 Fix for non-existing config file
67f88f7 Doc add maxscale user grant example
5645a8a Fix tests happening on failover
de13030 Fix vetshadow warning
4bd0182 Update README with conf file location
4b48ef4 Remove unnecessary mutex
2cf168a Improve error message
fbf5aa7 Improve failover mode changes Fixes #61
46e4228 Update README
b6aefd4 Add interactive toggle in monitor mode
7fccef1 Fix doc about semi-sync WARNING in error log
6fc6d9d Mutexing State Machine
e5a1214 Merge branch '0.7' of github.com:mariadb-corporation/replication-manager into 0.7
f719c1d Fix can' be sync when isnot failable
4d0e052 Print states in monitoring loop
606ac48 do not refresh servers in display loop
b0bc738 Merge branch '0.7' of github.com:mariadb-corporation/replication-manager into 0.7
65a1934 Slave eligibility is now checked in topo loop
70f51c5 Fix SLA
2505206 Check state ERR to compute faibable SLA
36f4cd7 Add Semi-sync Master and Slave status to server list display
ec87b7f Dashboard shows error when http server is down (Fixes #55)
0149adb Doc update flags
318bfaa Fix to the doc fix
0d1156e Fix documentation on roadmap & feature
f263b37 Prefmaster tests for 1 argument (Fixes #56)
6696a91 Merge branch '0.7' of github.com:mariadb-corporation/replication-manager into 0.7
c316d20 Init SME in topology cmd (Fixes #52)
dbed215 Merge branch '0.7' of github.com:mariadb-corporation/replication-manager into 0.7
d0bee28 Fix doc roadmap
ac9a2f2 Spell check
0b50759 More Docs
47b7ee5 Fix doc spelling
36e3019 Docs fixing
d5ca157 Fix spelling in documentation
ad7ce4a Documentation improvments
fbbbf8b Merge branch '0.7' of github.com:mariadb-corporation/replication-manager into 0.7
4dc4cac fix doc
47d5ebc Remove this in favor of @svar sample conf
a93a472 Documentation - add images
f8e5a9d Spell check
e312228 Fix broken failover command
d0f0043 Merge branch '0.7' of github.com:mariadb-corporation/replication-manager into 0.7
e62b67a Add more docs
bb5fabb Export state maps
4472982 Fix spacing in State output
c5274c2 Merge branch '0.7' of github.com:mariadb-corporation/replication-manager into 0.7
7dc7193 Fix fluctuation in SLA computation by changing current time with last metric time
fbefebe Long command description (Fixes #49)
a19b639 Print the correct user on error
5ea0527 Check replication privileges in topo loop
920764f Fix binary not installing properly

85141d5 Allow bootstrap from http
4a7cf54 Fix CR logs issue
2abf058 Implement messenging for switchovers
ab95030 Fix failover happening concurrently with http-triggered switchover
5614fab Avoid double switchover in httpserver
92ae77c Replication creds check (fixes #27)
dfe6f91 Eval ignore list first (Fixes #35)
905c29e Documentation fixes
fcc9ba5 Add master-connect-retry option
e18af44 Add parallel checks
98fc72b Add timeout to MasterPosWait
1a879d4 Fix several errors in detection logic
22adc12 Final fix to #37
1cbe89d Update dependencies
9367b8a Fix RO mode should be on slaves only
0dbc552 Fix some broken detection logic
fe2f042 Fix missing privilege checks
cc6b238 Fix repeated IsSlaveOf warning
944fff9 Fix panic in verbose mode
a4300dc Don't print failures indefinitely
9a351e1 Formatting
9c94350 If set, enforce read-only on slaves
dca8fe7 Bootstrap did not set RO flag correctly
2aad8f1 Tlog resync displays + colors in monitor
8a8d26e Formatting
f89c052 Formatting
01d327b Track non-interactive failovers (Resolves #17)
c452017 Fix sme not initialized on cli commands Statefile fixes
4f74508 Increment GTID on bootstrap
15c7375 Revert "Formatting"
cb56ec7 Formatting
4439a47 Revert changes affecting flag initialization
30b61b5 Formatting
1a3cd7d Spacing
59eb64e Spell check documentation
1f2781b More docs
3b3f65f More docs
303e048 Output SLA in http
0d372ff Sample configuration file
5087444 Fix bad master usage for uptime in topology
3e687d7 Merge branch 'svar' into 0.7
fc7cd86 Merge branch 'svar' of github.com:mariadb-corporation/replication-manager into svar
680ed43 Add Call for compute uptime in topology detection
a84444c Remove debug message
030eb75 Fix data not reinitialized in struct
fa0566f Merge branch 'svar' of github.com:mariadb-corporation/replication-manager into svar
e28b660 Fix display and failover count logic
b4937d4 Fix verbose when entering monitoring
1cdb5d5 Merge branch 'svar' of github.com:mariadb-corporation/replication-manager into svar
0352e0b Adding, State uptime computation, SemiSync and Rpl Status in monitoring a
195e049 Logging
e816b3c Fix topology detection issues
e07b739 Set verbose for log levels > 0
37f8423 Handle loglevel compatibility with verbose opt
3e3be59 Add configurable log level
caf670b Check if master exists in topology before rejoining
0e25c1f Fix parameter not passed properly in monitor
03a0f5f Merge pull request #41 from hugochinchilla/0.7
d85b7d8 Use goroutines for ping
5290a3f End loop if server is failed
80175a7 handle cases where termbox size cannot be determined
ac481db Fix servers not initialized
32c0243 Handle display case where Gtid is nil
1f2a10a Remove email lib as submodule
b8720b6 Add jordan-wright/email
3c62077 Update dependencies
ba83ee3 Remove unneeded dashboard files
df8931e Dashboard add reset failover counter feature
2a9cdce Separate html view and angular controller
c46cbf4 Change alert formatting
a3de97b Do not allow new connections during freeze
a8d1ef4 Do not handle state changes in refresh loop
612a46b Send alert when server fails
426db1e Fix errors in last commit
72717ee Add email options and remove old function
cf5d2fb Add Alert class
6fd1afe Fix prefMaster not handled correctly in bootstrap
6a0668c Fix hardcoded dashboard path
7bb4bc8 Fix slave pos not properly re-initialised
89c2b50 Check that mrm user has reload priv
a8d53c3 Update dependencies
26e38f1 Fix empty gtid not handled by dashboard
97e9d11 Fix hardcoded paths in dashboard
c18b638 Tentative fix for CORS issues
ed3a0a4 Handle display case where Gtid is nil
4232a5e Refactor topology code (WIP)
83a7238 Add http root option
224a61e Add test for statefiles
d152c3e Fix standalone host header displayed more than once
bfb1647 Remove duplicate termbox.Close
1f490a1 Fix standalone host header displayed more than once
88e72b8 repMgrFlagCheck should only be called once
1bd418e Fixe bootstrap , Use prefmaster as URL:127.0.0.1:3307, Add return err code to topology error
60c2b08 Fix broken tlog position
401fe13 Fix broken tlog position
3b389e3 Merge branch 'svar' of github.com:mariadb-corporation/replication-manager into svar
2ba51a7 Fixe all unconnected servers
ddef627 Fix formatting
c102453 Fix wrong logic in CanMonitor
6d7aad9 Close connection at every rediscovery ticker
c18011d Merge branch 'svar' of github.com:mariadb-corporation/replication-manager into svar
03252e1 Voila
946eae7 Fix formatting
29197b0 Merge branch 'termlog' into svar
cf6cfcb State Manager Engine
5f841c2 Package termlog
04e11e7 Package termlog
5e362ed encore commit parce que je suis null en git
5373061 State machine tentative
9bba129 Remove errPrinted
5d5ae63 Stage clear Map
c588d04 Rewrite state as a package
ed8896d Convert conf and topology dedection to a state hash map

171b1e7 Merge branch '0.7' of https://github.com/mariadb-corporation/replication-manager into 0.7
a5304f2 Fix options in wrong section
1cbc834 Remove old js file
5bd1bee Merge pull request #40 from hugochinchilla/0.7
3221048 build image with name to prevent multiple builds of the same Dockerfile
39a25a4 bind agent in all interfaces by default
92a75d9 Update vendoring (fixes #37)
bfabb63 Ignore backup files
5e27225 Merge branch '0.7' of https://github.com/mariadb-corporation/replication-manager into 0.7
59be0b9 go get is unnecessary with vendoring
e25a7d6 Merge pull request #38 from hugochinchilla/0.7
c74a8f2 update Dockerfile to add ENTRYPOINT, update docker-compose and README.md accordingly
68fadd8 Add configurable parameters for http server and daemon
ca4cb55 Merge branch 'gtidlist' into 0.7
8776ade Fix standalone host gtid display
fc2396d Docker image default mode is monitoring daemon
30e099a Docker image configuration file support
22f74aa Example configuration file
0f45206 Fix log function
d611fd9 Dashboard can now read GTID objects
307b60d Fix failover display
498e05a Fix vetshadow warning
4049822 Election can use gtid lists
00a1202 Implement the gtid class
5830ce7 Fix empty GTID List
52fa269 Add Sprint function and documentation
bd8253f GTID package
129cc5c Set slave as read only when reintroducing
4819f62 Automatic failover was never evaluated
61029b0 Restore overwritten Dockerfile
b4d1bf2 Use internal log function
80c7c8f Fix wrong condition in MM election
65b021d Additional topology debug information
4627b73 Add build instructions (Fixes #23)
a760249 Daemon mode --daemon starts MRM without the console --http-monitor starts http monitor
a377ea7 Dashboard mode change + interval fix
9f04aa9 Use http prefix for bind address
18d8846 Configurable http port and interface
62b9b7b Clarify MM read-only detection msg
fb66bed Merge branch '0.7' of https://github.com/mariadb-corporation/replication-manager into 0.7
165450d Fix incomplete commit
3f559ff Statefile for non-interactive action tracking
e329c8b Return false when failover is impossible
0741c83 Merge pull request #20 from guilhem/docker-compose
b6c2302 Add a docker-compose to test replication-manager
bc7bc01 Merge pull request #18 from guilhem/glide
53026ed lightweight docker images
bb61324 travis: Add deploy step
31b7652 Use glide and local vendoring
c6189fa Fix failed master detection issue

Fix #13

Fix #11
Improve termlog - log is now dynamic and auto-resizes