rabbitmq数据写入mysql方案_rabbitmq消费者插入mysql数据并实现断线自动重连

连接rabbitmq的代码

消费者断线重连：

package main

import (

"log"

"github.com/streadway/amqp"

"database/sql"

_"github.com/go-sql-driver/mysql"

//"time"

)

func insert(db *sql.DB, a []byte) {

stmt, err := db.Prepare("INSERT INTO rabbit (name) VALUES(?)")

stmt.Exec(a)

defer stmt.Close()

if err != nil {

log.Println(err)

return

}

}

func failOnError(err error, msg string) {

if err != nil {

log.Fatalf("%s: %s", msg, err)

}

}

func main() {

//打开mysql

db, err := sql.Open("mysql", "root:0022....hh@tcp(127.0.0.1:3306)/rabbitmq?charset=utf8")

if err != nil {

log.Fatalf("Open