I believe that this problem will be a lot of people, especially those who have used other databases (such as Oracle), I did not care too much about this issue, plus some books and online articles are not detailed enough, and have not tested, leading
1. master node Authorized synchronization User
2. master node Modify configuration file
3. Modifying a configuration file from a node
4. View status after the primary node is locked
5. Configure and initiate synchronization, view
Tell me about my experience with mongify, for reference only.
Mongify mongo3.0 Scram-sha-1 Login authentication method is not supported, you need to manually modify the Mongify code, and compile.
Mongify's official Support Sync command will
Python can actually manipulate the database, think if you can write SQL statements in Python, and thus directly achieve the purpose of manipulating the database, how cool!Python's standard database interface is Python DB-API, which installs
Whether you are compiling the installation, the binary installation, or the yum,rpm, the MySQL is initialized to be used.Below to introduce the next initialization of the installation of MySQL, before installation to prepare the My.cnf file Oh ~ ~
Preface:
Because many business tables use a design pattern that violates the first paradigm for historical reasons or for performance reasons. That is, multiple attribute values are stored in the same column (see the following table for specific
MySQL Master-slave replicationPrimary server ip:192.168.99.10From server ip:192.168.99.20(i) Install MySQL (same as master server operation)Yum-y Install gcc gcc-c++ ncurses-develAdd groups and Users#/usr/sbin/groupadd MySQL#/usr/sbin/useradd-g
Development boss request through Binlog query a modified data, data was detected after asked me, there is no possibility Binlog will not record, answer no, because the data is modified, if the failure of the direct rollback, will not be recorded in
1. What is data paging: data paging is a lot of records like a book page, each page shows how many rows of records;2. Why data paging : When we make a SQL statement query, if the data has thousands of rows of records, if the same page to display,
1 go to re-querySelect DISTINCT ID from User_info where xxxxxx2 sorting in GROUP by grouping queriesThe group by itself does not have a sort function, which is probably not the perfect place for MySQL, but we can do thatSelect attack_id, Time from
MySQL is the most popular relational database management system, and is one of the most commonly used database, it is necessary to master its commonly used operation statements.Here is a summary of the MYSQP Common & useful SQL statements:1,MySQL -u
#! /bin/bash# v.mysql-5.6.30-linux-glibc2.5-x86_64.tar.gz# only install master Mysql# time:2016-08-15# pkg dirpkg_dir= ' pwd ' # mysql base dirdata_dir= "/data/ Mysql_root/mysql "base_dir="/usr/local/mysql "# create mysql group and userecho " Start
Method One:It is not difficult to log in to MySQL by modifying the configuration file.Operation Steps:
Locate the configuration file under the installation directory My.ini
2. Find the [mysqld] field in My.ini and add it under it .
Database, table, field, record: Add, delete, change, check. Classification to learn, the focus is the query./*database, table, field, record: Add, delete, change, check*/--1. Database: Adding and deleting changesCreateDatebaseif not existsJkxy;Drop
#! /bin/bash# v.mysql-5.6.30-linux-glibc2.5-x86_64.tar.gz# only Install master mysql# time:2016-08-15# pkg dirpkg_dir= ' PWD ' # mysql base dirdata_dir= "/data/mysql_root/mysql" base_dir= "/usr/local/mysql" # create MySQL Group and Userecho " Start
1. Extract to any root directory of the diskIf you log in directly, you will be reported"MySQL is not an internal command" this is due to the absence of a configuration environment2.---Advanced---environment variables for computer---propertiesAdd
Code:SELECT FROM_UNIXTIME(1234567890, ‘%Y-%m-%d %H:%i:%S‘)Report:In MySQL, the storage type of a time field is int (11), and how to convert it into a character type, for example, stored as 13270655222, needs to be converted into YYYY-MM-DD form.Use
Mysql multi-instance installation script and mysql instance installation script
#! /Bin/bash # v.mysql-5.6.30-linux-glibc2.5-x86_64.tar.gz # only install master mysql # time: 2016-08-15 # pkg dirpkg_dir = 'pwd' # mysql base dirdata_dir =
MySql5.7.14 installation tutorial (decompress version) and mysql5.7.14
Go to the official tutorial below:
Step 1: Download and decompress the latest MySQL file:
Download the latest MySQL-mysql-5.7.12
Decompress the downloaded file to your favorite
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service