How to Share a MySQL Connection between HTTP Goroutines in Go?-Golang-php.cn

Home

Backend Development

Golang

How to Share a MySQL Connection between HTTP Goroutines in Go?

Linda Hamilton

Nov 27, 2024 am 03:40 AM

How to Share a MySQL Connection between HTTP Goroutines in Go?

How to Share MySQL Connection between HTTP Goroutines?

In Go, the database/sql package simplifies the sharing of database connections between HTTP goroutines. By creating a connection pool, it automatically manages the opening and closing of database connections.

The sql.Open(...) function returns a connection pool handle, not just a single connection. The database/sql package handles opening new connections when the pool is fully utilized.

To share the database connection in the provided code sample, instantiate the db connection in the main() function and assign it to a global variable to facilitate its access by the HTTP handler.

var db *sql.DB // Global variable for sharing between main and HTTP handler

Then, in the main() function, use sql.Open(...) to initialize the connection pool. SetMaxIdleConns(...) configures the number of idle connections in the pool. A Ping() call ensures that a connection is established if needed.

func main() {
    var err error
    db, err = sql.Open("mysql", "root@unix(/tmp/mysql.sock)/mydb") // This opens a connection pool
    if err != nil {
        log.Fatalf("Error on initializing database connection: %s", err.Error())
    }

    db.SetMaxIdleConns(100)

    err = db.Ping() // This actually opens a connection if necessary
    if err != nil {
        log.Fatalf("Error on opening database connection: %s", err.Error())
    }
}

In the HomeHandler HTTP handler, use the global db variable to execute queries.

func HomeHandler(w http.ResponseWriter, r *http.Request) {
    var msg string
    err := db.QueryRow("SELECT msg FROM hello WHERE page=?", "home").Scan(&msg)
    if err != nil {
        fmt.Fprintf(w, "Database Error!")
    } else {
        fmt.Fprintf(w, msg)
    }
}

By following this approach, the database connection can be shared efficiently among HTTP goroutines without the need for manual connection opening and closing.

The above is the detailed content of How to Share a MySQL Connection between HTTP Goroutines in Go?. For more information, please follow other related articles on the PHP Chinese website!

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Golang's security settings on DebianMay 16, 2025 pm 01:15 PM

When setting up a Golang environment on Debian, it is crucial to ensure system security. Here are some key security setup steps and suggestions to help you build a secure Golang development environment: Security setup steps System update: Make sure your system is up to date before installing Golang. Update the system package list and installed packages with the following command: sudoaptupdatesudoaptupgrade-y Firewall Configuration: Install and configure a firewall (such as iptables) to limit access to the system. Only necessary ports (such as HTTP, HTTPS, and SSH) are allowed. sudoaptininstalliptablessud

How to optimize the performance of Kubernetes deployment on DebianMay 16, 2025 pm 01:12 PM

Optimizing and deploying Kubernetes cluster performance on Debian is a complex task involving multiple aspects. Here are some key optimization strategies and suggestions: Hardware resource optimization CPU: Ensure that sufficient CPU resources are allocated to Kubernetes nodes and pods. Memory: Increases the memory capacity of the node, especially for memory-intensive applications. Storage: Use high-performance SSD storage and avoid using network file systems (such as NFS) as they may introduce latency. Kernel parameter optimization edit /etc/sysctl.conf file, add or modify the following parameters: net.core.somaxconn: 65535net.ipv4.tcp_max_syn

How to schedule tasks in Debian by Python scriptsMay 16, 2025 pm 01:09 PM

In the Debian system, you can use cron to arrange timed tasks and realize the automated execution of Python scripts. First, start the terminal. Edit the crontab file of the current user by entering the following command: crontab-e If you need to edit the crontab file of other users with root permissions, please use: sudocrontab-uusername-e to replace username with the username you want to edit. In the crontab file, you can add timed tasks in the format as follows: *****/path/to/your/python-script.py These five asterisks represent minutes (0-59) and small

How to configure Golang network parameters in DebianMay 16, 2025 pm 01:06 PM

Adjusting Golang's network parameters in Debian system can be achieved in many ways. The following are several feasible methods: Method 1: Temporarily set environment variables by setting environment variables: Enter the following command in the terminal to temporarily set environment variables, and this setting is only valid in the current session. exportGODEBUG="gctrace=1netdns=go" where gctrace=1 will activate garbage collection tracking, and netdns=go will make Go use its own DNS resolver instead of the system default. Set environment variables permanently: add the above command to your shell configuration file, such as ~/.bashrc or ~/.profile

What are the shortcut keys for LibOffice on DebianMay 16, 2025 pm 01:03 PM

The shortcut keys for customizing LibOffice on Debian systems can be adjusted through system settings. Here are some commonly used steps and methods to set LibOffice shortcut keys: Basic steps to set LibOffice shortcut keys Open system settings: In the Debian system, click the menu in the upper left corner (usually a gear icon), and select "System Settings". Select a device: In the system settings window, select "Device". Select a keyboard: On the Device Settings page, select Keyboard. Find the command to the corresponding tool: In the keyboard settings page, scroll down to the bottom to see the "Shortcut Keys" option. Clicking it will bring a window to a pop-up. Find the corresponding LibOffice worker in the pop-up window

What are the precautions for Debian deploying KubernetesMay 16, 2025 pm 01:00 PM

When deploying a Kubernetes (K8s) cluster on a Debian system, multiple key points need to be paid attention to to ensure the stability and security of the cluster. Here are some major notes: Disable Swap partition: Starting with Kubernetes 1.8, Swap partition needs to be disabled. Swap can be temporarily disabled using the following command: sudoswapoff-a To permanently disable Swap, edit the /etc/fstab file and comment out the line containing "swap". Set kernel parameters: Enable IPv4 forwarding: sudotee/etc/sysctl.d/k8s.conf Set network parameters, such as net.bridge.brid

What are the advantages of Kubernetes deployment on DebianMay 16, 2025 pm 12:57 PM

Kubernetes (K8s for short) has the following advantages to deploying on Debian: Stability: Debian is a stable and reliable operating system suitable for Kubernetes operating environment. Many tutorials recommend using Debian12 as the underlying operating system for Kubernetes deployment, which shows that Debian provides a reliable operating environment that can meet the basic requirements of Kubernetes for operating systems. Security: Debian provides powerful security features such as SELinux and AppArmor, which can further enhance the security of Kubernetes clusters. Through reasonable configuration and optimization measures, Kuberne can be ensured

How to deploy a Kubernetes cluster on DebianMay 16, 2025 pm 12:54 PM

Deploying a Kubernetes cluster on a Debian system can be achieved in a variety of ways. Here are the detailed steps to set up a Kubernetes cluster on Debian12 using the kubeadm tool: Preparing to make sure your Debian system has been updated to the latest version. Make sure you have sudo users with administrator privileges. Ensure that all nodes can be connected to each other through a stable network. Installation steps: Set the host name and update the hosts file: On each node, use the hostnamectl command to set the host name, and add the corresponding relationship between the node IP and the host name in the /etc/hosts file. Disable swap partitions for all nodes: in order to make kubelet

See all articles