ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    MySQL 5 InnoDB to MariaDB Migration

    Scheduled Pinned Locked Moved IT Discussion
    centos 5linuxmysqlmariadbdatabasewindows server 2012 r2
    13 Posts 4 Posters 3.7k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • scottalanmillerS
      scottalanmiller
      last edited by

      Complexity. That only works for certain database styles.

      creaytC 1 Reply Last reply Reply Quote 0
      • dafyreD
        dafyre
        last edited by

        How is the project going?

        I know where were some tools from RedGate, and a couple of other companies that could do similar to this, but I'm not sure if they worked with MySQL / MariaDB

        1 Reply Last reply Reply Quote 0
        • JaredBuschJ
          JaredBusch
          last edited by

          @dafyre said:

          I know where were some tools from RedGate, and a couple of other companies that could do similar to this, but I'm not sure if they worked with MySQL / MariaDB

          Redgate tools are nice. I use their SQL Compare product religiously at one client.

          1 Reply Last reply Reply Quote 0
          • creaytC
            creayt @scottalanmiller
            last edited by

            @scottalanmiller said:

            Complexity. That only works for certain database styles.

            Are you able to isolate what patterns in complexity prevent this type of transition? I've used MySQL dumps to migrate what I'd call extremely complex databases with hundreds of tables that if modeled in some kind of large-scale diagram might well resemble a spider web. Interested to know what patterns preclude the successful use of a dump and import.

            scottalanmillerS 1 Reply Last reply Reply Quote 1
            • scottalanmillerS
              scottalanmiller @creayt
              last edited by

              @creayt said:

              @scottalanmiller said:

              Complexity. That only works for certain database styles.

              Are you able to isolate what patterns in complexity prevent this type of transition? I've used MySQL dumps to migrate what I'd call extremely complex databases with hundreds of tables that if modeled in some kind of large-scale diagram might well resemble a spider web. Interested to know what patterns preclude the successful use of a dump and import.

              The complexity doesn't come from the tables but from the about of application logic that was put into the database itself. No amount of table complexity would be an issue. This is a problem that we can't find any means of exporting and importing the entire database. It never quite gives you everything.

              1 Reply Last reply Reply Quote 0
              • dafyreD
                dafyre
                last edited by

                So basically the views, and triggers and stored procedures aren't exporting or is there another level of logic that I'm not aware of yet?

                scottalanmillerS 1 Reply Last reply Reply Quote 0
                • scottalanmillerS
                  scottalanmiller @dafyre
                  last edited by

                  @dafyre said:

                  So basically the views, and triggers and stored procedures aren't exporting or is there another level of logic that I'm not aware of yet?

                  Views are fine. It's stored procedures and stored functions that are the killers.

                  1 Reply Last reply Reply Quote 0
                  • dafyreD
                    dafyre
                    last edited by

                    Ewwww... I ran into that when trying to do something similar with a Great Plains / Dynamics Database ... Ugh.

                    I feel for you now. How far along ar eyou guys into the process?

                    1 Reply Last reply Reply Quote 0
                    • scottalanmillerS
                      scottalanmiller
                      last edited by

                      Not at all, huge fish to fry first.

                      dafyreD 1 Reply Last reply Reply Quote 0
                      • dafyreD
                        dafyre @scottalanmiller
                        last edited by

                        @scottalanmiller said:

                        Not at all, huge fish to fry first.

                        I'll make the hushpuppies and cole slaw.

                        1 Reply Last reply Reply Quote 0
                        • scottalanmillerS
                          scottalanmiller
                          last edited by

                          Me too, that sounds good now that you say it.

                          I am staying with my dad too, here in the land of pizza, subs and fish frys.

                          1 Reply Last reply Reply Quote 1
                          • 1 / 1
                          • First post
                            Last post