{"id":856,"date":"2021-09-14T14:55:28","date_gmt":"2021-09-14T05:55:28","guid":{"rendered":"https:\/\/pigletstory.co.kr\/729-2\/"},"modified":"2021-09-14T14:55:28","modified_gmt":"2021-09-14T05:55:28","slug":"729-2","status":"publish","type":"post","link":"https:\/\/pigletstory.co.kr\/?p=856","title":{"rendered":"[MySQL , MariaDB] mysql-bin(binary log)\ud30c\uc77c \uc815\ub9ac \ubc0f \uc0ad\uc81c \uc8fc\uae30 \uc124\uc815"},"content":{"rendered":"
\n

# mysql-bin(binary log)\ud30c\uc77c \uc815\ub9ac \ubc0f \uc0ad\uc81c \uc8fc\uae30 \uc124\uc815 #<\/p>\n

linux \uc5d0\uc11c mysql \ubc0f mariadb \uc124\uce58 \ud6c4 \ubb34\ud55c\uc815 \ub298\uc5b4\ub098\ub290 log-bin \ud30c\uc77c\uc5d0 \ub300\ud574<\/p>\n

\ud30c\uc77c \uc815\ub9ac \ubc0f \uc0ad\uc81c \uc8fc\uae30 \uc124\uc815\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud558 \uc124\uba85\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n

mysql-bin \ud30c\uc77c\uc740 db \uc5d0\uc11c \uc0ac\uc6a9\ub41c \ucffc\ub9ac\ub4e4\uc774\u00a0\ub85c\uae45\ub418\ub294\u00a0\ud30c\uc77c\uc774\uba70\u00a0Innodb\u00a0\ud639\uc740\u00a0Replication\ub4f1\uc5d0\uc11c\u00a0\uc0ac\uc6a9\ub418\uace4\u00a0\ud569\ub2c8\ub2e4.<\/p>\n

linux \uc5d0\uc11c db \uc124\uce58 \ud6c4 db \uacbd\ub85c\ub97c \ub530\ub85c \uc9c0\uc815\ud558\uc9c0 \uc54a\ub294\uacbd\uc6b0 default \uacbd\ub85c\ub294<\/p>\n

\/var\/lib\/mysql \uc785\ub2c8\ub2e4.<\/p>\n

\/ \uacbd\ub85c \ud558\uc704\uc774\ub2e4 \ubcf4\ub2c8 \uac11\uc790\uae30 \uc5b4\ub290\ub0a0 \/ \uacbd\ub85c\uac00 \ub9d0\ub3c4 \uc548\ub418\uac8c \ub298\uc5b4\ub098 \uc788\ub294 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\ub530\ub85c \/db \ub85c \ud30c\ud2f0\uc154\ub2dd\uc744 \ud55c \uacbd\uc6b0\ub3c4 \ub9c8\ucc2c\uac00\uc9c0\ub85c log-bin \ud30c\uc77c\uc758 \uc800\uc7a5 \uae30\ud55c\uc744 \uc124\uc815\ud558\uc9c0 \uc54a\ub294 \uc774\uc0c1<\/p>\n

log-bin \ud30c\uc77c\ub85c \uc778\ud574 \uc6a9\ub7c9\uc774 \ubb34\ud55c\uc815 \ub298\uc5b4\ub0a0 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n
[root@localhost\u00a0mysql]#\u00a0df\u00a0-h
Filesystem\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Size\u00a0\u00a0Used\u00a0Avail\u00a0Use%\u00a0Mounted\u00a0on
devtmpfs\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01.9G\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a01.9G\u00a0\u00a0\u00a00%\u00a0\/dev
tmpfs\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01.9G\u00a0\u00a04.0K\u00a0\u00a01.9G\u00a0\u00a0\u00a01%\u00a0\/dev\/shm
tmpfs\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01.9G\u00a0\u00a0\u00a013M\u00a0\u00a01.9G\u00a0\u00a0\u00a01%\u00a0\/run
tmpfs\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01.9G\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a01.9G\u00a0\u00a0\u00a00%\u00a0\/sys\/fs\/cgroup
\/dev\/sda2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a042G\u00a0\u00a0\u00a011G\u00a0\u00a0\u00a032G\u00a0\u00a026%\u00a0\/<\/b><\/span>
\/dev\/sda1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0497M\u00a0\u00a0173M\u00a0\u00a0324M\u00a0\u00a035%\u00a0\/boot
tmpfs\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0378M\u00a0\u00a0\u00a040K\u00a0\u00a0378M\u00a0\u00a0\u00a01%\u00a0\/run\/user\/0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n
[root@localhost mysql]# ll mysql-bin.*
-rw-rw—-\u00a01\u00a0mysql\u00a0mysql\u00a0\u00a0\u00a0\u00a0\u00a0723\u00a0\u00a03\uc6d4\u00a016\u00a014:07\u00a0mysql-bin.000001 <\/b>
-rw-rw—-\u00a01\u00a0mysql\u00a0mysql\u00a01013906\u00a0\u00a03\uc6d4\u00a016\u00a014:07\u00a0mysql-bin.000002 <\/b>
-rw-rw—-\u00a01\u00a0mysql\u00a0mysql\u00a0\u00a0179012\u00a0\u00a03\uc6d4\u00a016\u00a014:25\u00a0mysql-bin.000003 <\/b>
-rw-rw—-\u00a01\u00a0mysql\u00a0mysql\u00a0\u00a0181801\u00a0\u00a03\uc6d4\u00a017\u00a010:43\u00a0mysql-bin.000004 <\/b>
-rw-rw—-\u00a01\u00a0mysql\u00a0mysql\u00a0\u00a0\u00a059803\u00a0\u00a03\uc6d4\u00a017\u00a013:44\u00a0mysql-bin.000005 <\/b>
-rw-rw—-\u00a01\u00a0mysql\u00a0mysql\u00a0\u00a0\u00a0\u00a0\u00a0365\u00a0\u00a03\uc6d4\u00a017\u00a016:31\u00a0mysql-bin.000006 <\/b>
-rw-rw—-\u00a01\u00a0mysql\u00a0mysql\u00a0\u00a0\u00a059803\u00a0\u00a03\uc6d4\u00a023\u00a018:42\u00a0mysql-bin.000007 <\/b>
-rw-rw—-\u00a01\u00a0mysql\u00a0mysql\u00a0\u00a0\u00a059803\u00a0\u00a07\uc6d4\u00a015\u00a016:15\u00a0mysql-bin.000008 <\/b>
-rw-rw—-\u00a01\u00a0mysql\u00a0mysql\u00a0\u00a0316828\u00a0\u00a09\uc6d4\u00a0\u00a01\u00a009:51\u00a0mysql-bin.000009 <\/b>
-rw-rw—-\u00a01\u00a0mysql\u00a0mysql\u00a0\u00a0\u00a012269\u00a0\u00a09\uc6d4\u00a0\u00a01\u00a010:12\u00a0mysql-bin.000010 <\/b>
-rw-rw—-\u00a01\u00a0mysql\u00a0mysql\u00a0\u00a0\u00a065375\u00a0\u00a09\uc6d4\u00a0\u00a01\u00a010:16\u00a0mysql-bin.000011 <\/b>
-rw-rw—-\u00a01\u00a0mysql\u00a0mysql\u00a0\u00a0\u00a063141\u00a0\u00a09\uc6d4\u00a0\u00a01\u00a010:27\u00a0mysql-bin.000012 <\/b>
-rw-rw—-\u00a01\u00a0mysql\u00a0mysql\u00a0\u00a0\u00a059803\u00a0\u00a09\uc6d4\u00a0\u00a03\u00a015:02\u00a0mysql-bin.000013 <\/b>
-rw-rw—-\u00a01\u00a0mysql\u00a0mysql\u00a0\u00a0\u00a059803\u00a0\u00a09\uc6d4\u00a0\u00a07\u00a013:42\u00a0mysql-bin.000014 <\/b>
-rw-rw—-\u00a01\u00a0mysql\u00a0mysql\u00a0\u00a0\u00a059803\u00a0\u00a09\uc6d4\u00a0\u00a07\u00a013:53\u00a0mysql-bin.000015 <\/b>
-rw-rw—-\u00a01\u00a0mysql\u00a0mysql\u00a0\u00a0\u00a063374\u00a0\u00a09\uc6d4\u00a0\u00a07\u00a013:58\u00a0mysql-bin.000016 <\/b>
-rw-rw—-\u00a01\u00a0mysql\u00a0mysql\u00a0\u00a0\u00a059803\u00a0\u00a09\uc6d4\u00a0\u00a07\u00a014:26\u00a0mysql-bin.000017 <\/b>
-rw-rw—-\u00a01\u00a0mysql\u00a0mysql\u00a0\u00a0119241\u00a0\u00a09\uc6d4\u00a0\u00a07\u00a014:37\u00a0mysql-bin.000018 <\/b>
-rw-rw—-\u00a01\u00a0mysql\u00a0mysql\u00a0\u00a0\u00a080258\u00a0\u00a09\uc6d4\u00a014\u00a013:52\u00a0mysql-bin.000019<\/b>
-rw-rw—-\u00a01\u00a0mysql\u00a0mysql\u00a0\u00a0\u00a0\u00a0\u00a0361\u00a0\u00a09\uc6d4\u00a014\u00a013:44\u00a0mysql-bin.index<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

mysql-bin \ud30c\uc77c\uc740 OS \uc5d0\uc11c \uc0ad\uc81c\ud558\ub294\uac83 \ubcf4\ub2e4 mysql \ucf58\uc194\uc5d0\uc11c \uc0ad\uc81c \ud558\ub294\uac83\uc774 \ubc14\ub78c\uc9c1 \ud569\ub2c8\ub2e4.<\/p>\n

mysql \uc5d0\uc11c \uc81c\uacf5\ub418\ub294 \ud30c\uc77c\uc774\ubbc0\ub85c mysql \ucf58\uc194\uc5d0\uc11c \uc0ad\uc81c\ud558\ub294\uac83\uc774 \uae54\ub054\ud569\ub2c8\ub2e4.<\/p>\n

db \ub85c \uc811\uc18d \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n
[root@localhost\u00a0~]#\u00a0mysql\u00a0-uroot\u00a0-p
Enter\u00a0password:\u00a0
Welcome\u00a0to\u00a0the\u00a0MariaDB\u00a0monitor.\u00a0\u00a0Commands\u00a0end\u00a0with\u00a0;\u00a0or\u00a0g.
Your\u00a0MariaDB\u00a0connection\u00a0id\u00a0is\u00a0184
Server\u00a0version:\u00a010.2.37-MariaDB-log\u00a0MariaDB\u00a0Server <\/p>\n

Copyright\u00a0(c)\u00a02000,\u00a02018,\u00a0Oracle,\u00a0MariaDB\u00a0Corporation\u00a0Ab\u00a0and\u00a0others. <\/p>\n

Type\u00a0‘help;’\u00a0or\u00a0‘h’\u00a0for\u00a0help.\u00a0Type\u00a0‘c’\u00a0to\u00a0clear\u00a0the\u00a0current\u00a0input\u00a0statement. <\/p>\n

MariaDB\u00a0[(none)]>\u00a0use\u00a0mysql
Database\u00a0changed
MariaDB\u00a0[mysql]><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

mysql \ub85c\u00a0 \uc811\uc18d \ud6c4 \ud558\uae30 \uba85\ub839\uc5b4\ub85c \ud655\uc778 \uac00\ub2a5 \ud569\ub2c8\ub2e4.<\/p>\n

MariaDB\u00a0[mysql]>\u00a0show\u00a0binary\u00a0logs;<\/b><\/p>\n\n\n\n
MariaDB\u00a0[mysql]>\u00a0show\u00a0binary\u00a0logs;
+——————+———–+
|\u00a0Log_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0File_size\u00a0|
+——————+———–+
|\u00a0mysql-bin.000001\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0723\u00a0|
|\u00a0mysql-bin.000002\u00a0|\u00a0\u00a0\u00a01013906\u00a0|
|\u00a0mysql-bin.000003\u00a0|\u00a0\u00a0\u00a0\u00a0179012\u00a0|
|\u00a0mysql-bin.000004\u00a0|\u00a0\u00a0\u00a0\u00a0181801\u00a0|
|\u00a0mysql-bin.000005\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a059803\u00a0|
|\u00a0mysql-bin.000006\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0365\u00a0|
|\u00a0mysql-bin.000007\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a059803\u00a0|
|\u00a0mysql-bin.000008\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a059803\u00a0|
|\u00a0mysql-bin.000009\u00a0|\u00a0\u00a0\u00a0\u00a0316828\u00a0|
|\u00a0mysql-bin.000010\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a012269\u00a0|
|\u00a0mysql-bin.000011\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a065375\u00a0|
|\u00a0mysql-bin.000012\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a063141\u00a0|
|\u00a0mysql-bin.000013\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a059803\u00a0|
|\u00a0mysql-bin.000014\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a059803\u00a0|
|\u00a0mysql-bin.000015\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a059803\u00a0|
|\u00a0mysql-bin.000016\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a063374\u00a0|
|\u00a0mysql-bin.000017\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a059803\u00a0|
|\u00a0mysql-bin.000018\u00a0|\u00a0\u00a0\u00a0\u00a0119241\u00a0|
|\u00a0mysql-bin.000019\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a080258\u00a0|
+——————+———–+
19\u00a0rows\u00a0in\u00a0set\u00a0(0.00\u00a0sec)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\uc804\ubd80 \ub2e4 \uc0ad\uc81c\ud558\ub824\uba74 \uc81c\uc77c \ub9c8\uc9c0\ub9c9 \ubc88\ud638\uae4c\uc9c0 \uc785\ub825\ud574 \uc8fc\uc2dc\uba74 \ub429\ub2c8\ub2e4.<\/p>\n

*ex)purge master logs to ‘mysql-bin.000019’;<\/b><\/p>\n

000014 \ubc88 \uc774\uc804\uc758 \ub85c\uadf8\ub9cc \uc0ad\uc81c\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n

MariaDB\u00a0[mysql]>\u00a0purge\u00a0master\u00a0logs\u00a0to\u00a0‘mysql-bin.000014’;<\/b><\/p>\n\n\n\n
MariaDB\u00a0[mysql]>\u00a0purge\u00a0master\u00a0logs\u00a0to\u00a0‘mysql-bin.000014’;
Query\u00a0OK,\u00a00\u00a0rows\u00a0affected\u00a0(0.00\u00a0sec) <\/p>\n

MariaDB\u00a0[mysql]>\u00a0show\u00a0binary\u00a0logs;
+——————+———–+
|\u00a0Log_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0File_size\u00a0|
+——————+———–+
|\u00a0mysql-bin.000014\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a059803\u00a0|
|\u00a0mysql-bin.000015\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a059803\u00a0|
|\u00a0mysql-bin.000016\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a063374\u00a0|
|\u00a0mysql-bin.000017\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a059803\u00a0|
|\u00a0mysql-bin.000018\u00a0|\u00a0\u00a0\u00a0\u00a0119241\u00a0|
|\u00a0mysql-bin.000019\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a080258\u00a0|
+——————+———–+
6\u00a0rows\u00a0in\u00a0set\u00a0(0.00\u00a0sec)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\uc0ad\uc81c \ud6c4 \ub9e4\ubc88 \uc0ad\uc81c\ub97c \ud558\uae30\ub294 \uadc0\ucc2e\uc73c\ub2c8 \uc790\ub3d9 \uc0ad\uc81c \uc8fc\uae30\ub97c \uc124\uc815\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n

\uc0ad\uc81c \uc8fc\uae30\ub294 \uc2dc\uc2a4\ud15c \uc0ac\uace0\uac00 \ubc1c\uc0dd\ud574\ub3c4 \uba87\uc77c \ub0b4\uc5d0 \ud655\uc778\ud560 \uc218 \uc788\uac70\ub098 \ud2b9\ubcc4\ud788 \ubc31\uc5c5\ud574 \ubd84\uc11d\ud560 \uac83\uc774 \uc544\ub2c8\ub77c\uba74 2\uc8fc \uc815\ub3c4\uba74 \ucda9\ubd84 \ud569\ub2c8\ub2e4.<\/p>\n

\u00a0<\/p>\n

# \ubcf4\uad00\uc8fc\uae30 \ud655\uc778 #<\/p>\n

\uae30\uc874 expire_logs_days \uac00 ‘0’ \uc774\ub77c\uba74 \uc0ad\uc81c\ub418\uc9c0 \uc54a\uace0 \uacc4\uc18d \uc800\uc7a5\uc774 \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n
MariaDB\u00a0[mysql]>\u00a0SHOW\u00a0VARIABLES\u00a0LIKE\u00a0‘%expire_logs%’;
+——————+——-+
|\u00a0Variable_name\u00a0\u00a0\u00a0\u00a0|\u00a0Value\u00a0|
+——————+——-+
| expire_logs_days | 0\u00a0 \u00a0 \u00a0|
+——————+——-+
1\u00a0row\u00a0in\u00a0set\u00a0(0.00\u00a0sec)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

# \ubcf4\uad00\uc8fc\uae30 14\uc77c\ub85c \ubcc0\uacbd \ud6c4 \ub2e4\uc2dc \ud655\uc778 #<\/p>\n\n\n\n
MariaDB\u00a0[mysql]>\u00a0set\u00a0global\u00a0expire_logs_days=14;
Query\u00a0OK,\u00a00\u00a0rows\u00a0affected\u00a0(0.00\u00a0sec)<\/p>\n

MariaDB\u00a0[mysql]>\u00a0SHOW\u00a0VARIABLES\u00a0LIKE\u00a0‘%expire_logs%’;
+——————+——-+
|\u00a0Variable_name\u00a0\u00a0\u00a0\u00a0|\u00a0Value\u00a0|
+——————+——-+
|\u00a0expire_logs_days\u00a0|\u00a014\u00a0\u00a0\u00a0\u00a0|
+——————+——-+
1\u00a0row\u00a0in\u00a0set\u00a0(0.00\u00a0sec)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

14\uc77c\uc774 \uc9c0\ub09c \ud30c\uc77c\ub4e4\uc740 \uc0ad\uc81c\uac00 \ub429\ub2c8\ub2e4.<\/p>\n

\uc544\uc608 \uc0dd\uc131\ud558\uace0 \uc2f6\uc9c0 \uc54a\ub2e4\uba74 \ud558\uae30 \uacbd\ub85c\ub85c \ub4e4\uc5b4\uac00 log-bin \uacbd\ub85c\ub97c \uc8fc\uc11d\ucc98\ub9ac \ud574\uc8fc\uc2dc\uba74 \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n
[root@localhost\u00a0\/]#\u00a0vi\u00a0\/etc\/my.cnf
# log-bin=mysql-bin<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/p>\n

end.<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"

# mysql-bin(binary log)\ud30c\uc77c \uc815\ub9ac \ubc0f \uc0ad\uc81c \uc8fc\uae30 \uc124\uc815 # linux \uc5d0\uc11c mysql \ubc0f mariadb \uc124\uce58 \ud6c4 \ubb34\ud55c\uc815 \ub298\uc5b4\ub098\ub290 log-bin \ud30c\uc77c\uc5d0 \ub300\ud574 \ud30c\uc77c \uc815\ub9ac \ubc0f \uc0ad\uc81c \uc8fc\uae30 \uc124\uc815\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud558 \uc124\uba85\ud558\uaca0\uc2b5\ub2c8\ub2e4. mysql-bin \ud30c\uc77c\uc740 db \uc5d0\uc11c \uc0ac\uc6a9\ub41c \ucffc\ub9ac\ub4e4\uc774\u00a0\ub85c\uae45\ub418\ub294\u00a0\ud30c\uc77c\uc774\uba70\u00a0Innodb\u00a0\ud639\uc740\u00a0Replication\ub4f1\uc5d0\uc11c\u00a0\uc0ac\uc6a9\ub418\uace4\u00a0\ud569\ub2c8\ub2e4. linux \uc5d0\uc11c db \uc124\uce58 \ud6c4 db \uacbd\ub85c\ub97c \ub530\ub85c \uc9c0\uc815\ud558\uc9c0 \uc54a\ub294\uacbd\uc6b0 default \uacbd\ub85c\ub294 \/var\/lib\/mysql \uc785\ub2c8\ub2e4. \/ \uacbd\ub85c \ud558\uc704\uc774\ub2e4 \ubcf4\ub2c8 \uac11\uc790\uae30 … \ub354 \uc77d\uae30<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[7],"tags":[95,98,103,107],"class_list":["post-856","post","type-post","status-publish","format-standard","hentry","category-mariadb","tag-mariadb-binary","tag-mariadb-bin","tag-mysql-binary-log","tag-mysql-bin"],"yoast_head":"\n[MySQL , MariaDB] mysql-bin(binary log)\ud30c\uc77c \uc815\ub9ac \ubc0f \uc0ad\uc81c \uc8fc\uae30 \uc124\uc815 - pigletstory \ube14\ub85c\uadf8<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pigletstory.co.kr\/?p=856\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[MySQL , MariaDB] mysql-bin(binary log)\ud30c\uc77c \uc815\ub9ac \ubc0f \uc0ad\uc81c \uc8fc\uae30 \uc124\uc815 - pigletstory \ube14\ub85c\uadf8\" \/>\n<meta property=\"og:description\" content=\"# mysql-bin(binary log)\ud30c\uc77c \uc815\ub9ac \ubc0f \uc0ad\uc81c \uc8fc\uae30 \uc124\uc815 # linux \uc5d0\uc11c mysql \ubc0f mariadb \uc124\uce58 \ud6c4 \ubb34\ud55c\uc815 \ub298\uc5b4\ub098\ub290 log-bin \ud30c\uc77c\uc5d0 \ub300\ud574 \ud30c\uc77c \uc815\ub9ac \ubc0f \uc0ad\uc81c \uc8fc\uae30 \uc124\uc815\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud558 \uc124\uba85\ud558\uaca0\uc2b5\ub2c8\ub2e4. mysql-bin \ud30c\uc77c\uc740 db \uc5d0\uc11c \uc0ac\uc6a9\ub41c \ucffc\ub9ac\ub4e4\uc774\u00a0\ub85c\uae45\ub418\ub294\u00a0\ud30c\uc77c\uc774\uba70\u00a0Innodb\u00a0\ud639\uc740\u00a0Replication\ub4f1\uc5d0\uc11c\u00a0\uc0ac\uc6a9\ub418\uace4\u00a0\ud569\ub2c8\ub2e4. linux \uc5d0\uc11c db \uc124\uce58 \ud6c4 db \uacbd\ub85c\ub97c \ub530\ub85c \uc9c0\uc815\ud558\uc9c0 \uc54a\ub294\uacbd\uc6b0 default \uacbd\ub85c\ub294 \/var\/lib\/mysql \uc785\ub2c8\ub2e4. \/ \uacbd\ub85c \ud558\uc704\uc774\ub2e4 \ubcf4\ub2c8 \uac11\uc790\uae30 ... \ub354 \uc77d\uae30\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pigletstory.co.kr\/?p=856\" \/>\n<meta property=\"og:site_name\" content=\"pigletstory \ube14\ub85c\uadf8\" \/>\n<meta property=\"article:published_time\" content=\"2021-09-14T05:55:28+00:00\" \/>\n<meta name=\"author\" content=\"woo\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\uae00\uc4f4\uc774\" \/>\n\t<meta name=\"twitter:data1\" content=\"woo\" \/>\n\t<meta name=\"twitter:label2\" content=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data2\" content=\"2\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/?p=856#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/?p=856\"},\"author\":{\"name\":\"woo\",\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/#\\\/schema\\\/person\\\/d7120640ee051cf680fd1c6a5208d620\"},\"headline\":\"[MySQL , MariaDB] mysql-bin(binary log)\ud30c\uc77c \uc815\ub9ac \ubc0f \uc0ad\uc81c \uc8fc\uae30 \uc124\uc815\",\"datePublished\":\"2021-09-14T05:55:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/?p=856\"},\"wordCount\":400,\"commentCount\":0,\"keywords\":[\"mariadb binary\",\"mariadb-bin\",\"mysql binary log\",\"mysql-bin\"],\"articleSection\":[\"MariaDB\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/pigletstory.co.kr\\\/?p=856#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/?p=856\",\"url\":\"https:\\\/\\\/pigletstory.co.kr\\\/?p=856\",\"name\":\"[MySQL , MariaDB] mysql-bin(binary log)\ud30c\uc77c \uc815\ub9ac \ubc0f \uc0ad\uc81c \uc8fc\uae30 \uc124\uc815 - pigletstory \ube14\ub85c\uadf8\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/#website\"},\"datePublished\":\"2021-09-14T05:55:28+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/#\\\/schema\\\/person\\\/d7120640ee051cf680fd1c6a5208d620\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/?p=856#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/pigletstory.co.kr\\\/?p=856\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/?p=856#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pigletstory.co.kr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[MySQL , MariaDB] mysql-bin(binary log)\ud30c\uc77c \uc815\ub9ac \ubc0f \uc0ad\uc81c \uc8fc\uae30 \uc124\uc815\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/#website\",\"url\":\"https:\\\/\\\/pigletstory.co.kr\\\/\",\"name\":\"pigletstory \ube14\ub85c\uadf8\",\"description\":\"pigletstory\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pigletstory.co.kr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/#\\\/schema\\\/person\\\/d7120640ee051cf680fd1c6a5208d620\",\"name\":\"woo\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f7d07f5222a5108393f05e78f2bac1e7acbea452123f477645ad4dc5696acc36?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f7d07f5222a5108393f05e78f2bac1e7acbea452123f477645ad4dc5696acc36?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f7d07f5222a5108393f05e78f2bac1e7acbea452123f477645ad4dc5696acc36?s=96&d=mm&r=g\",\"caption\":\"woo\"},\"sameAs\":[\"http:\\\/\\\/129.154.62.45\"],\"url\":\"https:\\\/\\\/pigletstory.co.kr\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[MySQL , MariaDB] mysql-bin(binary log)\ud30c\uc77c \uc815\ub9ac \ubc0f \uc0ad\uc81c \uc8fc\uae30 \uc124\uc815 - pigletstory \ube14\ub85c\uadf8","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/pigletstory.co.kr\/?p=856","og_locale":"ko_KR","og_type":"article","og_title":"[MySQL , MariaDB] mysql-bin(binary log)\ud30c\uc77c \uc815\ub9ac \ubc0f \uc0ad\uc81c \uc8fc\uae30 \uc124\uc815 - pigletstory \ube14\ub85c\uadf8","og_description":"# mysql-bin(binary log)\ud30c\uc77c \uc815\ub9ac \ubc0f \uc0ad\uc81c \uc8fc\uae30 \uc124\uc815 # linux \uc5d0\uc11c mysql \ubc0f mariadb \uc124\uce58 \ud6c4 \ubb34\ud55c\uc815 \ub298\uc5b4\ub098\ub290 log-bin \ud30c\uc77c\uc5d0 \ub300\ud574 \ud30c\uc77c \uc815\ub9ac \ubc0f \uc0ad\uc81c \uc8fc\uae30 \uc124\uc815\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud558 \uc124\uba85\ud558\uaca0\uc2b5\ub2c8\ub2e4. mysql-bin \ud30c\uc77c\uc740 db \uc5d0\uc11c \uc0ac\uc6a9\ub41c \ucffc\ub9ac\ub4e4\uc774\u00a0\ub85c\uae45\ub418\ub294\u00a0\ud30c\uc77c\uc774\uba70\u00a0Innodb\u00a0\ud639\uc740\u00a0Replication\ub4f1\uc5d0\uc11c\u00a0\uc0ac\uc6a9\ub418\uace4\u00a0\ud569\ub2c8\ub2e4. linux \uc5d0\uc11c db \uc124\uce58 \ud6c4 db \uacbd\ub85c\ub97c \ub530\ub85c \uc9c0\uc815\ud558\uc9c0 \uc54a\ub294\uacbd\uc6b0 default \uacbd\ub85c\ub294 \/var\/lib\/mysql \uc785\ub2c8\ub2e4. \/ \uacbd\ub85c \ud558\uc704\uc774\ub2e4 \ubcf4\ub2c8 \uac11\uc790\uae30 ... \ub354 \uc77d\uae30","og_url":"https:\/\/pigletstory.co.kr\/?p=856","og_site_name":"pigletstory \ube14\ub85c\uadf8","article_published_time":"2021-09-14T05:55:28+00:00","author":"woo","twitter_card":"summary_large_image","twitter_misc":{"\uae00\uc4f4\uc774":"woo","\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"2\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pigletstory.co.kr\/?p=856#article","isPartOf":{"@id":"https:\/\/pigletstory.co.kr\/?p=856"},"author":{"name":"woo","@id":"https:\/\/pigletstory.co.kr\/#\/schema\/person\/d7120640ee051cf680fd1c6a5208d620"},"headline":"[MySQL , MariaDB] mysql-bin(binary log)\ud30c\uc77c \uc815\ub9ac \ubc0f \uc0ad\uc81c \uc8fc\uae30 \uc124\uc815","datePublished":"2021-09-14T05:55:28+00:00","mainEntityOfPage":{"@id":"https:\/\/pigletstory.co.kr\/?p=856"},"wordCount":400,"commentCount":0,"keywords":["mariadb binary","mariadb-bin","mysql binary log","mysql-bin"],"articleSection":["MariaDB"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/pigletstory.co.kr\/?p=856#respond"]}]},{"@type":"WebPage","@id":"https:\/\/pigletstory.co.kr\/?p=856","url":"https:\/\/pigletstory.co.kr\/?p=856","name":"[MySQL , MariaDB] mysql-bin(binary log)\ud30c\uc77c \uc815\ub9ac \ubc0f \uc0ad\uc81c \uc8fc\uae30 \uc124\uc815 - pigletstory \ube14\ub85c\uadf8","isPartOf":{"@id":"https:\/\/pigletstory.co.kr\/#website"},"datePublished":"2021-09-14T05:55:28+00:00","author":{"@id":"https:\/\/pigletstory.co.kr\/#\/schema\/person\/d7120640ee051cf680fd1c6a5208d620"},"breadcrumb":{"@id":"https:\/\/pigletstory.co.kr\/?p=856#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pigletstory.co.kr\/?p=856"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/pigletstory.co.kr\/?p=856#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pigletstory.co.kr\/"},{"@type":"ListItem","position":2,"name":"[MySQL , MariaDB] mysql-bin(binary log)\ud30c\uc77c \uc815\ub9ac \ubc0f \uc0ad\uc81c \uc8fc\uae30 \uc124\uc815"}]},{"@type":"WebSite","@id":"https:\/\/pigletstory.co.kr\/#website","url":"https:\/\/pigletstory.co.kr\/","name":"pigletstory \ube14\ub85c\uadf8","description":"pigletstory","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pigletstory.co.kr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Person","@id":"https:\/\/pigletstory.co.kr\/#\/schema\/person\/d7120640ee051cf680fd1c6a5208d620","name":"woo","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/secure.gravatar.com\/avatar\/f7d07f5222a5108393f05e78f2bac1e7acbea452123f477645ad4dc5696acc36?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f7d07f5222a5108393f05e78f2bac1e7acbea452123f477645ad4dc5696acc36?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f7d07f5222a5108393f05e78f2bac1e7acbea452123f477645ad4dc5696acc36?s=96&d=mm&r=g","caption":"woo"},"sameAs":["http:\/\/129.154.62.45"],"url":"https:\/\/pigletstory.co.kr\/?author=1"}]}},"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/856","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=856"}],"version-history":[{"count":0,"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/856\/revisions"}],"wp:attachment":[{"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=856"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=856"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=856"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}