tiny core linux ngnix,Ubuntu下Nginx做负载实现高性能WEB服务器5---MySQL主主同步

root@Ubuntu3:~# MySQL -u root -p

Enter password:

mysql>use movie

Reading table information for completion of table and column names

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

Database changed

mysql>show tables;

+----------------------+

| Tables_in_movie      |

+----------------------+

| wind_account_log     |

| wind_ad              |

| wind_ad_position     |

| wind_admin           |

| wind_admin_action    |

| wind_admin_log       |

| wind_admin_message   |

| wind_adminutil       |

| wind_adsense         |

| wind_article         |

| wind_article_cat     |

| wind_card            |

| wind_card_log        |

| wind_category        |

| wind_co_html         |

| wind_co_listen       |

| wind_co_media        |

| wind_co_note         |

| wind_comment         |

| wind_cpsession       |

| wind_datastore       |

| wind_feedback        |

| wind_friend_link     |

| wind_humanverify     |

| wind_keywords        |

| wind_mailqueue       |

| wind_nav             |

| wind_netbar          |

| wind_order_info      |

| wind_pay_log         |

| wind_payment         |

| wind_play_log        |

| wind_player          |

| wind_searchcore_text |

| wind_searchengine    |

| wind_server          |

| wind_session         |

| wind_setting         |

| wind_show            |

| wind_show_article    |

| wind_show_cat        |

| wind_stats           |

| wind_subject         |

| wind_tag             |

| wind_template        |

| wind_template_mail   |

| wind_user_account    |

| wind_user_rank       |

| wind_users           |

| wind_vote            |

| wind_vote_log        |

| wind_vote_option     |

+----------------------+

52 rows in set (0.01 sec)

mysql>desc wind_admin;

+-------------+---------------------+------+-----+---------+----------------+

| Field       | Type                | Null | Key | Default | Extra          |

+-------------+---------------------+------+-----+---------+----------------+

| user_id     | tinyint(3) unsigned | NO   | PRI | NULL    | auto_increment |

| user_name   | varchar(60)         | NO   |     | NULL    |                |

| email       | varchar(60)         | NO   |     | NULL    |                |

| password    | varchar(32)         | NO   |     | NULL    |                |

| join_time   | int(10) unsigned    | NO   |     | 0       |                |

| last_time   | int(10) unsigned    | NO   |     | 0       |                |

| last_ip     | varchar(15)         | NO   |     | NULL    |                |

| action_list | text                | NO   |     | NULL    |                |

| nav_list    | text                | NO   |     | NULL    |                |

| lang_type   | varchar(50)         | NO   |     | NULL    |                |

| todolist    | longtext            | NO   |     | NULL    |                |

+-------------+---------------------+------+-----+---------+----------------+

11 rows in set (0.00 sec)

mysql>insert into wind_admin values(NULL,'coldwind','123@456.com','coldwind','0','0','0.0.0.0','0','0','0','0');