So the other day I performed an upgrade of MySQL on a linode and notice that it wont start if I kept my old my.cnf file. <\/p>\n
[text]
\n[11:47:06] user@linode1: ~ $ echo ‘SHOW VARIABLES LIKE "%version%";’ | mysql -u username -ppassword | grep innodb
\ninnodb_version 5.5.31
\n[11:47:20] user@linode1: ~ $
\n[\/text]<\/p>\n
[text]
\n131022 08:17:56 mysqld_safe Starting mysqld daemon with databases from \/var\/lib\/mysql
\n131022 8:17:56 [ERROR] An old style –language value with language specific part detected: \/usr\/share\/mysql\/english\/
\n131022 8:17:56 [ERROR] Use –lc-messages-dir without language specific part instead.
\n131022 8:17:56 [Note] Plugin ‘FEDERATED’ is disabled.
\n131022 8:17:56 InnoDB: The InnoDB memory heap is disabled
\n131022 8:17:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins
\n131022 8:17:56 InnoDB: Compressed tables use zlib 1.2.7
\n131022 8:17:56 InnoDB: Using Linux native AIO
\n131022 8:17:56 InnoDB: Initializing buffer pool, size = 128.0M
\n131022 8:17:56 InnoDB: Completed initialization of buffer pool
\n131022 8:17:56 InnoDB: highest supported file format is Barracuda.
\n131022 8:17:56 InnoDB: Waiting for the background threads to start
\n131022 8:17:57 InnoDB: 5.5.31 started; log sequence number 1678395
\n131022 8:17:57 [ERROR] \/usr\/sbin\/mysqld: unknown variable ‘master-host=192.168.140.120′
\n131022 8:17:57 [ERROR] Aborting
\n[\/text]
\nThing is the replication entries in my.cnf need to be removed\/commented out and salve needs to be set up from MySQL console.<\/p>\n
So here is my new my.cnf.<\/p>\n
[11:34:25] xavi@linode1: ~ $ sudo grep -v “^#” \/etc\/mysql\/my.cnf | grep -v “^$”
\n[text]
\n[client]
\nport = 3306
\nsocket = \/var\/run\/mysqld\/mysqld.sock
\n[mysqld_safe]
\nsocket = \/var\/run\/mysqld\/mysqld.sock
\nnice = 0
\n[mysqld]
\nserver-id = 2
\nuser = mysql
\npid-file = \/var\/run\/mysqld\/mysqld.pid
\nsocket = \/var\/run\/mysqld\/mysqld.sock
\nport = 3306
\nbasedir = \/usr
\ndatadir = \/var\/lib\/mysql
\ntmpdir = \/tmp
\nlanguage = \/usr\/share\/mysql\/english
\nskip-external-locking
\nbind-address = 192.168.137.234
\nkey_buffer = 16M
\nmax_allowed_packet = 16M
\nthread_stack = 128K
\nthread_cache_size = 8
\nmyisam-recover = BACKUP
\nquery_cache_limit = 1M
\nquery_cache_size = 16M
\nexpire_logs_days = 10
\nmax_binlog_size = 100M
\n[mysqldump]
\nquick
\nquote-names
\nmax_allowed_packet = 16M
\n[mysql]
\n[isamchk]
\nkey_buffer = 16M
\n!includedir \/etc\/mysql\/conf.d\/
\n[\/text]
\n[11:34:37] xavi@linode1: ~ $ <\/p>\n
We load the above file or similar depending on your configuration. Now to configure slave we log into the MySQL CLI.<\/p>\n
[text][\/text]
\nmysql> STOP SLAVE;
\nmysql> CHANGE MASTER TO MASTER_HOST=’192.168.140.120′, MASTER_USER=’replication-user’, MASTER_PASSWORD=’password’, MASTER_LOG_FILE=’mysql-bin.000747′, MASTER_LOG_POS=75797;
\nmysql> START SLAVE;
\n[\/text]<\/p>\n
That’s it.<\/p>\n","protected":false},"excerpt":{"rendered":"
So the other day I performed an upgrade of MySQL on a linode and notice that it wont start if I kept my old my.cnf file. [text] [11:47:06] user@linode1: ~ $ echo ‘SHOW VARIABLES LIKE "%version%";’ | mysql -u username -ppassword | grep innodb innodb_version 5.5.31 [11:47:20] user@linode1: ~ $ [\/text] [text] 131022 08:17:56 mysqld_safe […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[3],"tags":[56,6,51,70],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/pTQgt-eh","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.xavignu.com\/index.php?rest_route=\/wp\/v2\/posts\/885"}],"collection":[{"href":"https:\/\/www.xavignu.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xavignu.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xavignu.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xavignu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=885"}],"version-history":[{"count":10,"href":"https:\/\/www.xavignu.com\/index.php?rest_route=\/wp\/v2\/posts\/885\/revisions"}],"predecessor-version":[{"id":896,"href":"https:\/\/www.xavignu.com\/index.php?rest_route=\/wp\/v2\/posts\/885\/revisions\/896"}],"wp:attachment":[{"href":"https:\/\/www.xavignu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=885"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xavignu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=885"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xavignu.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=885"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}