<kbd id="afajh"><form id="afajh"></form></kbd>
<strong id="afajh"><dl id="afajh"></dl></strong>
    <del id="afajh"><form id="afajh"></form></del>
        1. <th id="afajh"><progress id="afajh"></progress></th>
          <b id="afajh"><abbr id="afajh"></abbr></b>
          <th id="afajh"><progress id="afajh"></progress></th>

          Mysql雙主雙從(實(shí)戰(zhàn)干貨,好文章!?。?/h1>

          共 14309字,需瀏覽 29分鐘

           ·

          2021-04-27 23:35

          1.機(jī)器說明



          因?yàn)橹?,從2,都是通過同一個(gè)鏡像生成的系統(tǒng),所以mysql的 server-uuid 是一樣的,在配置前,需要做以下操作

          重命名 /var/lib/mysql/auto.cnf 文件

          mv auto.cnf auto.cnf.bak

          重啟mysql 重新生成 auto.cnf 文件





          因?yàn)橹芭渲眠^ ali-shuidi01,ali-shuidi02的主從關(guān)系,所以先將兩者之前的主從關(guān)系取消,在master1上執(zhí)行

           
          1. mysql> stop slave;

          2. Query OK, 0 rows affected, 1 warning (0.00 sec)


          3. mysql> reset master;

          4. Query OK, 0 rows affected (0.01 sec)


          2. master1 配置文件修改

          vim /etc/my.cnf


           
          1. #主服務(wù)器唯一ID

          2. server-id=1

          3. #啟用二進(jìn)制日志

          4. log-bin=mysql-bin

          5. # 設(shè)置不要復(fù)制的數(shù)據(jù)庫(可設(shè)置多個(gè))

          6. binlog-ignore-db=mysql

          7. binlog-ignore-db=information_schema

          8. binlog-ignore-db=performance_schema

          9. binlog-ignore-db=sys

          10. #設(shè)置需要復(fù)制的數(shù)據(jù)庫

          11. binlog-do-db=copydb2

          12. #設(shè)置logbin格式

          13. binlog_format=STATEMENT

          14. # 在作為從數(shù)據(jù)庫的時(shí)候,有寫入操作也要更新二進(jìn)制日志文件

          15. log-slave-updates

          16. #表示自增長字段每次遞增的量,指自增字段的起始值,其默認(rèn)值是1,取值范圍是1 .. 65535

          17. auto-increment-increment=2

          18. # 表示自增長字段從哪個(gè)數(shù)開始,指字段一次遞增多少,他的取值范圍是1 .. 65535

          19. auto-increment-offset=1


          3. master2 配置文件修改

          vim /etc/my.cnf


           
          1. #主服務(wù)器唯一ID

          2. server-id=3

          3. #啟用二進(jìn)制日志

          4. log-bin=mysql-bin

          5. # 設(shè)置不要復(fù)制的數(shù)據(jù)庫(可設(shè)置多個(gè))

          6. binlog-ignore-db=mysql

          7. binlog-ignore-db=information_schema

          8. binlog-ignore-db=performance_schema

          9. binlog-ignore-db=sys

          10. #設(shè)置需要復(fù)制的數(shù)據(jù)庫

          11. binlog-do-db=copydb2

          12. #設(shè)置logbin格式

          13. binlog_format=STATEMENT

          14. # 在作為從數(shù)據(jù)庫的時(shí)候,有寫入操作也要更新二進(jìn)制日志文件

          15. log-slave-updates

          16. #表示自增長字段每次遞增的量,指自增字段的起始值,其默認(rèn)值是1,取值范圍是1 .. 65535

          17. auto-increment-increment=2

          18. # 表示自增長字段從哪個(gè)數(shù)開始,指字段一次遞增多少,他的取值范圍是1 .. 65535

          19. auto-increment-offset=2


          4. slave1 配置文件修改

          vim /etc/my.cnf


           
          1. #從服務(wù)器唯一ID

          2. server-id=2

          3. #啟用中繼日志

          4. relay-log=mysql-relay


          5. slave2配置文件修改


          vim /etc/my.cnf


           
          1. #從服務(wù)器唯一ID

          2. server-id=4 #啟用中繼日志

          3. relay-log=mysql-relay


          6. 雙主機(jī)、雙從機(jī)重啟 mysql 服務(wù), 主機(jī)從機(jī)都關(guān)閉防火墻


           
          1. [root@shuidi01 etc]# systemctl restart mysqld

          2. [root@shuidi01 etc]# systemctl status mysqld

          3. ● mysqld.service - MySQL Server

          4. Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)

          5. Active: active (running) since 一 2020-03-30 20:38:23 CST; 6s ago

          6. Docs: man:mysqld(8)

          7. http://dev.mysql.com/doc/refman/en/using-systemd.html

          8. Process: 9985 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)

          9. Process: 9946 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)

          10. Main PID: 9990 (mysqld)

          11. CGroup: /system.slice/mysqld.service

          12. └─9990 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid


          13. 3月 30 20:38:22 shuidi01 systemd[1]: Starting MySQL Server...

          14. 3月 30 20:38:23 shuidi01 systemd[1]: Started MySQL Server.


           
          1. [root@shuidi02 etc]# systemctl restart mysqld

          2. [root@shuidi02 etc]# systemctl status mysqld

          3. ● mysqld.service - MySQL Server

          4. Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)

          5. Active: active (running) since 一 2020-03-30 20:39:10 CST; 7s ago

          6. Docs: man:mysqld(8)

          7. http://dev.mysql.com/doc/refman/en/using-systemd.html

          8. Process: 868 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)

          9. Process: 845 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)

          10. Main PID: 873 (mysqld)

          11. CGroup: /system.slice/mysqld.service

          12. └─873 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid


          13. 3月 30 20:39:09 shuidi02 systemd[1]: Starting MySQL Server...

          14. 3月 30 20:39:10 shuidi02 systemd[1]: Started MySQL Server.


           
          1. [root@shuidi03 etc]# systemctl restart mysqld

          2. [root@shuidi03 etc]# systemctl status mysqld

          3. ● mysqld.service - MySQL Server

          4. Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)

          5. Active: active (running) since 一 2020-03-30 20:39:42 CST; 5s ago

          6. Docs: man:mysqld(8)

          7. http://dev.mysql.com/doc/refman/en/using-systemd.html

          8. Process: 8507 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)

          9. Process: 8485 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)

          10. Main PID: 8512 (mysqld)

          11. CGroup: /system.slice/mysqld.service

          12. └─8512 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid


          13. 3月 30 20:39:41 shuidi03 systemd[1]: Starting MySQL Server...

          14. 3月 30 20:39:42 shuidi03 systemd[1]: Started MySQL Server.


           
          1. [root@shuidi04 etc]# systemctl restart mysqld

          2. [root@shuidi04 etc]# systemctl status mysqld

          3. ● mysqld.service - MySQL Server

          4. Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)

          5. Active: active (running) since 一 2020-03-30 20:40:13 CST; 8s ago

          6. Docs: man:mysqld(8)

          7. http://dev.mysql.com/doc/refman/en/using-systemd.html

          8. Process: 8861 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)

          9. Process: 8839 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)

          10. Main PID: 8866 (mysqld)

          11. CGroup: /system.slice/mysqld.service

          12. └─8866 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid


          13. 3月 30 20:40:12 shuidi04 systemd[1]: Starting MySQL Server...

          14. 3月 30 20:40:13 shuidi04 systemd[1]: Started MySQL Server.


          7. 在兩臺主機(jī)上建立賬戶并授權(quán) slave

          master1:

           
          1. mysql> GRANT REPLICATION SLAVE ON *.* TO 'slave'@'%' IDENTIFIED BY 'Zan_666888';

          2. Query OK, 0 rows affected, 1 warning (0.00 sec)

          3. #查詢Master1的狀態(tài)

          4. mysql> show master status;

          5. +------------------+----------+--------------+-------------------------------------------------+-------------------+

          6. | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |

          7. +------------------+----------+--------------+-------------------------------------------------+-------------------+

          8. | mysql-bin.000002 | 435 | copydb2 | mysql,information_schema,performance_schema,sys | |

          9. +------------------+----------+--------------+-------------------------------------------------+-------------------+

          10. 1 row in set (0.00 sec)

          master2:

           
          1. mysql> GRANT REPLICATION SLAVE ON *.* TO 'slave'@'%' IDENTIFIED BY 'Zan_666888';

          2. Query OK, 0 rows affected, 1 warning (0.01 sec)

          3. #查詢Master2的狀態(tài)

          4. mysql> show master status;

          5. +------------------+----------+--------------+-------------------------------------------------+-------------------+

          6. | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |

          7. +------------------+----------+--------------+-------------------------------------------------+-------------------+

          8. | mysql-bin.000001 | 435 | copydb2 | mysql,information_schema,performance_schema,sys | |

          9. +------------------+----------+--------------+-------------------------------------------------+-------------------+

          10. 1 row in set (0.00 sec)

          #分別記錄下File和Position的值

          #執(zhí)行完此步驟后不要再操作主服務(wù)器MYSQL,防止主服務(wù)器狀態(tài)值變化


          8. 在從機(jī)上配置需要復(fù)制的主機(jī)

          Slava1 復(fù)制 Master1,Slava2 復(fù)制 Master2


           
          1. #復(fù)制主機(jī)的命令

          2. CHANGE MASTER TO MASTER_HOST='主機(jī)的IP地址',

          3. MASTER_USER='slave',

          4. MASTER_PASSWORD='123123',

          5. MASTER_LOG_FILE='mysql-bin.具體數(shù)字',MASTER_LOG_POS=具體值;

          slave1:

           
          1. CHANGE MASTER TO MASTER_HOST='172.16.94.131',

          2. MASTER_USER='slave',

          3. MASTER_PASSWORD='Zan_666888',

          4. MASTER_LOG_FILE='mysql-bin.000002',MASTER_LOG_POS=435;

          slave2:

           
          1. CHANGE MASTER TO MASTER_HOST='172.16.94.133',

          2. MASTER_USER='slave',

          3. MASTER_PASSWORD='Zan_666888',

          4. MASTER_LOG_FILE='mysql-bin.000001',MASTER_LOG_POS=435;

          #啟動兩臺從服務(wù)器復(fù)制功能

          slave1:

           
          1. mysql> start slave;

          2. #查看從服務(wù)器狀態(tài)

          3. show slave status\G;


          slave2:

          mysql> start slave; #查看從服務(wù)器狀態(tài) show slave status\G;


          #下面兩個(gè)參數(shù)都是Yes,則說明主從配置成功!

          # Slave_IO_Running: Yes

          # Slave_SQL_Running: Yes


          9. 兩個(gè)主機(jī)互相復(fù)制

          Master2 復(fù)制 Master1,Master1 復(fù)制 Master2


          master2:

           
          1. mysql> CHANGE MASTER TO MASTER_HOST='172.16.94.131',

          2. -> MASTER_USER='slave',

          3. -> MASTER_PASSWORD='Zan_666888',

          4. -> MASTER_LOG_FILE='mysql-bin.000002',MASTER_LOG_POS=435;

          5. Query OK, 0 rows affected, 2 warnings (0.02 sec)


          6. mysql> start slave;

          7. Query OK, 0 rows affected (0.00 sec)


          8. mysql> show slave status\G;



          master1:


           
          1. mysql> CHANGE MASTER TO MASTER_HOST='172.16.94.133',

          2. -> MASTER_USER='slave',

          3. -> MASTER_PASSWORD='Zan_666888',

          4. -> MASTER_LOG_FILE='mysql-bin.000001',MASTER_LOG_POS=435;

          5. Query OK, 0 rows affected, 2 warnings (0.02 sec)


          6. mysql> start slave;

          7. Query OK, 0 rows affected (0.00 sec)


          8. mysql> show slave status\G;



          #下面兩個(gè)參數(shù)都是Yes,則說明主從配置成功!

          # Slave_IO_Running: Yes

          # Slave_SQL_Running: Yes


          10. Master1 主機(jī)新建庫、新建表、insert 記錄,Master2 和從機(jī)復(fù)制

           
          1. mysql> CREATE DATABASE copydb2;

          2. Query OK, 1 row affected (0.00 sec)


          3. mysql> show databases;

          4. +--------------------+

          5. | Database |

          6. +--------------------+

          7. | information_schema |

          8. | copydb |

          9. | copydb2 |

          10. | mysql |

          11. | nacos_config |

          12. | performance_schema |

          13. | seata |

          14. | seata_account |

          15. | seata_order |

          16. | seata_storage |

          17. | sys |

          18. +--------------------+

          19. 11 rows in set (0.00 sec)


          20. mysql> use copydb2;

          21. Database changed

          22. mysql> CREATE TABLE mytbl(id INT,NAME VARCHAR(20));

          23. Query OK, 0 rows affected (0.01 sec)


          24. mysql> INSERT INTO mytbl VALUES(1,'zhang3');

          25. Query OK, 1 row affected (0.01 sec)


          26. mysql> select * from mytbl;

          27. +------+--------+

          28. | id | NAME |

          29. +------+--------+

          30. | 1 | zhang3 |

          31. +------+--------+

          32. 1 row in set (0.00 sec)



          四個(gè)節(jié)點(diǎn)數(shù)據(jù)均實(shí)現(xiàn)了同步


          11.如何停止從服務(wù)復(fù)制功能

          stop slave;

          如何重新配置主從

          stop slave; reset master;


          12.修改 Mycat 的配置文件
          /usr/local/mycat/conf/schema.xml

          修改<dataHost>的balance屬性,通過此屬性配置讀寫分離的類型


          負(fù)載均衡類型,目前的取值有4 種:

          (1)balance="0", 不開啟讀寫分離機(jī)制,所有讀操作都發(fā)送到當(dāng)前可用的 writeHost 上。

          (2)balance="1",全部的 readHost 與 stand by writeHost 參與 select 語句的負(fù)載均衡,簡單地說,當(dāng)雙主雙從

          模式(M1->S1,M2->S2,并且 M1 與 M2 互為主備),正常情況下,M2,S1,S2 都參與 select 語句的負(fù)載均衡。

          (3)balance="2",所有讀操作都隨機(jī)的在 writeHost、readhost 上分發(fā)。

          (4)balance="3",所有讀請求隨機(jī)的分發(fā)到 readhost 執(zhí)行,writerHost 不負(fù)擔(dān)讀壓力


          為了雙主雙從讀寫分離balance設(shè)置為1


           
          1. <?xml version="1.0"?>

          2. <!DOCTYPE mycat:schema SYSTEM "schema.dtd">

          3. <mycat:schema xmlns:mycat="http://io.mycat/">


          4. <schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1">


          5. </schema>


          6. <dataNode name="dn1" dataHost="host1" database="copydb2" />


          7. <dataHost name="host1" maxCon="1000" minCon="10" balance="1"

          8. writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">

          9. <heartbeat>select user()</heartbeat>


          10. <writeHost host="hostM1" url="172.16.94.131:3306" user="root"

          11. password="Zan_123456">


          12. <readHost host="hostS1" url="172.16.94.132:3306" user="root" password="Zan_123456" />

          13. </writeHost>


          14. <writeHost host="hostM2" url="172.16.94.133:3306" user="root"

          15. password="Zan_123456">


          16. <readHost host="hostS2" url="172.16.94.134:3306" user="root" password="Zan_123456" />

          17. </writeHost>


          18. </dataHost>


          19. </mycat:schema>

          #balance="1": 全部的readHost與stand by writeHost參與select語句的負(fù)載均衡。

          #writeType="0": 所有寫操作發(fā)送到配置的第一個(gè)writeHost,第一個(gè)掛了切到還生存的第二個(gè)

          #writeType="1",所有寫操作都隨機(jī)的發(fā)送到配置的 writeHost,1.5 以后廢棄不推薦

          #writeHost,重新啟動后以切換后的為準(zhǔn),切換記錄在配置文件中:dnindex.properties 。

          #switchType="1": 1 默認(rèn)值,自動切換。

          # -1 表示不自動切換

          # 2 基于 MySQL 主從同步的狀態(tài)決定是否切換。


          13.啟動 Mycat,驗(yàn)證讀寫分離

           
          1. [root@shuidi01 bin]# ./mycat stop

          2. Stopping Mycat-server...

          3. Mycat-server was not running.

          4. [root@shuidi01 bin]# ./mycat start

          5. Starting Mycat-server...



           
          1. #登錄mycat

          2. mysql -umycat -pzan123456 -P 8066 -h 127.0.0.1

          3. #插入數(shù)據(jù)

          4. mysql> show databases;

          5. +----------+

          6. | DATABASE |

          7. +----------+

          8. | TESTDB |

          9. +----------+

          10. 1 row in set (0.00 sec)


          11. mysql> use TESTDB;

          12. Reading table information for completion of table and column names

          13. You can turn off this feature to get a quicker startup with -A


          14. Database changed

          15. mysql> show tables;

          16. +-------------------+

          17. | Tables_in_copydb2 |

          18. +-------------------+

          19. | mytbl |

          20. +-------------------+

          21. 1 row in set (0.00 sec)

          22. mysql> INSERT INTO mytbl VALUES(2,@@hostname);

          23. Query OK, 1 row affected, 1 warning (0.00 sec)


          24. mysql> select * from mytbl;

          25. +------+----------+

          26. | id | NAME |

          27. +------+----------+

          28. | 1 | zhang3 |

          29. | 2 | shuidi03 |

          30. +------+----------+

          31. 2 rows in set (0.00 sec)


          32. mysql> select * from mytbl;

          33. +------+----------+

          34. | id | NAME |

          35. +------+----------+

          36. | 1 | zhang3 |

          37. | 2 | shuidi02 |

          38. +------+----------+

          39. 2 rows in set (0.00 sec)

          40. mysql> select * from mytbl;

          41. +------+----------+

          42. | id | NAME |

          43. +------+----------+

          44. | 1 | zhang3 |

          45. | 2 | shuidi04 |

          46. +------+----------+

          47. 2 rows in set (0.00 sec)


          #在Mycat里查詢mytbl表,可以看到查詢語句在Master2(shuidi03)、Slava1(shuidi02)、Slava2(shuidi04)主從三個(gè)主機(jī)間切換


          14.抗風(fēng)險(xiǎn)能力

          #停止數(shù)據(jù)庫Master1

           
          1. [root@shuidi01 logs]# systemctl stop mysqld

          2. [root@shuidi01 logs]# systemctl status mysqld

          3. ● mysqld.service - MySQL Server

          4. Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)

          5. Active: inactive (dead) since 一 2020-03-30 21:31:28 CST; 4s ago

          6. Docs: man:mysqld(8)

          7. http://dev.mysql.com/doc/refman/en/using-systemd.html

          8. Process: 9985 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)

          9. Process: 9946 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)

          10. Main PID: 9990 (code=exited, status=0/SUCCESS)


          11. 3月 30 20:38:22 shuidi01 systemd[1]: Starting MySQL Server...

          12. 3月 30 20:38:23 shuidi01 systemd[1]: Started MySQL Server.

          13. 3月 30 21:31:16 shuidi01 systemd[1]: Stopping MySQL Server...

          14. 3月 30 21:31:28 shuidi01 systemd[1]: Stopped MySQL Server.


          #在Mycat里插入數(shù)據(jù)依然成功,Master2自動切換為寫主機(jī)

           
          1. mysql> INSERT INTO mytbl VALUES(3,@@hostname);

          2. Query OK, 1 row affected, 1 warning (0.00 sec)

          3. mysql> select * from mytbl;

          4. +------+----------+

          5. | id | NAME |

          6. +------+----------+

          7. | 1 | zhang3 |

          8. | 2 | shuidi04 |

          9. | 3 | shuidi04 |

          10. +------+----------+

          11. 3 rows in set (0.00 sec)


          #啟動數(shù)據(jù)庫Master1

           
          1. [root@shuidi01 logs]# systemctl start mysqld

          2. [root@shuidi01 logs]# systemctl status mysqld

          3. ● mysqld.service - MySQL Server

          4. Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)

          5. Active: active (running) since 一 2020-03-30 21:33:39 CST; 2s ago

          6. Docs: man:mysqld(8)

          7. http://dev.mysql.com/doc/refman/en/using-systemd.html

          8. Process: 3527 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)

          9. Process: 3473 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)

          10. Main PID: 3531 (mysqld)

          11. CGroup: /system.slice/mysqld.service

          12. └─3531 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid


          13. 3月 30 21:33:38 shuidi01 systemd[1]: Starting MySQL Server...

          14. 3月 30 21:33:39 shuidi01 systemd[1]: Started MySQL Server.


           
          1. mysql> select * from mytbl;

          2. +------+----------+

          3. | id | NAME |

          4. +------+----------+

          5. | 1 | zhang3 |

          6. | 2 | shuidi01 |

          7. | 3 | shuidi01 |

          8. +------+----------+

          9. 3 rows in set (0.00 sec)

          10. mysql> select * from mytbl;

          11. +------+----------+

          12. | id | NAME |

          13. +------+----------+

          14. | 1 | zhang3 |

          15. | 2 | shuidi02 |

          16. | 3 | shuidi02 |

          17. +------+----------+

          18. 3 rows in set (0.00 sec)

          19. mysql> select * from mytbl;

          20. +------+----------+

          21. | id | NAME |

          22. +------+----------+

          23. | 1 | zhang3 |

          24. | 2 | shuidi04 |

          25. | 3 | shuidi04 |

          26. +------+----------+

          27. 3 rows in set (0.00 sec)


          #在Mycat里查詢mytbl表,可以看到查詢語句在Master1(shuidi01)、Slava1(shuidi02)、Slava2(shuidi04)

          主從三個(gè)主機(jī)間切換

          Master1、Master2 互做備機(jī),負(fù)責(zé)寫的主機(jī)宕機(jī),備機(jī)切換負(fù)責(zé)寫操作,保證數(shù)據(jù)庫讀寫分離高

          可用性。


          瀏覽 31
          點(diǎn)贊
          評論
          收藏
          分享

          手機(jī)掃一掃分享

          分享
          舉報(bào)

          評論
          圖片
          表情
          推薦
          點(diǎn)贊
          評論
          收藏
          分享

          手機(jī)掃一掃分享

          分享
          舉報(bào)
          <kbd id="afajh"><form id="afajh"></form></kbd>
          <strong id="afajh"><dl id="afajh"></dl></strong>
            <del id="afajh"><form id="afajh"></form></del>
                1. <th id="afajh"><progress id="afajh"></progress></th>
                  <b id="afajh"><abbr id="afajh"></abbr></b>
                  <th id="afajh"><progress id="afajh"></progress></th>
                  黄色视频高清无码 | 国产女人操逼视频 | 天堂综合在线 | 狼友在线观看 | 娇小小小泬BBB亚洲 |