mysql主从(master-slave)复制安装配置

一. 环境准备

准备两台服务器,IP分别为
192.168.1.119 (主数据库服务器)
192.168.1.120 (从数据库服务器)

分别装好mysql数据库服务器

二. 安装配置

1. 在主数据库服务器上设置一个复制使用的账户,并授予replication slave权限,这里创建一个复制用户rep1,可以从IP为192.168.1.120的主机进行连接.

mysql > grant replication slave on *.* to 'rep'@'192.168.1.120' identified by '123';

2. 修改主数据库服务器的配置文件my.cnf,开启binlog,并设置server-id的值。

[mysqld]
server-id=1
log-bin=/var/lib/mysql/mysql-bin.log

数据库重启后生效

3. 在主服务器上,设置读锁有效,这个操作是为了确保没有数据库操作,以便获得一个一致性的快照。

mysql > flush tables with read lock;

4. 然后得到主服务器上当前的二进制日志名的偏移量值。这个操作的目的是为了在从数据库启动以后,从这个点开始进行数据的恢复。

mysql> show master status;
+------------------+----------+--------------+------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000001 |     2122 |              |                  | 
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)

5. 建立测试数据库test1

mysql> create database test1;
Query OK, 1 row affected (0.01 sec)

6. 备份一份数据库文件,将其恢复到从服务器上,可以通过mysqldump或者直接拷贝文件的方式。这里采用直接copy文件的方式。

[~@master]# cd /var/lib/mysql
[~@master]# tar cvf test1.tar test1
test1/
test1/db.opt
[~@master]# scp test1.tar root@192.168.1.120:/var/lib/mysql/
...
[~@slave]# tar xvf test1.tar
 
 
7. 备份完毕后,主数据库恢复被写操作
mysql> unlock tables;
Query OK, 0 rows affected (0.00 sec)

8. 修改从数据库的配置文件my.cnf,添加server-id参数,注意这里的server-id参数必须唯一,不能和主数据库的配置相同.复制使用的用户、主数据库服务器的IP、端口以及连接丢失时,重试的时间

[mysqld]
server-id=2
master-host=192.168.1.119
master-user=rep1
master-password=123456
master-connect-retry=60

9. 在从服务器上,使用–skip-slave-start 选项启动从数据库,这样就不会立即启动从数据库上的复制进程,方便对数据库的服务进程进行进一步的配置

[~@slave]# /usr/bin/mysqld_safe --skip-slave-start &
[~@slave]# Starting mysqld daemon with databases from /var/lib/mysql

10. 指定开始执行复制的日志文件和位置

mysql> change master to
    -> master_log_file='mysql-bin.000001',
    -> master_log_pos=2207;
Query OK, 0 rows affected (0.01 sec)

这里的log_file和log_pos是通过主服务器中执行

mysql > show master stauts;

得到

11. 在从服务器上,启动slave进程

mysql> start slave;
Query OK, 0 rows affected (0.00 sec)

12. 这时在slave上执行show processlist 命令将显示类似如下进程

mysql> show processlist \G
*************************** 1. row ***************************
     Id: 2
   User: root
   Host: localhost
     db: NULL
Command: Query
   Time: 0
  State: NULL
   Info: show processlist
*************************** 2. row ***************************
     Id: 3
   User: system user
   Host: 
     db: NULL
Command: Connect
   Time: 29
  State: Waiting for master to send event
   Info: NULL
*************************** 3. row ***************************
     Id: 4
   User: system user
   Host: 
     db: NULL
Command: Connect
   Time: 29
  State: Has read all relay log; waiting for the slave I/O thread to update it
   Info: NULL
3 rows in set (0.01 sec)

这表明slave已经连接上master,并开始接受并执行日志.

13.测试复制服务器的正确性,在主数据库上执行一个更新操作,观察是否在从数据库上同步.

mysql> use test1;
Database changed
mysql> create table rep(id int);
Query OK, 0 rows affected (0.00 sec)
 
mysql> insert into rep values(1),(2),(3),(4),(5);
Query OK, 5 rows affected (0.01 sec)
Records: 5  Duplicates: 0  Warnings: 0

15. 在从数据库上检查新表是否被创建,数据是否被同步.

mysql> use test1;
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_test1 |
+-----------------+
| rep             | 
+-----------------+
1 row in set (0.00 sec)
 
mysql> select * from rep;
+------+
| id   |
+------+
|    1 | 
|    2 | 
|    3 | 
|    4 | 
|    5 | 
+------+
5 rows in set (0.00 sec)

可以看到数据可以正确同步到从数据库上,复制服务配置成功完成.

三 复制启动选项

这些选项可以在启动时加入,也可以直接写在my.cnf里

1. log-slave-updates
这个参数用来配置从服务器上的更新操作是否写进进制日志,默认不打开,但是,如果这个从服务器同时也要作为其它服务器的主服务器时,就需要启动.
这个参数需要和log-bin一起使用.

2. master-connect-retry
这个参数用来设置在和主服务器连接丢失的时候,重度的时间间隔.

3. read-only
这个参数用来设置从服务器只能接受超级用户的更新操作,从而限制应用程序错误的对从服务器的更新操作.

4. 指定复制的数据库或者表
可以使用replicate-do-db、replicate-do-table、replicate-ignore-db、replicate-ignore-table或replicate-wild-do-table来指定从主数据库复制到从从数据库的数据库或者表。

四 日常管理维护

1. 查看从服务器状态

mysql> show slave status \G;
*************************** 1. row ***************************
             Slave_IO_State: Waiting for master to send event
                Master_Host: 192.168.1.119
                Master_User: rep1
                Master_Port: 3306
              Connect_Retry: 60
            Master_Log_File: mysql-bin.000001
        Read_Master_Log_Pos: 2400
             Relay_Log_File: mysqld-relay-bin.000002
              Relay_Log_Pos: 428
      Relay_Master_Log_File: mysql-bin.000001
           Slave_IO_Running: Yes
          Slave_SQL_Running: Yes
            Replicate_Do_DB: 
        Replicate_Ignore_DB: 
         Replicate_Do_Table: 
     Replicate_Ignore_Table: 
    Replicate_Wild_Do_Table: 
Replicate_Wild_Ignore_Table: 
                 Last_Errno: 0
                 Last_Error: 
               Skip_Counter: 0
        Exec_Master_Log_Pos: 2400
            Relay_Log_Space: 428
            Until_Condition: None
             Until_Log_File: 
              Until_Log_Pos: 0
         Master_SSL_Allowed: No
         Master_SSL_CA_File: 
         Master_SSL_CA_Path: 
            Master_SSL_Cert: 
          Master_SSL_Cipher: 
             Master_SSL_Key: 
      Seconds_Behind_Master: 0
1 row in set (0.00 sec)
 
ERROR: 
No query specified

主要关心”Slave_IO_Running”和“Slave_SQL_Running”这两个进程的状态是否为”yes”。只要其中一个进程状态为no,则表示复制进程停止,错误原因可以从“Last_Errno”字段中的值看到。

2. 主从服务器手工同步
从服务器由于各种原因导致更新速度较慢,从而是主从服务器之间的数据差距越来越大,最终对某些应用产生影响,这种情况下,就需要定期地进行主从服务器的数据同步,使得主从服务器差距能够减到最小。常用方法是:在负载较低的时候暂时阻塞主数据库的更新,强制主从数据库更新同步。

阻塞更新

mysql> flush tables with read lock;
Query OK, 0 rows affected (0.00 sec)
 
mysql> show master status;
+------------------+----------+--------------+------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000001 |     2400 |              |                  | 
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)

在从服务器上,执行下面语句,其中master_pos_wait()函数的参数是前面步骤中得到的复制坐标值。

mysql> select master_pos_wait('mysql-bin.000001','2400');
+--------------------------------------------+
| master_pos_wait('mysql-bin.000001','2400') |
+--------------------------------------------+
|                                          0 | 
+--------------------------------------------+
1 row in set (0.00 sec)

这个语句会阻塞直到从服务器达到指定的日志文件和偏移量后,返回0,如果返回-1。

在主服务器上,执行下面语句允许主服务器重新开始处理更新

mysql>  unlock tables;
Query OK, 0 rows affected (0.00 sec)

3. log event entry exceeded max_allowed_packet的处理

mysql> show variables like 'max_allowed_packet';
+--------------------+---------+
| Variable_name      | Value   |
+--------------------+---------+
| max_allowed_packet | 1048576 | 
+--------------------+---------+
1 row in set (0.01 sec)
mysql> set @@global.max_allowed_packet=16777216

同时在my.cnf里设置max_allowed_packet=16M,保证下次数据库重新启动后参数继续有效。

好了,暂时总结这么多.

机器人 2010年01月06日 17:24 于 北京 晴 -10℃.

此条目发表在 mysql 分类目录。将固定链接加入收藏夹。

mysql主从(master-slave)复制安装配置》有 25 条评论

  1. Pingback 引用通告: py. » mysql主从(master-slave)复制安装配置

  2. dubai pet 说:

    Fantastic article I`ll definitely be returning to follow your blog more frequently

  3. Migown Mandie 说:

    This is a great internet page, could you be interested in performing an interview about just how you designed it? If so e-mail me!

  4. 聂各庄 说:

    青龙,最近怎么样

  5. QW08ai 说:

    “Ye Fei Cheng Yufei conosce questa frase è sicuramente nella lotta contro di lei, sorrise e non si curava di lui il momento, ha sorriso e ha detto la frase” Non voglio sentirmi cantare? Vieni, mi fa soggiornare nei migliori Riverside KTV, oggi vi do un concerto speciale. “Ye Fei è l’ascolto di Hey s

  6. Ropd_Tgup 说:

    support public transportation

    I’ve been dependent on it for most of my adult years, but even when I had a car I recognized the value and convenience of letting someone else take the wheel. Here I could get on my soapbox about traffic, the environment, Americans and their cars, the public good..

  7. 何刁炉坎 说:

    杭州最好的夜场是杭州东方魅力www.dongfangmeili.cn
    杭州最好的ktv是哪儿?是杭州东方魅力www.dongfangmeili.cn

    杭州夜场招聘首选杭州东方魅力www.dongfangmeili.com.cn

    杭州最好的夜总会是杭州东方魅力www.dongfangmeili.com.cn

    杭州东方魅力官方网站欢迎你 联系电话:13666653761 官方微信:dongfangmeili
    杭州最好的ktv是www.dongfangmeili.cn
    杭州夜场招聘杭州夜场招聘www.dongfangmeili.cn

  8. 4213

    Parmi les types de vêtements pour femmes et des vêtements vendus sont des sommets qui vont de couleurs claires aux sommets sombres, lisses de fantastique, Long à petit, et désuet de sexy. 1 robes de mode, Corporation. Il donne également une variété de mise au point dos-nus, la publicité et l

  9. ugg soldes 说:

    3714

    Promesses de programme le plus FundANeed sont déductibles à 100% si la société est un 501 (chimique) 3 organisme de bienfaisance désigné en vertu casque bose pas cher de la Revenue Service Code général des impôts interne. pour en savoir plus a vos participants collectes de fonds consulter le

  10. 3392

    Vous pouvez même obtenir des lunettes en titane Burberry qui peut être bénéfique pour practioner lunettes prescrites médicaux et des lunettes de soleil polarisées. Si vous avez des inquiétudes concernant votre santé ou la salubrité de votre enfant, vous devriez toujours consulter un médecin

  11. 苏兄昀刑 说:

    杭州最好的夜场是杭州东方魅力www.dongfangmeili.cn

    杭州最好的ktv是哪儿?是杭州东方魅力www.dongfangmeili.cn

    杭州夜场招聘首选杭州东方魅力www.dongfangmeili.com.cn

    杭州最好的夜总会是杭州东方魅力www.dongfangmeili.com.cn

    杭州东方魅力官方网站欢迎你 联系电话:13666653761 官方微信:dongfangmeili

  12. odloty.pl 说:

    Thqnk youu foг sharing your thoughts. I really appreciate your efforts and I
    aam wwiting for your next pst thank you once аgain.

  13. whoah this blog is magnificent i love studying your posts.
    Stay up the good work! You recognize, a lot of people are hunting round for this information,
    you can aid them greatly.

  14. {
    {I have|I’ve} been {surfing|browsing} online more than {three|3|2|4} hours today,
    yet I never found any interesting article like yours.
    {It’s|It is} pretty worth enough for me. {In my opinion|Personally|In my view}, if all {webmasters|site owners|website owners|web owners} and bloggers made good content as you did,
    the {internet|net|web} will be {much more|a lot more} useful than ever before.|
    I {couldn’t|could not} {resist|refrain from} commenting.
    {Very well|Perfectly|Well|Exceptionally well} written!|
    {I will|I’ll} {right away|immediately} {take hold of|grab|clutch|grasp|seize|snatch}
    your {rss|rss feed} as I {can not|can’t} {in finding|find|to find} your {email|e-mail} subscription {link|hyperlink} or
    {newsletter|e-newsletter} service. Do {you have|you’ve} any?
    {Please|Kindly} {allow|permit|let} me {realize|recognize|understand|recognise|know} {so that|in order that} I {may just|may|could} subscribe.
    Thanks.|
    {It is|It’s} {appropriate|perfect|the best} time to make some plans
    for the future and {it is|it’s} time to be happy. {I have|I’ve} read this post
    and if I could I {want to|wish to|desire to} suggest you {few|some} interesting
    things or {advice|suggestions|tips}. {Perhaps|Maybe} you {could|can} write
    next articles referring to this article. I {want to|wish to|desire to} read {more|even more} things about it!|
    {It is|It’s} {appropriate|perfect|the best}
    time to make {a few|some} plans for {the future|the longer term|the long run} and {it
    is|it’s} time to be happy. {I have|I’ve} {read|learn}
    this {post|submit|publish|put up} and if I {may just|may|could} I {want to|wish to|desire to} {suggest|recommend|counsel} you {few|some} {interesting|fascinating|attention-grabbing} {things|issues} or {advice|suggestions|tips}.

    {Perhaps|Maybe} you {could|can} write {next|subsequent} articles {relating to|referring to|regarding} this article.
    I {want to|wish to|desire to} {read|learn} {more|even more}
    {things|issues} {approximately|about} it!|
    {I have|I’ve} been {surfing|browsing} {online|on-line} {more than|greater than} {three|3} hours {these days|nowadays|today|lately|as of late}, {yet|but} I {never|by
    no means} {found|discovered} any {interesting|fascinating|attention-grabbing} article like
    yours. {It’s|It is} {lovely|pretty|beautiful} {worth|value|price} {enough|sufficient}
    for me. {In my opinion|Personally|In my view}, if all {webmasters|site
    owners|website owners|web owners} and bloggers made {just right|good|excellent}
    {content|content material} as {you did|you probably did}, the {internet|net|web}
    {will be|shall be|might be|will probably be|can be|will likely be} {much more|a lot more} {useful|helpful} than ever before.|
    Ahaa, its {nice|pleasant|good|fastidious} {discussion|conversation|dialogue} {regarding|concerning|about|on the topic of} this {article|post|piece of writing|paragraph} {here|at this place} at this
    {blog|weblog|webpage|website|web site}, I have read all that,
    so {now|at this time} me also commenting {here|at this place}.|
    I am sure this {article|post|piece of writing|paragraph} has
    touched all the internet {users|people|viewers|visitors},
    its really really {nice|pleasant|good|fastidious} {article|post|piece of writing|paragraph} on building up new {blog|weblog|webpage|website|web site}.|
    Wow, this {article|post|piece of writing|paragraph}
    is {nice|pleasant|good|fastidious}, my {sister|younger sister} is
    analyzing {such|these|these kinds of} things, {so|thus|therefore} I am going to {tell|inform|let
    know|convey} her.|
    {Saved as a favorite|bookmarked!!}, {I really like|I like|I
    love} {your blog|your site|your web site|your website}!|
    Way cool! Some {very|extremely} valid points! I appreciate you {writing this|penning this} {article|post|write-up} {and
    the|and also the|plus the} rest of the {site is|website is} {also very|extremely|very|also really|really} good.|
    Hi, {I do believe|I do think} {this is an excellent|this is a great} {blog|website|web site|site}.
    I stumbledupon it ;) {I will|I am going to|I’m going to|I
    may} {come back|return|revisit} {once again|yet again} {since I|since i have}
    {bookmarked|book marked|book-marked|saved as a favorite}
    it. Money and freedom {is the best|is the greatest} way to change, may you be rich and continue to {help|guide} {other people|others}.|
    Woah! I’m really {loving|enjoying|digging} the template/theme of this {site|website|blog}.
    It’s simple, yet effective. A lot of times it’s {very hard|very difficult|challenging|tough|difficult|hard}
    to get that “perfect balance” between {superb usability|user friendliness|usability} and
    {visual appearance|visual appeal|appearance}.
    I must say {that you’ve|you have|you’ve} done a {awesome|amazing|very good|superb|fantastic|excellent|great} job with this.

    {In addition|Additionally|Also}, the blog loads {very|extremely|super} {fast|quick} for me
    on {Safari|Internet explorer|Chrome|Opera|Firefox}.
    {Superb|Exceptional|Outstanding|Excellent} Blog!|
    These are {really|actually|in fact|truly|genuinely} {great|enormous|impressive|wonderful|fantastic}
    ideas in {regarding|concerning|about|on the topic of}
    blogging. You have touched some {nice|pleasant|good|fastidious}
    {points|factors|things} here. Any way keep up wrinting.|
    {I love|I really like|I enjoy|I like|Everyone loves} what you guys {are|are usually|tend to be} up too.

    {This sort of|This type of|Such|This kind of} clever work and {exposure|coverage|reporting}!
    Keep up the {superb|terrific|very good|great|good|awesome|fantastic|excellent|amazing|wonderful} works
    guys I’ve {incorporated||added|included} you guys to {|my|our||my personal|my
    own} blogroll.|
    {Howdy|Hi there|Hey there|Hi|Hello|Hey}! Someone in my {Myspace|Facebook}
    group shared this {site|website} with us so I came to {give it a look|look it over|take a look|check it out}.

    I’m definitely {enjoying|loving} the information.
    I’m {book-marking|bookmarking} and will be tweeting this to my followers!
    {Terrific|Wonderful|Great|Fantastic|Outstanding|Exceptional|Superb|Excellent} blog and {wonderful|terrific|brilliant|amazing|great|excellent|fantastic|outstanding|superb} {style
    and design|design and style|design}.|
    {I love|I really like|I enjoy|I like|Everyone loves} what you guys {are|are usually|tend to
    be} up too. {This sort of|This type of|Such|This kind of} clever work and {exposure|coverage|reporting}!
    Keep up the {superb|terrific|very good|great|good|awesome|fantastic|excellent|amazing|wonderful}
    works guys I’ve {incorporated|added|included} you guys to {|my|our|my personal|my own} blogroll.|
    {Howdy|Hi there|Hey there|Hi|Hello|Hey} would you mind {stating|sharing} which blog
    platform you’re {working with|using}? I’m {looking|planning|going} to start my own blog {in
    the near future|soon} but I’m having a {tough|difficult|hard} time {making a decision|selecting|choosing|deciding} between BlogEngine/Wordpress/B2evolution and Drupal.
    The reason I ask is because your {design and style|design|layout} seems different then most blogs and I’m looking for
    something {completely unique|unique}.
    P.S {My apologies|Apologies|Sorry} for {getting|being} off-topic but I had to ask!|
    {Howdy|Hi there|Hi|Hey there|Hello|Hey} would you mind letting
    me know which {webhost|hosting company|web host} you’re {utilizing|working with|using}?
    I’ve loaded your blog in 3 {completely different|different} {internet browsers|web browsers|browsers} and I must
    say this blog loads a lot {quicker|faster} then most.

    Can you {suggest|recommend} a good {internet hosting|web
    hosting|hosting} provider at a {honest|reasonable|fair} price?

    {Thanks a lot|Kudos|Cheers|Thank you|Many thanks|Thanks}, I appreciate
    it!|
    {I love|I really like|I like|Everyone loves} it {when people|when individuals|when folks|whenever people} {come together|get together}
    and share {opinions|thoughts|views|ideas}. Great {blog|website|site},
    {keep it up|continue the good work|stick with it}!|
    Thank you for the {auspicious|good} writeup. It in fact was a amusement account it.
    Look advanced to {far|more} added agreeable from you!
    {By the way|However}, how {can|could} we communicate?|
    {Howdy|Hi there|Hey there|Hello|Hey} just wanted to give you a quick heads up.
    The {text|words} in your {content|post|article} seem to be running off the screen in {Ie|Internet explorer|Chrome|Firefox|Safari|Opera}.
    I’m not sure if this is a {format|formatting} issue
    or something to do with {web browser|internet browser|browser} compatibility but I {thought|figured} I’d
    post to let you know. The {style and design|design and style|layout|design} look
    great though! Hope you get the {problem|issue} {solved|resolved|fixed} soon.
    {Kudos|Cheers|Many thanks|Thanks}|
    This is a topic {that is|that’s|which is} {close to|near to} my heart…
    {Cheers|Many thanks|Best wishes|Take care|Thank you}! {Where|Exactly
    where} are your contact details though?|
    It’s very {easy|simple|trouble-free|straightforward|effortless} to find out any {topic|matter} on {net|web} as
    compared to {books|textbooks}, as I found this {article|post|piece of writing|paragraph} at this {website|web site|site|web page}.|
    Does your {site|website|blog} have a contact page?
    I’m having {a tough time|problems|trouble} locating it but, I’d like
    to {send|shoot} you an {e-mail|email}. I’ve got some {creative ideas|recommendations|suggestions|ideas} for your blog you might
    be interested in hearing. Either way, great {site|website|blog} and I look forward to
    seeing it {develop|improve|expand|grow} over time.|
    {Hola|Hey there|Hi|Hello|Greetings}! I’ve been {following|reading} your {site|web site|website|weblog|blog} for {a long time|a while|some time} now and finally
    got the {bravery|courage} to go ahead and give you a shout out from
    {New Caney|Kingwood|Huffman|Porter|Houston|Dallas|Austin|Lubbock|Humble|Atascocita} {Tx|Texas}!
    Just wanted to {tell you|mention|say} keep up the {fantastic|excellent|great|good} {job|work}!|
    Greetings from {Idaho|Carolina|Ohio|Colorado|Florida|Los
    angeles|California}! I’m {bored to tears|bored to death|bored} at work so I decided to {check out|browse}
    your {site|website|blog} on my iphone during lunch break.
    I {enjoy|really like|love} the {knowledge|info|information} you {present|provide} here
    and can’t wait to take a look when I get home. I’m {shocked|amazed|surprised}
    at how {quick|fast} your blog loaded on my {mobile|cell phone|phone} ..
    I’m not even using WIFI, just 3G .. {Anyhow|Anyways}, {awesome|amazing|very
    good|superb|good|wonderful|fantastic|excellent|great} {site|blog}!|
    Its {like you|such as you} {read|learn} my {mind|thoughts}!
    You {seem|appear} {to understand|to know|to grasp}
    {so much|a lot} {approximately|about} this, {like you|such as you} wrote the {book|e-book|guide|ebook|e book} in it or something.
    {I think|I feel|I believe} {that you|that you simply|that you just} {could|can} do
    with {some|a few} {%|p.c.|percent} to {force|pressure|drive|power} the message {house|home} {a bit|a little
    bit}, {however|but} {other than|instead of} that, {this is|that is} {great|wonderful|fantastic|magnificent|excellent} blog.
    {A great|An excellent|A fantastic} read. {I’ll|I
    will} {definitely|certainly} be back.|
    I visited {multiple|many|several|various} {websites|sites|web sites|web pages|blogs} {but|except|however} the audio {quality|feature} for audio songs {current|present|existing} at this {website|web site|site|web page} is {really|actually|in fact|truly|genuinely} {marvelous|wonderful|excellent|fabulous|superb}.|
    {Howdy|Hi there|Hi|Hello}, i read your blog {occasionally|from time to time} and i own a similar one and i was just
    {wondering|curious} if you get a lot of spam {comments|responses|feedback|remarks}?
    If so how do you {prevent|reduce|stop|protect against} it, any plugin or anything you can {advise|suggest|recommend}?

    I get so much lately it’s driving me {mad|insane|crazy}
    so any {assistance|help|support} is very much appreciated.|
    Greetings! {Very helpful|Very useful} advice {within this|in this particular} {article|post}!
    {It is the|It’s the} little changes {that make|which will make|that
    produce|that will make} {the biggest|the largest|the greatest|the most important|the most significant}
    changes. {Thanks a lot|Thanks|Many thanks} for sharing!|
    {I really|I truly|I seriously|I absolutely} love {your blog|your site|your website}..
    {Very nice|Excellent|Pleasant|Great} colors & theme. Did you {create|develop|make|build} {this website|this site|this web site|this amazing site} yourself?
    Please reply back as I’m {looking to|trying to|planning to|wanting
    to|hoping to|attempting to} create {my own|my very own|my own personal} {blog|website|site} and {would like to|want
    to|would love to} {know|learn|find out} where you got this from or {what the|exactly what the|just what the} theme {is called|is named}.
    {Thanks|Many thanks|Thank you|Cheers|Appreciate it|Kudos}!|
    {Hi there|Hello there|Howdy}! This {post|article|blog post}
    {couldn’t|could not} be written {any better|much better}!

    {Reading through|Looking at|Going through|Looking through}
    this {post|article} reminds me of my previous roommate! He {always|constantly|continually}
    kept {talking about|preaching about} this.
    {I will|I’ll|I am going to|I most certainly will} {forward|send} {this article|this information|this post} to him.
    {Pretty sure|Fairly certain} {he will|he’ll|he’s going to}
    {have a good|have a very good|have a great} read.
    {Thank you for|Thanks for|Many thanks for|I appreciate you for} sharing!|
    {Wow|Whoa|Incredible|Amazing}! This blog looks {exactly|just} like my old one!
    It’s on a {completely|entirely|totally} different
    {topic|subject} but it has pretty much the same {layout|page layout} and design.
    {Excellent|Wonderful|Great|Outstanding|Superb} choice of colors!|
    {There is|There’s} {definately|certainly} {a lot to|a great deal to} {know about|learn about|find
    out about} this {subject|topic|issue}. {I like|I love|I really like} {all
    the|all of the} points {you made|you’ve made|you have made}.|
    {You made|You’ve made|You have made} some {decent|good|really good} points there.
    I {looked|checked} {on the internet|on the web|on
    the net} {for more info|for more information|to find
    out more|to learn more|for additional information} about the issue
    and found {most individuals|most people} will go along with your views
    on {this website|this site|this web site}.|
    {Hi|Hello|Hi there|What’s up}, I {log on to|check|read} your {new stuff|blogs|blog} {regularly|like every week|daily|on a regular basis}.
    Your {story-telling|writing|humoristic} style is {awesome|witty},
    keep {doing what you’re doing|up the good work|it up}!|
    I {simply|just} {could not|couldn’t} {leave|depart|go away} your {site|web site|website}
    {prior to|before} suggesting that I {really|extremely|actually} {enjoyed|loved} {the standard|the usual}
    {information|info} {a person|an individual}
    {supply|provide} {for your|on your|in your|to your} {visitors|guests}?
    Is {going to|gonna} be {back|again} {frequently|regularly|incessantly|steadily|ceaselessly|often|continuously} {in
    order to|to} {check up on|check out|inspect|investigate cross-check} new posts|
    {I wanted|I needed|I want to|I need to} to thank you for this {great|excellent|fantastic|wonderful|good|very good}
    read!! I {definitely|certainly|absolutely} {enjoyed|loved} every {little bit of|bit of}
    it. {I have|I’ve got|I have got} you {bookmarked|book marked|book-marked|saved as
    a favorite} {to check out|to look at} new {stuff you|things you} post…|
    {Hi|Hello|Hi there|What’s up}, just wanted to {mention|say|tell you}, I {enjoyed|liked|loved}
    this {article|post|blog post}. It was {inspiring|funny|practical|helpful}.
    Keep on posting!|
    I {{leave|drop|{write|create}} a {comment|leave a response}|drop
    a {comment|leave a response}|{comment|leave a response}} {each time|when|whenever} I {appreciate|like|especially enjoy} a {post|article} on a {site|{blog|website}|site|website} or {I have|if I have} something to {add|contribute|valuable to
    contribute} {to the discussion|to the conversation}. {It
    is|Usually it is|Usually it’s|It’s} {a result of|triggered by|caused by} the {passion|fire|sincerness}
    {communicated|displayed} in the {post|article} I
    {read|looked at|browsed}. And {on|after} this {post|article} mysql主从(master-slave)复制安装配置
    | hqlong’s blog. I {{was|was actually} moved|{was|was actually} excited} enough to {drop|{leave|drop|{write|create}}|post} a {thought|{comment|{comment|leave a response}a response}} {:-P|:)|;)|;-)|:-)} I {do have|actually do have} {{some|a few}
    questions|a couple of questions|2 questions} for you {if you {don’t|do not|usually do not|tend not to} mind|if it’s {allright|okay}}.
    {Is it|Could it be} {just|only|simply} me or
    {do|does it {seem|appear|give the impression|look|look as if|look like} like} {some|a
    few} of {the|these} {comments|responses|remarks}
    {look|appear|come across} {like they are|as if they are|like} {coming from|written by|left by} brain dead {people|visitors|folks|individuals}?
    :-P And, if you are {posting|writing} {on|at} {other|additional} {sites|social sites|online sites|online social sites|places}, {I’d|I would} like to {follow|keep up with} {you|{anything|everything} {new|fresh} you
    have to post}. {Could|Would} you {list|make a list} {all|every one|the complete
    urls} of {your|all your} {social|communal|community|public|shared} {pages|sites} like
    your {twitter feed, Facebook page or linkedin profile|linkedin
    profile, Facebook page or twitter feed|Facebook page, twitter feed, or
    linkedin profile}?|
    {Hi there|Hello}, I enjoy reading {all of|through}
    your {article|post|article post}. I {like|wanted} to write a little comment to support you.|
    I {always|constantly|every time} spent my half an hour to read this {blog|weblog|webpage|website|web site}’s {articles|posts|articles or
    reviews|content} {everyday|daily|every day|all
    the time} along with a {cup|mug} of coffee.|
    I {always|for all time|all the time|constantly|every
    time} emailed this {blog|weblog|webpage|website|web site}
    post page to all my {friends|associates|contacts},
    {because|since|as|for the reason that} if like to read it {then|after that|next|afterward} my {friends|links|contacts} will too.|
    My {coder|programmer|developer} is trying to {persuade|convince}
    me to move to .net from PHP. I have always disliked the idea
    because of the {expenses|costs}. But he’s tryiong none the less.
    I’ve been using {Movable-type|WordPress} on {a number of|a
    variety of|numerous|several|various} websites for about a year and am {nervous|anxious|worried|concerned} about switching to
    another platform. I have heard {fantastic|very good|excellent|great|good}
    things about blogengine.net. Is there a way I can {transfer|import} all my
    wordpress {content|posts} into it? {Any kind of|Any} help would be {really|greatly} appreciated!|
    {Hello|Hi|Hello there|Hi there|Howdy|Good day}!
    I could have sworn I’ve {been to|visited} {this blog|this web site|this website|this site|your blog} before but after {browsing through|going
    through|looking at} {some of the|a few of the|many of the} {posts|articles} I
    realized it’s new to me. {Anyways|Anyhow|Nonetheless|Regardless}, I’m {definitely|certainly} {happy|pleased|delighted} {I found|I
    discovered|I came across|I stumbled upon} it and I’ll be {bookmarking|book-marking} it and checking back {frequently|regularly|often}!|
    {Terrific|Great|Wonderful} {article|work}!
    {This is|That is} {the type of|the kind of} {information|info} {that are meant to|that are supposed to|that should} be shared {around the|across the} {web|internet|net}.
    {Disgrace|Shame} on {the {seek|search} engines|Google} for {now not|not|no longer} positioning this {post|submit|publish|put up} {upper|higher}!
    Come on over and {talk over with|discuss with|seek advice from|visit|consult with} my {site|web site|website} .
    {Thank you|Thanks} =)|
    Heya {i’m|i am} for the first time here. I {came across|found} this board and I find It {truly|really} useful & it helped me out {a lot|much}.
    I hope to give something back and {help|aid} others like you {helped|aided} me.|
    {Hi|Hello|Hi there|Hello there|Howdy|Greetings}, {I think|I believe|I do believe|I do think|There’s no doubt that} {your site|your
    website|your web site|your blog} {might be|may be|could be|could
    possibly be} having {browser|internet browser|web
    browser} compatibility {issues|problems}. {When I|Whenever I} {look at your|take a look
    at your} {website|web site|site|blog} in Safari, it looks fine
    {but when|however when|however, if|however, when} opening in {Internet Explorer|IE|I.E.}, {it has|it’s got} some overlapping issues.
    {I just|I simply|I merely} wanted to {give you a|provide
    you with a} quick heads up! {Other than that|Apart
    from that|Besides that|Aside from that}, {fantastic|wonderful|great|excellent} {blog|website|site}!|
    {A person|Someone|Somebody} {necessarily|essentially} {lend a hand|help|assist} to make {seriously|critically|significantly|severely} {articles|posts} {I would|I
    might|I’d} state. {This is|That is} the {first|very first} time I frequented your {web page|website page} and {to this point|so far|thus far|up to now}?
    I {amazed|surprised} with the {research|analysis} you made to {create|make} {this actual|this particular} {post|submit|publish|put
    up} {incredible|amazing|extraordinary}. {Great|Wonderful|Fantastic|Magnificent|Excellent} {task|process|activity|job}!|
    Heya {i’m|i am} for {the primary|the first} time here.
    I {came across|found} this board and I {in finding|find|to find} It {truly|really} {useful|helpful} & it helped me out {a lot|much}.
    {I am hoping|I hope|I’m hoping} {to give|to offer|to provide|to present} {something|one thing} {back|again} and {help|aid} others {like you|such as you} {helped|aided} me.|
    {Hello|Hi|Hello there|Hi there|Howdy|Good day|Hey there}!
    {I just|I simply} {would like to|want to|wish to} {give you a|offer you a} {huge|big}
    thumbs up {for the|for your} {great|excellent} {info|information} {you have|you’ve got|you have got} {here|right here} on this post.
    {I will be|I’ll be|I am} {coming back to|returning to} {your blog|your site|your website|your web site} for more soon.|
    I {always|all the time|every time} used to
    {read|study} {article|post|piece of writing|paragraph} in news papers
    but now as I am a user of {internet|web|net} {so|thus|therefore} from now I am using net
    for {articles|posts|articles or reviews|content}, thanks to
    web.|
    Your {way|method|means|mode} of {describing|explaining|telling} {everything|all|the whole thing} in this
    {article|post|piece of writing|paragraph} is {really|actually|in
    fact|truly|genuinely} {nice|pleasant|good|fastidious}, {all|every one} {can|be
    able to|be capable of} {easily|without difficulty|effortlessly|simply} {understand|know|be
    aware of} it, Thanks a lot.|
    {Hi|Hello} there, {I found|I discovered} your {blog|website|web site|site} {by means of|via|by the use of|by way of} Google {at the same time as|whilst|even
    as|while} {searching for|looking for} a {similar|comparable|related} {topic|matter|subject}, your {site|web site|website}
    {got here|came} up, it {looks|appears|seems|seems
    to be|appears to be like} {good|great}. {I have|I’ve} bookmarked it in my google bookmarks.

    {Hello|Hi} there, {simply|just} {turned into|became|was|become|changed into} {aware of|alert to}
    your {blog|weblog} {thru|through|via} Google, {and found|and located} that
    {it is|it’s} {really|truly} informative. {I’m|I am} {gonna|going
    to} {watch out|be careful} for brussels. {I will|I’ll} {appreciate|be grateful} {if
    you|should you|when you|in the event you|in case you|for those who|if you happen to} {continue|proceed}
    this {in future}. {A lot of|Lots of|Many|Numerous} {other folks|folks|other
    people|people} {will be|shall be|might be|will probably be|can be|will likely be}
    benefited {from your|out of your} writing. Cheers!|
    {I am|I’m} curious to find out what blog {system|platform} {you have been|you happen to
    be|you are|you’re} {working with|utilizing|using}? I’m {experiencing|having} some {minor|small} security {problems|issues} with my latest {site|website|blog} and {I would|I’d} like to find something more {safe|risk-free|safeguarded|secure}.
    Do you have any {solutions|suggestions|recommendations}?|
    {I am|I’m} {extremely|really} impressed with your writing skills {and
    also|as well as} with the layout on your {blog|weblog}. Is this a paid theme or did
    you {customize|modify} it yourself? {Either way|Anyway} keep up the {nice|excellent}
    quality writing, {it’s|it is} rare to see a {nice|great} blog like this one {these days|nowadays|today}.|
    {I am|I’m} {extremely|really} {inspired|impressed} {with your|together with your|along with your} writing {talents|skills|abilities} {and also|as {smartly|well|neatly} as} with
    the {layout|format|structure} {for your|on your|in your|to your} {blog|weblog}.
    {Is this|Is that this} a paid {subject|topic|subject matter|theme} or did
    you {customize|modify} it {yourself|your self}? {Either way|Anyway} {stay|keep} up the
    {nice|excellent} {quality|high quality} writing,
    {it’s|it is} {rare|uncommon} {to peer|to see|to look} a {nice|great} {blog|weblog} like this
    one {these days|nowadays|today}..|
    {Hi|Hello}, Neat post. {There is|There’s} {a problem|an issue} {with your|together
    with your|along with your} {site|web site|website} in {internet|web} explorer, {may|might|could|would} {check|test} this?
    IE {still|nonetheless} is the {marketplace|market} {leader|chief} and {a large|a good|a big|a huge} {part of|section of|component to|portion of|component
    of|element of} {other folks|folks|other people|people} will {leave out|omit|miss|pass over} your
    {great|wonderful|fantastic|magnificent|excellent} writing {due to|because of} this problem.|
    {I’m|I am} not sure where {you are|you’re} getting your {info|information}, but {good|great} topic.
    I needs to spend some time learning {more|much more} or
    understanding more. Thanks for {great|wonderful|fantastic|magnificent|excellent} {information|info} I was looking for this {information|info} for
    my mission.|
    {Hi|Hello}, i think that i saw you visited my {blog|weblog|website|web site|site} {so|thus} i came to “return the favor”.{I am|I’m}
    {trying to|attempting to} find things to {improve|enhance}
    my {website|site|web site}!I suppose its ok to use {some
    of|a few of} yo\

  15. 贾奕夕定 说:

    杭州最好的夜场是杭州东方魅力www.dongfangmeili.cn

    杭州最好的ktv是哪儿?是杭州东方魅力www.dongfangmeili.cn

    杭州夜场招聘首选杭州东方魅力www.dongfangmeili.com.cn

    杭州最好的夜总会是杭州东方魅力www.dongfangmeili.com.cn

    杭州东方魅力官方网站欢迎你 联系电话:13666653761 官方微信:dongfangmeili

  16. Informations critiques de lecteur mp3

    Maintenant, la recherche est normalement la partie la plus amusante. J’arrive à chercher dans mes sac chloé pas cher blogs préférés, allez dans les librairies, de déterrer affiches de vieux films, lire des livres similaires sans être coincé dans photoshop pea

  17. Siobhan 说:

    I’m impressed, I have to admit. Rarely do I come across a blog that’s both equally educative and entertaining, and let me tell you,
    you’ve hit the nail on the head. The issue is something that not enough people
    are speaking intelligently about. Now i’m very happy I stumbled across this during my search for something concerning this.

  18. Alimente pour l’école

    Avec la technologie moderne, les fabricants ont été occupés à faire lunettes ray ban de nouveaux meubles en verre. Ils font le mobilier très confortable pour votre usage quotidien, durable et seraient en mesure de s’adapter à la conception que vous voulez. Ils ne prennent pa

  19. 曹佳空了 说:

    杭州最好的夜场是杭州东方魅力www.dongfangmeili.cn

    杭州最好的ktv是哪儿?是杭州东方魅力www.dongfangmeili.cn

    杭州夜场招聘首选杭州东方魅力www.dongfangmeili.com.cn

    杭州最好的夜总会是杭州东方魅力www.dongfangmeili.com.cn

    杭州东方魅力官方网站欢迎你 联系电话:13666653761 官方微信:dongfangmeili

  20. 段玎侍去 说:

    杭州最好的夜场是杭州东方魅力www.dongfangmeili.cn
    杭州最好的ktv是哪儿?是杭州东方魅力www.dongfangmeili.cn

    杭州夜场招聘首选杭州东方魅力www.dongfangmeili.com.cn

    杭州最好的夜总会是杭州东方魅力www.dongfangmeili.com.cn

    杭州东方魅力官方网站欢迎你 联系电话:13666653761 官方微信:dongfangmeili
    杭州最好的ktv是www.dongfangmeili.cn
    杭州夜场招聘杭州夜场招聘www.dongfangmeili.cn

  21. La taille des trous pour un putting green portable peut varier. Vous pouvez acheter un vert portable avec cups4inches de dimensions réglementaires. Ou vous pouvez acheter un vert portable avec petits cupssay trois pouces. Boat dior sac Services spécialisés fabrique des canots de secours, de sauvetag

  22. 王片是旭 说:

    杭州最好的夜场是杭州东方魅力www.dongfangmeili.cn

    杭州最好的ktv是哪儿?是杭州东方魅力www.dongfangmeili.cn
    杭州夜场招聘首选杭州东方魅力www.dongfangmeili.com.cn

    杭州最好的夜总会是杭州东方魅力www.dongfangmeili.com.cn

    杭州东方魅力官方网站欢迎你 联系电话:13666653761 官方微信:dongfangmeili

  23. 毛直佛外 说:

    杭州最好的夜场是杭州东方魅力www.dongfangmeili.cn
    杭州最好的ktv是哪儿?是杭州东方魅力www.dongfangmeili.cn

    杭州夜场招聘首选杭州东方魅力www.dongfangmeili.com.cn

    杭州最好的夜总会是杭州东方魅力www.dongfangmeili.com.cn

    杭州东方魅力官方网站欢迎你 联系电话:13666653761 官方微信:dongfangmeili
    杭州最好的ktv是www.dongfangmeili.cn
    杭州夜场招聘杭州夜场招聘www.dongfangmeili.cn

  24. t Is true, as I was pursuIng Bluefly thIs mornIng I came across thIs bag and almost skIpped rIght to the next one. Yet, there was somethIng allurIng about thIs bag. The Tulah Ray HIrst Large Hobo has some amazIng pebbled leather that Is bound to feel down-rIght fabulous. I wasn’t sure If the detaIlI

  25. 许红房帛 说:

    杭州最好的夜场是杭州东方魅力www.dongfangmeili.cn

    杭州最好的ktv是哪儿?是杭州东方魅力www.dongfangmeili.cn

    杭州夜场招聘首选杭州东方魅力www.dongfangmeili.com.cn

    杭州最好的夜总会是杭州东方魅力www.dongfangmeili.com.cn

    杭州东方魅力官方网站欢迎你 联系电话:13666653761 官方微信:dongfangmeili

发表评论

电子邮件地址不会被公开。 必填项已用*标注

您可以使用这些HTML标签和属性: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>