| Server IP : 103.119.228.120 / Your IP : 3.145.9.200 Web Server : Apache System : Linux v8.techscape8.com 3.10.0-1160.119.1.el7.tuxcare.els2.x86_64 #1 SMP Mon Jul 15 12:09:18 UTC 2024 x86_64 User : nobody ( 99) PHP Version : 5.6.40 Disable Function : shell_exec,symlink,system,exec,proc_get_status,proc_nice,proc_terminate,define_syslog_variables,syslog,openlog,closelog,escapeshellcmd,passthru,ocinum cols,ini_alter,leak,listen,chgrp,apache_note,apache_setenv,debugger_on,debugger_off,ftp_exec,dl,dll,myshellexec,proc_open,socket_bind,proc_close,escapeshellarg,parse_ini_filepopen,fpassthru,exec,passthru,escapeshellarg,escapeshellcmd,proc_close,proc_open,ini_alter,popen,show_source,proc_nice,proc_terminate,proc_get_status,proc_close,pfsockopen,leak,apache_child_terminate,posix_kill,posix_mkfifo,posix_setpgid,posix_setsid,posix_setuid,dl,symlink,shell_exec,system,dl,passthru,escapeshellarg,escapeshellcmd,myshellexec,c99_buff_prepare,c99_sess_put,fpassthru,getdisfunc,fx29exec,fx29exec2,is_windows,disp_freespace,fx29sh_getupdate,fx29_buff_prepare,fx29_sess_put,fx29shexit,fx29fsearch,fx29ftpbrutecheck,fx29sh_tools,fx29sh_about,milw0rm,imagez,sh_name,myshellexec,checkproxyhost,dosyayicek,c99_buff_prepare,c99_sess_put,c99getsource,c99sh_getupdate,c99fsearch,c99shexit,view_perms,posix_getpwuid,posix_getgrgid,posix_kill,parse_perms,parsesort,view_perms_color,set_encoder_input,ls_setcheckboxall,ls_reverse_all,rsg_read,rsg_glob,selfURL,dispsecinfo,unix2DosTime,addFile,system,get_users,view_size,DirFiles,DirFilesWide,DirPrintHTMLHeaders,GetFilesTotal,GetTitles,GetTimeTotal,GetMatchesCount,GetFileMatchesCount,GetResultFiles,fs_copy_dir,fs_copy_obj,fs_move_dir,fs_move_obj,fs_rmdir,SearchText,getmicrotime MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/share/mysqlsh/adminapi-metadata/ |
Upload File : |
/* * Copyright (c) 2020, 2024, Oracle and/or its affiliates. * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License, version 2.0, * as published by the Free Software Foundation. * * This program is designed to work with certain software (including * but not limited to OpenSSL) that is licensed under separate terms, * as designated in a particular file or component or in included license * documentation. The authors of MySQL hereby grant you an additional * permission to link the program and your derivative works with the * separately licensed software that they have either included with * the program or referenced in the documentation. * * This program is distributed in the hope that it will be useful, but * WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See * the GNU General Public License, version 2.0, for more details. * * You should have received a copy of the GNU General Public License * along with this program; if not, write to the Free Software Foundation, Inc., * 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA */ /* * A metadata schema upgrade file must contain the following structure: * * 1) Version Tags indicating the source and target versions this upgrade script * handles, the format is: * * -- Source: <major>.<minor>.<patch> * -- Target: <major>.<minor>.<patch> * * 2) PRE SQL Statements: Statements to be executed before the actual migration * takes place, examples of statements include (but not limited to): * * - Data Backup * - Removal of conflicting objects: views, stored procedures * * 3) Metadata Deploy Tag: Indicates the target metadata schema to be deployed * once the PRE SQL statements are executed, the format is: * * -- Deploy: METADATA_MODEL_<major>_<minor>_<patch> * * This model will be taken from a sql file named: * * metadata-model-<major>-<minor>-<patch>.sql * * 4) POST SQL statements: Statements to be executed after the target metadata * model script has been executed, examples of statements include (but not * limited to): * * - Data Migration Statements * - Data Transformation Statements * - Cleanup */ -- Source: 2.0.0 -- Target: 2.1.0 -- PRE SQL Statements USE mysql_innodb_cluster_metadata; ALTER TABLE `mysql_innodb_cluster_metadata`.`clusters` ADD COLUMN `clusterset_id` VARCHAR(36) CHARACTER SET 'ascii' NULL DEFAULT NULL AFTER `router_options`, CHANGE COLUMN `cluster_id` `cluster_id` CHAR(36) CHARACTER SET 'ascii' NOT NULL; ALTER TABLE `mysql_innodb_cluster_metadata`.`clusters` MODIFY `cluster_name` VARCHAR(63) NOT NULL; ALTER TABLE `mysql_innodb_cluster_metadata`.`clusters` ADD UNIQUE (cluster_name); ALTER TABLE `mysql_innodb_cluster_metadata`.`instances` MODIFY `mysql_server_uuid` CHAR(36) NOT NULL; ALTER TABLE `mysql_innodb_cluster_metadata`.`routers` ADD COLUMN `clusterset_id` VARCHAR(36) CHARACTER SET 'ascii' NULL DEFAULT NULL AFTER `options`; -- Deploy: METADATA_MODEL_2_1_0 -- POST SQL Statements /* Migrates the data from the mysql_innodb_cluster_metadata_previous taken by the * upgrade engine before the upgrade is started. */ DELIMITER ;