aws db cluster

--num_threads=8 RunInsertTestSysbench--test=/usr/share/doc/sysbench/tests/db/insert.lua--oltp-table-size=1000000--mysql-table-engine=innodb --mysql-user=sbtest--mysql-password=sbpass--mysql-port=3306--mysql-host=192.168.70.72--mysql-db=sbtest-- Max-requests=0--max-time=120--oltp-tables-count=1--report-interval=10--num_threads=8 RunTest Results 8 thread read 120s inse

Label:Complete timing Task Solution Spring Integration + Timing task itself management +db persistence + cluster Maven Dependency Execute the SQL statement (http://www.quartz-scheduler.org/) from the GZ file downloaded from the official website , note the jar version and SQL used Scripts must remain consistent. Otherwise there will be a variety of wonderful problems. For exampl

Label: There are three common ways of doing this, 1, automatically determine whether SQL is read, to select the database connection: When instantiating a PHP db class, you need to connect two servers at a time, and then choose different connections based on SLQ, for example: $link _w = mysql_connect ($w _host, $user, $pwd); $link _r = mysql_connect ($r _host, $user, $pwd); Execute SQL if (Preg_match ("/^select/i", Trim ($sql))) {

; "Src=" https://s4.51cto.com/wyfs02/M01/9C/6C/wKioL1lwSrqA4lvtAACv9cNba5Q994.png-wh_500x0-wm_ 3-wmp_4-s_2819583354.png "title=" image 3.png "alt=" Wkiol1lwsrqa4lvtaacv9cnba5q994.png-wh_50 "/>[Email protected] ~]$ srvctl stop nodeapps-n Node1[Email protected] ~]$ srvctl stop nodeapps-n Node2650) this.width=650; "Src=" https://s1.51cto.com/wyfs02/M01/9C/6C/wKioL1lwStrSUdQmAADFmWS6yJg189.png-wh_500x0-wm_ 3-wmp_4-s_2061809010.png "title=" image 4.png "alt=" wkiol1lwstrsudqmaadfmws6yjg189.png-wh_50

', master_port=3306,master_user= ' rep ', master_password= ' pcm123456 ', Master_log_file= ' mysql-bin.000004 ', master_log_pos=712372;(4) Start slave to view the status of slave. It succeeds here, and if you want to test it, you can test it as you did in the previous blog post.3. Use keepalived to achieve high availability of the database.(1) Install keepalived software, set to bootYum Install Keepalivedecho "/etc/init.d/keepalived start" >>/etc/rc.local(2) Configure the keepalived configurati

to:Real_server 192.168.33.11; The priority level is changed from 100 to 90.Vi/etc/keepalived/keepalied.conf! Configuration File for Keepalivedglobal_defs{ notification_email{ [email protected] } [emailprotected] smtp_server127.0.0.1 smtp_connect_timeout30 router_idlvs_ devel} #vip1 vrrp_instancevi_1{ state backup interfaceeth0 lvs_sync_daemon_ intefaceeth0 virtual_router_id151 priority 90 advert_int5 nopreempt authentication{ auth_typepass auth_pass2222 } virtual_ipaddress{ 192.168.33.100