diankuozhi9810的博客

PrefaceMy virtual machine was simply created by vagrant in default mode without anything about the extra disk volume configuration.The default size is about 10.5G.In order to use the web ...

Preface When I was compiling the sysbench just now,I encountered some failures in the precedure.I'll show the issue and workaround below.Issues1. Executing autogen.sh script ...

Issue I encountered an error when I run the python script which need to import the module of "MySQLdb".The error shows like this:[root@docker1 script]# python Xtrabackup.pyTrace...

Preface Oracle claimed that11g RAC issupported on Redhat Linux 7 and above version,but there're still some incompatible issues in inplementing 11g GI on it.There're some main steps s...

Preface Yesterday I've installed the 11g GI software on CentOS 7.2.But I still encounter some troubles when I continue to install the database software in my environment.I've recorded ...

Preface Today I'm gonna export some test data to another server.The source server is Windows Server 2012 R2 and the tartget server is CentOS 7.2.Eventually,I found out that when using ...

Preface I've demontstrated several InnoDB locking cases in my previous blog.I'm gonna do the rest tests about InnoDB locks.ProcedureTest table information and the relevant va...

Preface Today I'm gonna implement a consul in my environment to discover service of MySQL database and check whether the master-slave is working normally.Introduce Consul ...

Preface As we know,InnoDB is index organized table.InnoDB engine supports row-level lock base on indexes,if there're no indexes on a certain table the record locks will upgrade to "tab...

Preface We used to use "find" command in linux or AIX when we need to get a certain file but cannot rember the precise name.We will execute "find /pathtobegin -name xxx" in our OS prom...

Preface Sometimes we need to collect information of MySQL server as a report when we first time take over the system by someone else.Espcially there're lots of servers for you to che...

Preface I've implemented ProxySQL on PXC yesterday but got some errors when configured query rules.I'm gonna do it again in my master-slave environment again.Let's see the procedure....

Preface As we all know,it's a common sense that separate reading and writing operations can immensely increse the performance of MySQL database.Especially the query operations by execu...

Preface When we add a new node into PXC structure,it will estimate the mothed(IST/SST) to transfer data to the new node.It's no wonder that sst will be automatically choosed.What if ...

Preface Yesterday I implemented a three-nodes PXC,but there were some errors when proceeding it.So I decide to research what's wrong with it.The operations and evidences shows below....

Preface Today,I'm gonna implement a PXC,Let's see the procedure.FrameworkHostnameIPPortOS VersionMySQL VersionXtrabackup versionzlm2192.168....

Preface ibdata1 file is a shared system tablespace of innodb engine.Although we always set variable of "innodb_file_per_table" to "on" which means put the data of table into their indi...

Preface I supposed we are encountering a situation that there's an anonymous user hasconnected in ourMySQL database with an account which has large privileges.The user is doing some ...

Preface MasterHA is a tool which can be used in MySQL HA architecture.I'm gonna implement it and have some tests depend on it later.FrameworkHostnameIPPortI...

Preface I've installed MasterHA yesterday,Now let's test the master-slave switch and failover feature.FrameworkHostnameIPPortIdentityOS VersionMySQL V...