Chapbook
  • Home
    • Sitemap
  • Snippets
    • MySQL snippets
    • bash snippets
    • PERL snippets
    • PHP snippets
    • pgSQL snippets
  • Category Indexes
    • Cookery
    • Genealogy
    • Photography
    • Technology
    • Uncategorized
  • All Articles
    • Articles by category
    • Publications
      • Cemetery Crosses
      • History of Conecuh County, AL – Index
  • Contact
upArrow

Automated replication reversal (failover)

 September 1, 2020 RLByrd   Snippets, Technology, bash snippets, Database, MySQL

The attached scripts simple reverse a repliation flow (e.g.  serverA –> serverB becomes serverB –> serverA).

automated_failover

Related posts:

  1. Converting the charset for an entire schema
  2. Multi-threaded replication in MySQL 5.7
  3. MySQL DDL diff
  4. Simulating INTERSECT in MySQL
  5. Convert charset in all schemas within an instance
« Load balancer comparison (2019-10-22) Genealogy »

Recent Posts

  • Types of marriage records
  • ONLY_FULL_GROUP_BY and you
  • Lincoln and Free Speech
  • What’s using my swap space?
  • English-to-Gaelic Name Equivalents

Tag Cloud

1st alabama15th alabama33rd alabama36th alabama57th alabamaalabamaapt-getartaudioauditbashblocksbookbrassbyrdcalendarcat mashCDNcentoscharsetchaverscivil warclientcocktailsconfigurationcookingcrimecsacyclonedatabasedavDBeaverDDLdevelopmentdigitaldrinksemailemergeeugeniaexportfilerunfindFlomatonfontsfrisco citygaelicgaleragenealogygmailGooglegrantsgraphicsGUIhardwarehighlandshilliard's legionhistoryIDEinstallationinstrumentsiOSiPadkuberneteslanguagelearninglinuxloadbalancinglocklockingmailmemorymexicanmonitoringmonroemonroe countymultibytemurdermusicmysqlmysqldumpnagiosnamesnetworkold texasopensourceOutlookpacmanpaintingperconaperformancephotosphysicspostfixpostgrespowerpointproductionproxysqlpublicationpythonrailroadrecipesrecordingRedshiftrelayremote accessresearchrestorationscottishsecuritysedshellslavesmithsoftwaresoldierstephen talmadgestuckeyswaptechnologytexastornadotroubleshootingunicodeutf8utilitiesvideovirtualizationwebwebdavwindowsyumzypper

Archives

Indexes

  • About
  • All Articles
  • Categories
  • Contact
  • Cookery Index
  • Genealogy Index
  • Home
  • Music Index
  • Photography Index
  • Search
  • Sitemap
  • Technology Index
  • The Digital Junk Drawer
  • Uncategorized Index

Meta

  • Log in
  • Entries RSS
  • Comments RSS
  • Chapbook
© 1982-2021, rlbyrd.com