Guest User

Untitled

a guest
Jul 30th, 2018
276
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.27 KB | None | 0 0
  1. root@localhost:~# sudo more /etc/mysql/conf.d/galera.cnf
  2. [mysqld]
  3. binlog_format=ROW
  4. default-storage-engine=innodb
  5. innodb_autoinc_lock_mode=2
  6. bind-address=0.0.0.0
  7. # Galera Provider Configuration
  8. wsrep_on=ON
  9. wsrep_provider=/usr/lib/galera/libgalera_smm.so
  10. # Galera Cluster Configuration
  11. wsrep_cluster_name="galera_cluster"
  12. wsrep_cluster_address="gcomm://192.168.143.81,192.168.148.75"
  13.  
  14. # Galera Synchronization Configuration
  15. wsrep_sst_method=rsync
  16.  
  17. # Galera Node Configuration
  18. wsrep_node_address="192.168.143.81"
  19. wsrep_node_name="Node1"
  20.  
  21. mysqld]
  22. binlog_format=ROW
  23. default-storage-engine=innodb
  24. innodb_autoinc_lock_mode=2
  25. bind-address=0.0.0.0
  26. # Galera Provider Configuration
  27. wsrep_on=ON
  28. wsrep_provider=/usr/lib/galera/libgalera_smm.so
  29. # Galera Cluster Configuration
  30. wsrep_cluster_name="galera_cluster"
  31. wsrep_cluster_address="gcomm://192.168.143.81,192.168.148.75"
  32.  
  33. # Galera Synchronization Configuration
  34. wsrep_sst_method=rsync
  35.  
  36. # Galera Node Configuration
  37. wsrep_node_address="192.168.148.75"
  38. wsrep_node_name="Node2”
  39.  
  40. spring.datasource.url=jdbc:mysql://192.168.143.81:3306/can_peris_db
  41. spring.datasource.username=peris
  42. spring.datasource.password=3nRam0nD3L3s0l1v3s
  43. spring.jpa.show-sql=false
  44. spring.jpa.properties.hibernate.format_sql=true
  45. hibernate.dialect=org.hibernate.dialect.MySQLDialect
Add Comment
Please, Sign In to add comment