Local mysql deployment respectively two: 192.168.79.130 and 192.168.79.131; Service normal boot, connect normal
XML configuration mycat scheam.

 
<? The XML version="1.0"?> 




/& gt; --> 
 
WriteType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100" & gt; 
 Select the user () & lt;/heartbeat> 
Password="root123" & gt; 
 
Password="root123"/& gt; --> 
 
 
WriteType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100" & gt; 
 Select the user () & lt;/heartbeat> 
& lt; ! - can have multi write hosts - & gt; 
Password="root123" & gt; 
 
Password="root123"/& gt; --> 
 
 
 
 
 problem: when the connection mycat create tabulated fault: 1064 op table not in schema - 'TB_TEST' 
 CodePudding user response: 
Build predicate sentence: 
The CREATE TABLE ` NewTable ` (
` id ` int (11), NOT NULL AUTO_INCREMENT, 
` title ` varchar (100), NULL, 
The PRIMARY KEY (` id `) 
) 
ENGINE=InnoDB 
;           
          

          

            
Page link：https//www.codepudding.com/database/21404.html
          
          

               
Prev:Bosses have successfully download the bicomb2 software!
               
Next:And then the data stored in the RFID card
          
        
      
    
  
  

    

      

        

          

            
 Tags：  
problems               
        
      
    
  
 

    

      

        

        	

            	
Related
            
          
             
        
      
    
  

  

    

      

        

          
 Links：  
          
CodePudding

            
      
    
  


  
About Us:          Contact Us      Terms of Service      
Privacy Policy
  
Copyright © 2010-2023，Powered By CodePudding