Results 1 to 4 of 4

Thread: mysql upgrade / move to different machine

  1. #1
    Join Date
    Jun 2006
    Location
    Austrian in Taiwan
    Beans
    Hidden!
    Distro
    Ubuntu 18.04 Bionic Beaver

    mysql upgrade / move to different machine

    I have a large database (data.idb is 24 GB).
    On this machine, I still use 18.04

    I want to prepare to setup a new machine with 20.04.
    At the same time I want to upgrade to MySQL 8.0

    The system is collecting constantly data. If I use a mysqldump it would take some time and I would miss data when I start the database on the new machine.
    What is the best way to move the data? I am thinking of something like use mysqldump for the first xxxx records and delete these records, to keep the database small on the day of moving. Then I start collecting on the new machine and import the data I exported via mysqldump and deleted it. Then I want to add the data I have now collected on the old and new machine but would discard the duplicates when inserting. Is that a way I should look closer or is there another better way?
    I am from the government, I am here to help you! Just ask!
    And don't expect more to be happen than with any other government!

  2. #2
    Join Date
    Jun 2006
    Location
    Austrian in Taiwan
    Beans
    Hidden!
    Distro
    Ubuntu 18.04 Bionic Beaver

    Re: mysql upgrade / move to different machine

    Where can I get answer to this question?
    I am from the government, I am here to help you! Just ask!
    And don't expect more to be happen than with any other government!

  3. #3
    Join Date
    Jan 2017
    Beans
    235

    Re: mysql upgrade / move to different machine

    Maybe I misunderstand your situation, but why not start collecting data on your new machine, do a mysqldump of the database on the old machine after it is off line and then restore the data to your new machine.

  4. #4
    Join Date
    Apr 2014
    Location
    Tucson AZ, USA
    Beans
    1,057
    Distro
    Ubuntu

    Re: mysql upgrade / move to different machine

    Set up duplication? Then switch masters once it's caught up? I'm no sql admin but sounds like what it's made for almost? Downtime shouldn't be much more a few minutes when restarting services to load new configs.

    Apologies...

    Replication. Not duplication.
    Last edited by Tadaen_Sylvermane; October 11th, 2020 at 03:54 AM.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •