修改schema.xml文件，配置读写库信息

    <?xml version=”1.0”?>
    <!DOCTYPE mycat:schema SYSTEM “schema.dtd”>









    select user()




    启动服务mycat start

    测试连接:(连接mycat的端口 ，用户名密码在server.xml定义)

    连接测试：

    1. [root@ha02 logs]# for (( i=0;i<5;i++ )); do mysql -uroot -p123456 -h192.168.247.141 -P8066 -e"begin;select @@server_id;commit;"; done
    2. +-------------+
    3. | @@server_id |
    4. +-------------+
    5. |        1611 |
    6. +-------------+
    7. +-------------+
    8. | @@server_id |
    9. +-------------+
    10. |        1611 |
    11. +-------------+
    12. +-------------+
    13. | @@server_id |
    14. +-------------+
    15. |        1611 |
    16. +-------------+
    17. +-------------+
    18. | @@server_id |
    19. +-------------+
    20. |        1611 |
    21. +-------------+
    22. +-------------+
    23. | @@server_id |
    24. +-------------+
    25. |        1611 |
    26. +-------------+
    28. ## 无状态
    29. [root@ha02 logs]# for (( i=0;i<5;i++ )); do mysql -uroot -p123456 -h192.168.247.141 -P8066 -e"select @@server_id;"; done
    30. +-------------+
    31. | @@server_id |
    32. +-------------+
    33. |        1621 |
    34. +-------------+
    35. +-------------+
    36. | @@server_id |
    37. +-------------+
    38. |        1621 |
    39. +-------------+
    40. +-------------+
    41. | @@server_id |
    42. +-------------+
    43. |        1621 |
    44. +-------------+
    45. +-------------+
    46. | @@server_id |
    47. +-------------+
    48. |        1621 |
    49. +-------------+
    50. +-------------+
    51. | @@server_id |
    52. +-------------+
    53. |        1621 |
    54. +-------------+