Categories

MySQL InnoDB engine B + tree index simple finishing instructions

There are several types of InnoDB engine tables in MySQL (the following index, no special instructions, refers to the InnoDB engine table index.) 0 = Secondary Index, 2-level index, 1 = Clustered Index, clustered index 2 = Unique Index, Unique Index 3 = Primary Index, Primary Key Index 32 = Full-text Index, Full Index 64 […]

MySQL Databases to Separate Disks

You may have a database server which started out small, with all its databases stored on the same disks, that is now experiencing severe storage I/O bottlenecks. With so many heavily accessed databases on the same storage device your queries are timing out while waiting for response from disk. And despite all your efforts in […]

Installing Memcached to Improve Database Performance

SQL databases are very good at storing and retrieving data, and they can do so quickly. However, no matter how well you tune your database servers there will come a time during periods of high traffic that your database server becomes a large bottleneck. By utilizing technologies like Memcache, we can keep results of frequently […]

Installing and Configuring MariaDB 10 on CentOS 6

This tutorial will guide you through the deployment process of MariaDB on a Red Hat-based Linux server, such as CentOS. We’ll start by configuring the hardware and then move into the installation and configuration of MariaDB.

MariaDB is a fork of the very popular and open source MySQL database, which is now owned by Oracle. […]

Detailed MySQL basic commands

Detailed MySQL basic commands

Format: mysql -h host address -u user name -p User password

1, is connected to the machine on MYSQL. First, open a DOS window, then enter the directory mysql \ bin, then type the command mysql -u root -p, you lose the password prompt after the carriage return may or may […]

Mysql Secure Installation for non default socket.

Mysql Secure Installation for non default socket. SECURING MYSQL SERVER –

mysql_secure_installation is a script useful to

set root password disallowing root login remotely removing anonymous user accounts after first installation removing test database which can be accessed by any users

Above script would work for default socket location i.e /var/lib/mysql/mysql.sock

If the server is started […]

MYSQL mariadb CENTOS 7

MYSQL CENTOS 7

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm rpm -ivh mysql-community-release-el7-5.noarch.rpm yum update yum install mysql-server

systemctl start mysqld

[root@clusterserver1 ~]# systemctl start mysqld [root@clusterserver1 ~]# systemctl enable mysqld [root@clusterserver1 ~]# systemctl status mysqld

[root@clusterserver1 ~]# mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

[…]

MariaDB centos 7

[root@clusterserver1 ~]# yum -y install mariadb mariadb-server Loaded plugins: fastestmirror Repodata is over 2 weeks old. Install yum-cron? Or run: yum makecache fast base                                                                                                                                                                               | 3.6 kB  00:00:00 epel/x86_64/metalink                                                                                                                                                               | 3.9 kB  00:00:00 epel                                                                                                                                                                               | 4.3 kB  00:00:00 extras                                                                                                                                                                             | 3.4 kB  00:00:00 updates                                                                                                                                                                            | 3.4 kB  00:00:00 (1/4): extras/7/x86_64/primary_db                                                                                                                                                  | 101 kB  00:00:00 (2/4): […]

Yum to configure multiple master cluster MariaDB Galera

Yum to configure multiple master cluster MariaDB Galera Hereinafter, if the command is not preceded by PS1 is to represent the three nodes are required to perform the same action, if it means the implementation of the action on the specified node

cluster1.rmohan.com       Centos6.7   192.168.1.60    MariaDB cluster2.rmohan.com       Centos6.7   192.168.1.62    MariaDB cluster3.rmohan.com       Centos6.7   192.168.1.63    MariaDB

[…]

multi-master MariaDB Galera Cluster

CentOS 6.7 Linux compilation configure a multi-master MariaDB Galera Cluster for HA.

Multi-master MariaDB Galera Cluster

Summary Galera is essentially a wsrep provider (provider), relies on the wsrep API interface. Wsrep API defines a set of applications and replication callback call library to implement transaction database synchronization write set (writeset) replication, and similar applications. The […]

Page 1 of 212