… binary log and executing them on the SLAVE. Since MySQL 4.0 this process is a bit more involved having events… leaves no room for mistakes: mysql> show master status \G *************************** 1. row *************************** File: db04-bin.000068 Position: 98 Binlog_Do_DB…. mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 192.168.10.171 Master_User…
Comment: Percona XtraDB Cluster Feature 2: Multi-Master replication
April 1, 2012 By 22 Comments
…, We had install mysql-server-wsrep-5.5.20-23.4 with galera-23.2.0. When starting the second node…, donor: 0 Apr 1 14:14:27 ubuntu-server-129 mysqld: 120401 14:14:26 [Warning] IP address ‘192.168.210.128′ could not be resolved: Name or service not known Apr 1 14:14:27 ubuntu…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
… up to 98%. We have a DELL server with 2 – 4 cores CPUs means total 8 cores and 32 GB RAM…-increment-increment = 3 #auto-increment-offset = 1 #log-slave-updates skip_name_resolve #master-host = 192.168.0.203 #master-user = replication #master….x # clients (those using the mysqlclient10 compatibility package). #old_passwords=1 # Disabling symbolic-links is recommended to prevent assorted security risks…
