Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Verify the character set on MyCAT     - Linux iptables: basic principles and rules (Linux)

- Oracle data files deleted recover after physical (Database)

- Install mono offline on CentOS (Server)

- ActiveMQ5.10.2 version configuration JMX (Linux)

- Installation and deployment of MariaDB under CentOS (Database)

- CentOS / Linux NIC set IP address configuration (Linux)

- How to modify the Sublime in Tab four spaces (Linux)

- CentOS iptables firewall configuration (Linux)

- Elixir: the future of programming languages (Programming)

- C ++ containers (Programming)

- Ubuntu 14.04 LTS installed Hadoop 1.2.1 (distributed cluster mode) (Server)

- C language header file defines a global variable (Programming)

- Linux find command usage practices (Linux)

- Advanced Linux security settings (Linux)

- Linux network monitoring tools ntopng installation (Linux)

- Nagios plugin installation tutorial of Nrpe (Linux)

- To install Cinnamon desktop environment on your Ubuntu 14.04 / 12.04 (Linux)

- Oracle TAF Analysis (Database)

- Hadoop 2.6.0 stand-alone / pseudo-distributed installation (Server)

- Install and use automated tools Ansible in CentOS 7 (Linux)

 
         
  Verify the character set on MyCAT
     
  Add Date : 2018-11-21      
         
         
         
  MyCAT default character set is UTF8

The following logs to verify by looking at the different MySQL server and client character set the character set for MyCAT impact.

Log-related character set has three main parts:

1. Initialize MyCAT connection pool

2. heartbeat

3. sync when connected to execute SQL statements.

Because MyCAT achieve literacy is a three-node separation and automatic switching, the following modifications are on the localhost node character set MySQL instance, the other two points (192.168.244.146 and 192.168.244.144) are not modified. The default is

mysql> show variables like 'character_set_%';
+ -------------------------- + ---------------------- ------ +
| Variable_name | Value |
+ -------------------------- + ---------------------- ------ +
| Character_set_client | utf8 |
| Character_set_connection | utf8 |
| Character_set_database | latin1 |
| Character_set_filesystem | binary |
| Character_set_results | utf8 |
| Character_set_server | latin1 |
| Character_set_system | utf8 |
| Character_sets_dir | / usr / share / mysql / charsets / |
+ -------------------------- + ---------------------- ------ +
8 rows in set (0.01 sec)
First, when the client character set (character_set_client) is utf8, server-side character set (character_set_server) is latin1.

mysql> show variables like 'character_set_%';
+ -------------------------- + ---------------------- ------ +
| Variable_name | Value |
+ -------------------------- + ---------------------- ------ +
| Character_set_client | utf8 |
| Character_set_connection | utf8 |
| Character_set_database | latin1 |
| Character_set_filesystem | binary |
| Character_set_results | utf8 |
| Character_set_server | latin1 |
| Character_set_system | utf8 |
| Character_sets_dir | / usr / share / mysql / charsets / |
+ -------------------------- + ---------------------- ------ +
8 rows in set (0.00 sec)
MyCAT log output is as follows:

1. initialize the connection pool



2. heartbeat



3. sync when connected to execute SQL statements.



Second, when the client character set is latin1, server-side character set for latin1.

mysql> show variables like 'character_set_%';
+ -------------------------- + ---------------------- ------ +
| Variable_name | Value |
+ -------------------------- + ---------------------- ------ +
| Character_set_client | latin1 |
| Character_set_connection | latin1 |
| Character_set_database | latin1 |
| Character_set_filesystem | binary |
| Character_set_results | latin1 |
| Character_set_server | latin1 |
| Character_set_system | utf8 |
| Character_sets_dir | / usr / share / mysql / charsets / |
+ -------------------------- + ---------------------- ------ +
8 rows in set (0.00 sec)
MyCAT log output is as follows:

1. Initialize MyCAT connection pool



2. heartbeat



3. sync when connected to execute SQL statements.



Third, when the client character set is latin1, server-side character set is also utf8.

mysql> show variables like 'character_set_%';
+ -------------------------- + ---------------------- ------ +
| Variable_name | Value |
+ -------------------------- + ---------------------- ------ +
| Character_set_client | latin1 |
| Character_set_connection | latin1 |
| Character_set_database | utf8 |
| Character_set_filesystem | binary |
| Character_set_results | latin1 |
| Character_set_server | utf8 |
| Character_set_system | utf8 |
| Character_sets_dir | / usr / share / mysql / charsets / |
+ -------------------------- + ---------------------- ------ +
8 rows in set (0.00 sec)
MyCAT log output is as follows:

1. Initialize MyCAT connection pool



2. heartbeat



3. sync when connected to execute SQL statements.

Fourth, when the client character set is utf8, server-side character set is also utf8.

mysql> show variables like 'character_set_%';
+ -------------------------- + ---------------------- ------ +
| Variable_name | Value |
+ -------------------------- + ---------------------- ------ +
| Character_set_client | utf8 |
| Character_set_connection | utf8 |
| Character_set_database | utf8 |
| Character_set_filesystem | binary |
| Character_set_results | utf8 |
| Character_set_server | utf8 |
| Character_set_system | utf8 |
| Character_sets_dir | / usr / share / mysql / charsets / |
+ -------------------------- + ---------------------- ------ +
8 rows in set (0.00 sec)
MyCAT log output is as follows:

1. Initialize MyCAT connection pool



2. heartbeat



3. sync when connected to execute SQL statements.



to sum up:

MyCAT initialize the connection pool, heartbeat characters and server character set about that value character_set_server set. When the character set into the MySQL instance localhost utf8, because the character set of MySQL instance 192.168.244.146 and 192.168.244.144 two nodes does not change, so the implementation of heartbeat, localhost character set is utf8, the other two nodes still latin1.

Synchronous connection with the client about the character set that character_set_client set value.
     
         
         
         
  More:      
 
- Installation and configuration under Linux SVN server - Backup - Recovery - Scheduled Tasks (Server)
- Linux IO redirection (Linux)
- Linux / Unix desktops interesting: Christmas tree on the terminal (Linux)
- Getting Started with Java NIO (Programming)
- Understand ASP.NET 5 running the command: DNVM, DNX, and DNU (Server)
- Neo4j map data processing tab (Database)
- Stunning exclamation point at the Linux command line (Linux)
- Linux Change ssh port and disable remote root login at (Linux)
- Getting the Linux shell flow control statements (Programming)
- Nodejs nano library to handle couchdb: need a timeout (Database)
- Use exp exported EXP-00091 error (Database)
- Linux filtration empty file command summary (Linux)
- Binary search and modification (Programming)
- JavaScript is implemented without new keywords constructor (Programming)
- Xshell configure SSH free password (Server)
- libnet list of functions (Programming)
- Oracle inline view updates problems encountered (Database)
- The temporary operation of the document mkstemp on Linux (Linux)
- How to find on Linux and delete duplicate files: FSlint (Linux)
- Getting Started with Linux system to learn: how to check in a package is installed on Ubuntu (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.