Skip To Main Content
Start Slave on Muck Rack

Start Slave

As seen in: DZone, cnblogs.com, CSDN
Is this you? As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work. Claim your profile
Back to Start Slave’s profile

Articles by Start Slave

Optimizing MySQL Performance - DZone

|
By Start Slave
| DZone Verified
Join the DZone community and get the full member experience. Join For Free As a cornerstone of many web applications, MySQL is a robust and reliable database management system. However, achieving optimal performance in MySQL requires a strategic approach to configuration, indexing, and query optimization. In this blog post, we’ll explore key practices to enhance MySQL performance, ensuring your database operates at peak efficiency. 1.
Open in Who Shared Issue with article?

【数据库】docker搭建mysql8一主两从节点，配置proxysql读写分离_docker proxysql-CSDN博客

|
By Grant Replication Slave, Stop Slave, Start Slave
| CSDN
一、docker 搭建 mysql8 一主两从节点 文件夹 mkdir -p /opt/osdba/mysql-node1/{conf,data,log,mysqld,mysql-file} mkdir -p /opt/osdba/mysql-node2/{conf,data,log,mysqld,mysql-file} mkdir -p /opt/osdba/mysql-node3/{conf,data,log,mysqld,mysql-file} rm -rf /opt/osdba/mysql-node1/* rm -rf /opt/osdba/mysql-node2/* rm -rf /opt/osdba/mysql-node3/* 主库 my.cnf cat > /opt/osdba/mysql-node1/conf/my.cnf <<- 'EOF' [client] port=3306 socket=/var/run/mysqld/mysql.sock [mysqld] datadir=/var/lib/mysql...
Open in Who Shared Issue with article?

kubernetes进阶 (三) 基础练习

|
By Start Slave, Grant All Privileges
| CSDN
前两天朋友给了我几道题，看着挺简单的，但实际做的时候发现坑不少，这里做下笔记 一、镜像构建部署lnmp 1、构建镜像 nginx、php、mysql 要求使用centos7作为基础镜像 2、使用deployment部署上面的容器,要求3个服务要放到一个pod中(虽然这样是不对的) 3、使用ingress 将上面部署的服务发布出去,通过访问nginx下的index.php访问链接到mysql数据库 4、nginx 和php 要求挂载宿主机的/apps/data/的目录做存储 我自己常用的一些加速源,如果你没有配置过就把下面的加上重启docker服务 vi /etc/docker/daemon.json { "exec-opts": ["native.cgroupdriver=systemd"], "registry-mirrors": [ "http://hub-mirror.c.163.com", "https://cn-north-4.mirror.huaweicloud.com", "https://registry.docker-cn.com",...
Open in Who Shared Issue with article?

K8S搭建MySQL集群_k8s部署mysql集群_Java王小怪的博客-CSDN博客

|
By Start Slave
| CSDN
使用K8S搭建MySQL一主一从集群。 注意：以下全部内容，需要把namespace: test中的test换成你要所部署集群所在的名称空间。 1、创建密钥 apiVersion: v1 kind: Secret metadata: name: mysql-secret namespace: etc2 labels: app: mysql type: Opaque data: password: MTIzNDU2Cg== # base64加密后密码 2、创建ConfigMap apiVersion: v1 kind: ConfigMap metadata: name: mysql namespace: test labels: app: mysql data: master.cnf: | # Master [mysqld] log-bin=mysqllog skip-name-resolve slave.cnf: | # Slave [mysqld] super-read-only skip-name-resolve log-bin=mysql-bin...
Open in Who Shared Issue with article?

k8s实战案例之基于StatefulSet控制器运行MySQL一主多从 - Linux-1874 - 博客园

|
By Start Slave, Query OK, Set -Ex
| cnblogs.com
Pod调度运⾏时，如果应⽤不需要任何稳定的标示、有序的部署、删除和扩展，则应该使⽤⼀组⽆状态副本的控制器来部署应⽤，例如 Deployment 或 ReplicaSet更适合⽆状态服务需求，⽽StatefulSet适合管理所有有状态的服务，⽐如MySQL、MongoDB集群等。 2.1、StatefulSet控制器特点 给每个pod分配固定且唯⼀的⽹络标识符 给每个pod分配固定且持久化的外部存储 对pod进⾏有序的部署和扩展 对pod进有序的删除和终⽌ 对pod进有序的⾃动滚动更新 2.2、StatefulSet的组成部分 Headless Service：⽤来定义Pod⽹络标识( DNS domain)，指的是短的service(丢失了domainname)。 StatefulSet：定义具体应⽤，有多少个Pod副本，并为每个Pod定义了⼀个域名。 volumeClaimTemplates： 存储卷申请模板，创建PVC，指定pvc名称⼤⼩，将⾃动创建pvc，且pvc必须由存储类供应。 3.1、基础镜像准备 3.1.1、准备mysql镜像 下载镜像...
Open in Who Shared Issue with article?

ShardingSphere主从复制_不积跬步无以至千里-陕西西安的博客-CSDN博客

|
By Import Com.baomidou.mybatisplus.annotation. IdType, import lombok.Builder, Stop Slave, Start Slave
| CSDN
数据库主从复制配置： mysql主从复制从0到1 docker启动多个mysql服务 安装指定版本mysql 主服务master-3307 启动主服务3307 docker run -d \ -p 3307:3306 \ -v /study/shardingsphere/mysql/master/conf:/etc/mysql/conf.d \ -v /study/shardingsphere/mysql/master/data:/var/lib/mysql \ -e MYSQL_ROOT_PASSWORD=123456 \ --name dk-mysql-master \ mysql:8.0.29 创建MySQL主服务器配置文件： 默认情况下MySQL的binlog日志是自动开启的，可以通过如下配置定义一些可选配置 配置如下内容 [mysqld] # 服务器唯一id，默认值1 server-id=1 # 设置日志格式，默认值ROW binlog_format=STATEMENT # 二进制日志名，默认binlog # log-bin=binlog #...
Open in Who Shared Issue with article?

How Distributed Databases Work

|
By Start Slave
| restack.io
Explore the mechanics of distributed databases and their role in AI tools for software dependency analysis. The framework for autonomous intelligence Load balancing is a critical technique in distributed databases that ensures efficient resource utilization and optimal performance. By distributing workloads evenly across multiple servers, it maximizes throughput and minimizes response times, preventing any single resource from becoming a bottleneck.
Open in Who Shared Issue with article?
Show More