Before you consider upgrading your Aurora MySQL DB cluster to version 3, run an upgrade assessment and address all flagged items. You can run an assessment using the mysqlcheck --check-upgrade command. You should also test your application with the upgraded version of Aurora MySQL 3 before considering upgrading production Aurora database clusters. Refer to the behavioral changes section of this post for more details. For more information review the User Guide for Amazon Aurora.
At this time, you can migrate from a self-managed MySQL-compatible database by performing a logical data export and importing it into a new Aurora MySQL 3 DB cluster. You can use binary log replication to perform a minimal downtime migration similarly as described in the earlier sections from other upgrade or migration sources. The binary log replication configuration is described in detail Amazon Aurora User Guide. You can perform this migration using native MySQL tools provided by the community or third parties, such as mysqldump, mydumper/myloader, or by using AWS Database Migration Service (AWS DMS).
7 Fresh Bugs in MySQL 8.0
For free technical help, visit the Percona Community Forum. To report bugs or submit feature requests, open a JIRA ticket. For paid support and managed or consulting services , contact Percona Sales.
$ sudo apt purge mysql-server$ sudo rm -rf /etc/mysql$ dpkg -l grep mysqlresult:ii libmysqlclient21:amd64 8.0.23-0ubuntu0.20.04.1 amd64 MySQL database client libraryii mysql-common 5.8+1.0.5ubuntu2 all MySQL database common files, e.g. /etc/mysql/my.cnf
sudo apt-get install mysql-serverresult:Reading package lists... DoneBuilding dependency treeReading state information... DoneThe following additional packages will be installed: libaio1 libcgi-fast-perl libcgi-pm-perl libevent-core-2.1-7 libevent-pthreads-2.1-7 libfcgi-perl libhtml-template-perl libmecab2 mecab-ipadic mecab-ipadic-utf8 mecab-utils mysql-client-8.0 mysql-client-core-8.0 mysql-server-8.0 mysql-server-core-8.0Suggested packages: libipc-sharedcache-perl mailx tinycaThe following NEW packages will be installed: libaio1 libcgi-fast-perl libcgi-pm-perl libevent-core-2.1-7 libevent-pthreads-2.1-7 libfcgi-perl libhtml-template-perl libmecab2 mecab-ipadic mecab-ipadic-utf8 mecab-utils mysql-client-8.0 mysql-client-core-8.0 mysql-server mysql-server-8.0 mysql-server-core-8.00 upgraded, 16 newly installed, 0 to remove and 2 not upgraded.Need to get 30,6 MB/30,6 MB of archives.After this operation, 249 MB of additional disk space will be used.Do you want to continue? [Y/n]Get:1 focal-updates/main amd64 mysql-client-core-8.0 amd64 8.0.23-0ubuntu0.20.04.1 [4.215 kB]Get:2 focal-updates/main amd64 mysql-client-8.0 amd64 8.0.23-0ubuntu0.20.04.1 [22,0 kB]Get:3 focal/main amd64 libaio1 amd64 0.3.112-5 [7.184 B]Get:4 focal/main amd64 libevent-core-2.1-7 amd64 2.1.11-stable-1 [89,1 kB]Get:5 focal/main amd64 libevent-pthreads-2.1-7 amd64 2.1.11-stable-1 [7.372 B]Get:6 focal/main amd64 libmecab2 amd64 0.996-10build1 [233 kB]Get:7 focal-updates/main amd64 mysql-server-core-8.0 amd64 8.0.23-0ubuntu0.20.04.1 [17,7 MB]Get:8 focal-updates/main amd64 mysql-server-8.0 amd64 8.0.23-0ubuntu0.20.04.1 [1.275 kB]Get:9 focal/main amd64 libcgi-pm-perl all 4.46-1 [186 kB]Get:10 focal/main amd64 libfcgi-perl amd64 0.79-1 [33,1 kB]Get:11 focal/main amd64 libcgi-fast-perl all 1:2.15-1 [10,5 kB]Get:12 focal/main amd64 libhtml-template-perl all 2.97-1 [59,0 kB]Get:13 focal/main amd64 mecab-utils amd64 0.996-10build1 [4.912 B]Get:14 focal/main amd64 mecab-ipadic all 2.7.0-20070801+main-2.1 [6.714 kB]Get:15 focal/main amd64 mecab-ipadic-utf8 all 2.7.0-20070801+main-2.1 [4.380 B]Fetched 30,6 MB in 2min 11s (233 kB/s)Preconfiguring packages ...Selecting previously unselected package mysql-client-core-8.0.(Reading database ... 171059 files and directories currently installed.)Preparing to unpack .../00-mysql-client-core-8.0_8.0.23-0ubuntu0.20.04.1_amd64.deb ...Unpacking mysql-client-core-8.0 (8.0.23-0ubuntu0.20.04.1) ...Selecting previously unselected package mysql-client-8.0.Preparing to unpack .../01-mysql-client-8.0_8.0.23-0ubuntu0.20.04.1_amd64.deb ...Unpacking mysql-client-8.0 (8.0.23-0ubuntu0.20.04.1) ...Selecting previously unselected package libaio1:amd64.Preparing to unpack .../02-libaio1_0.3.112-5_amd64.deb ...Unpacking libaio1:amd64 (0.3.112-5) ...Selecting previously unselected package libevent-core-2.1-7:amd64.Preparing to unpack .../03-libevent-core-2.1-7_2.1.11-stable-1_amd64.deb ...Unpacking libevent-core-2.1-7:amd64 (2.1.11-stable-1) ...Selecting previously unselected package libevent-pthreads-2.1-7:amd64.Preparing to unpack .../04-libevent-pthreads-2.1-7_2.1.11-stable-1_amd64.deb ...Unpacking libevent-pthreads-2.1-7:amd64 (2.1.11-stable-1) ...Selecting previously unselected package libmecab2:amd64.Preparing to unpack .../05-libmecab2_0.996-10build1_amd64.deb ...Unpacking libmecab2:amd64 (0.996-10build1) ...Selecting previously unselected package mysql-server-core-8.0.Preparing to unpack .../06-mysql-server-core-8.0_8.0.23-0ubuntu0.20.04.1_amd64.deb ...Unpacking mysql-server-core-8.0 (8.0.23-0ubuntu0.20.04.1) ...Selecting previously unselected package mysql-server-8.0.Preparing to unpack .../07-mysql-server-8.0_8.0.23-0ubuntu0.20.04.1_amd64.deb ...grep: /etc/mysql/: No such file or directoryUnpacking mysql-server-8.0 (8.0.23-0ubuntu0.20.04.1) ...Selecting previously unselected package libcgi-pm-perl.Preparing to unpack .../08-libcgi-pm-perl_4.46-1_all.deb ...Unpacking libcgi-pm-perl (4.46-1) ...Selecting previously unselected package libfcgi-perl.Preparing to unpack .../09-libfcgi-perl_0.79-1_amd64.deb ...Unpacking libfcgi-perl (0.79-1) ...Selecting previously unselected package libcgi-fast-perl.Preparing to unpack .../10-libcgi-fast-perl_1%3a2.15-1_all.deb ...Unpacking libcgi-fast-perl (1:2.15-1) ...Selecting previously unselected package libhtml-template-perl.Preparing to unpack .../11-libhtml-template-perl_2.97-1_all.deb ...Unpacking libhtml-template-perl (2.97-1) ...Selecting previously unselected package mecab-utils.Preparing to unpack .../12-mecab-utils_0.996-10build1_amd64.deb ...Unpacking mecab-utils (0.996-10build1) ...Selecting previously unselected package mecab-ipadic.Preparing to unpack .../13-mecab-ipadic_2.7.0-20070801+main-2.1_all.deb ...Unpacking mecab-ipadic (2.7.0-20070801+main-2.1) ...Selecting previously unselected package mecab-ipadic-utf8.Preparing to unpack .../14-mecab-ipadic-utf8_2.7.0-20070801+main-2.1_all.deb ...Unpacking mecab-ipadic-utf8 (2.7.0-20070801+main-2.1) ...Selecting previously unselected package mysql-server.Preparing to unpack .../15-mysql-server_8.0.23-0ubuntu0.20.04.1_all.deb ...Unpacking mysql-server (8.0.23-0ubuntu0.20.04.1) ...Setting up libmecab2:amd64 (0.996-10build1) ...Setting up mysql-client-core-8.0 (8.0.23-0ubuntu0.20.04.1) ...Setting up libcgi-pm-perl (4.46-1) ...Setting up libhtml-template-perl (2.97-1) ...Setting up mecab-utils (0.996-10build1) ...Setting up libevent-core-2.1-7:amd64 (2.1.11-stable-1) ...Setting up mysql-client-8.0 (8.0.23-0ubuntu0.20.04.1) ...Setting up libfcgi-perl (0.79-1) ...Setting up libaio1:amd64 (0.3.112-5) ...Setting up libevent-pthreads-2.1-7:amd64 (2.1.11-stable-1) ...Setting up mecab-ipadic (2.7.0-20070801+main-2.1) ...Compiling IPA dictionary for Mecab. This takes long time...reading /usr/share/mecab/dic/ipadic/unk.def ... 40emitting double-array: 100% ###########################################/usr/share/mecab/dic/ipadic/model.def is not found. skipped.reading /usr/share/mecab/dic/ipadic/Noun.proper.csv ... 27328reading /usr/share/mecab/dic/ipadic/Verb.csv ... 130750reading /usr/share/mecab/dic/ipadic/Noun.name.csv ... 34202reading /usr/share/mecab/dic/ipadic/Prefix.csv ... 221reading /usr/share/mecab/dic/ipadic/Noun.adjv.csv ... 3328reading /usr/share/mecab/dic/ipadic/Noun.csv ... 60477reading /usr/share/mecab/dic/ipadic/Interjection.csv ... 252reading /usr/share/mecab/dic/ipadic/Adverb.csv ... 3032reading /usr/share/mecab/dic/ipadic/Adj.csv ... 27210reading /usr/share/mecab/dic/ipadic/Postp.csv ... 146reading /usr/share/mecab/dic/ipadic/Filler.csv ... 19reading /usr/share/mecab/dic/ipadic/Noun.demonst.csv ... 120reading /usr/share/mecab/dic/ipadic/Conjunction.csv ... 171reading /usr/share/mecab/dic/ipadic/Noun.nai.csv ... 42reading /usr/share/mecab/dic/ipadic/Noun.adverbal.csv ... 795reading /usr/share/mecab/dic/ipadic/Noun.number.csv ... 42reading /usr/share/mecab/dic/ipadic/Noun.verbal.csv ... 12146reading /usr/share/mecab/dic/ipadic/Postp-col.csv ... 91reading /usr/share/mecab/dic/ipadic/Adnominal.csv ... 135reading /usr/share/mecab/dic/ipadic/Others.csv ... 2reading /usr/share/mecab/dic/ipadic/Noun.org.csv ... 16668reading /usr/share/mecab/dic/ipadic/Noun.place.csv ... 72999reading /usr/share/mecab/dic/ipadic/Suffix.csv ... 1393reading /usr/share/mecab/dic/ipadic/Auxil.csv ... 199reading /usr/share/mecab/dic/ipadic/Noun.others.csv ... 151reading /usr/share/mecab/dic/ipadic/Symbol.csv ... 208emitting double-array: 100% ###########################################reading /usr/share/mecab/dic/ipadic/matrix.def ... 1316x1316emitting matrix : 100% ###########################################
done!update-alternatives: using /var/lib/mecab/dic/ipadic to provide /var/lib/mecab/dic/debian (mecab-dictionary) in auto modeSetting up libcgi-fast-perl (1:2.15-1) ...Setting up mysql-server-core-8.0 (8.0.23-0ubuntu0.20.04.1) ...Setting up mecab-ipadic-utf8 (2.7.0-20070801+main-2.1) ...Compiling IPA dictionary for Mecab. This takes long time...reading /usr/share/mecab/dic/ipadic/unk.def ... 40emitting double-array: 100% ###########################################/usr/share/mecab/dic/ipadic/model.def is not found. skipped.reading /usr/share/mecab/dic/ipadic/Noun.proper.csv ... 27328reading /usr/share/mecab/dic/ipadic/Verb.csv ... 130750reading /usr/share/mecab/dic/ipadic/Noun.name.csv ... 34202reading /usr/share/mecab/dic/ipadic/Prefix.csv ... 221reading /usr/share/mecab/dic/ipadic/Noun.adjv.csv ... 3328reading /usr/share/mecab/dic/ipadic/Noun.csv ... 60477reading /usr/share/mecab/dic/ipadic/Interjection.csv ... 252reading /usr/share/mecab/dic/ipadic/Adverb.csv ... 3032reading /usr/share/mecab/dic/ipadic/Adj.csv ... 27210reading /usr/share/mecab/dic/ipadic/Postp.csv ... 146reading /usr/share/mecab/dic/ipadic/Filler.csv ... 19reading /usr/share/mecab/dic/ipadic/Noun.demonst.csv ... 120reading /usr/share/mecab/dic/ipadic/Conjunction.csv ... 171reading /usr/share/mecab/dic/ipadic/Noun.nai.csv ... 42reading /usr/share/mecab/dic/ipadic/Noun.adverbal.csv ... 795reading /usr/share/mecab/dic/ipadic/Noun.number.csv ... 42reading /usr/share/mecab/dic/ipadic/Noun.verbal.csv ... 12146reading /usr/share/mecab/dic/ipadic/Postp-col.csv ... 91reading /usr/share/mecab/dic/ipadic/Adnominal.csv ... 135reading /usr/share/mecab/dic/ipadic/Others.csv ... 2reading /usr/share/mecab/dic/ipadic/Noun.org.csv ... 16668reading /usr/share/mecab/dic/ipadic/Noun.place.csv ... 72999reading /usr/share/mecab/dic/ipadic/Suffix.csv ... 1393reading /usr/share/mecab/dic/ipadic/Auxil.csv ... 199reading /usr/share/mecab/dic/ipadic/Noun.others.csv ... 151reading /usr/share/mecab/dic/ipadic/Symbol.csv ... 208emitting double-array: 100% ###########################################reading /usr/share/mecab/dic/ipadic/matrix.def ... 1316x1316emitting matrix : 100% ########################################### 2ff7e9595c
Comments