Upgrading mysql 5.7 to 8.0

Discussion in 'Installation/Configuration' started by CaptainBalou, May 10, 2022.

  1. CaptainBalou

    CaptainBalou Member

    Hello all,

    my question is regarding upgrading my mysql 5.7 to mysql 8.0 on Ubuntu. It is clear for me how an mysql upgrade works according to the documentation, but it seems that the replication of my ISPConfig primary and mirror server setup blocks me somehow. I believe it is because according to the documentation I have to upgrade the master first and then upgrade the replica host - but I think both are the master in some way.

    Right? Or not? I don't know. :) Does anyone have a few tipps on how to acomplish that? Is there a way to disable the replication for a while and re-establish it afterwards? Or am I completely wrong and this is not needed at all?

    Thanks in advance for any answer.

    All the best
    Marco
     
  2. nhybgtvfr

    nhybgtvfr Well-Known Member HowtoForge Supporter

    are you actually replicating mysql servers at all?

    if you are just running eg master server (ispconfig interface) web1, web2 (mirror of web1), db1, db2 (mirror of db1)
    that doesn't mean web2 is replicating from web1, or db2 is replicating from db1.. just that they are running the same services, and the same client configs. each local mysql server connects to the master mysql and retrieves the config data relevant for itself, and then adjusts it's own config and client config accordingly. eg creates new website or db.

    the actual client data itself is down to you to replicate in the best manner for your hardware, whether that's shared storage connected to the mirrored servers, or file/folder replication between servers (unison, rsync, dsync etc) or master-master / master-slave replication for client databases.
     
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    It might be that he is using MySQL master/master replication. Is this an ISPConfig Multiserver system (master/slave) or is it an ISPConfig mirror system with master/master MySQL replication?
     
  4. CaptainBalou

    CaptainBalou Member

    Hello both of you,

    thanks for your reply. I set it up via a perfect setup guide years ago - I now know I should have noted down which one it was exactly but I didn't. I think it is what @till is mentioning. I have two servers where server 2 is marked as a mirror of server1 and I have the configuration panel on both servers available. All data between the two is kept in sync via unison. On both servers I made a configuration for master and slave at the same time. So server1 is master and server2 is slave but on another database of ISPConfig it is vice versa. Does that answer you questions?
     

Share This Page