windows10配置Nosql

安装Java

在命令行下输入java -version和javac命令看到如下输出说明安装成功。还需要进行添加系统变量等操作。

安装python

安装anaconda集成开发环境，之前已安装。

安装必要的Python第三方软件包

pip install elasticsearch==5.4.0 -i http://pypi.douban.com/simple --trusted-host pypi.douban.com
pip install PyMySQL -i http://pypi.douban.com/simple --trusted-host pypi.douban.com
conda install -c conda-forge tqdm

之前已经安装成功。

安装、配置、启动Elasticsearch数据库服务

全部按照教程下载安装，并且修改文件注释。

# ======================== Elasticsearch Configuration =========================
#
# NOTE: Elasticsearch comes with reasonable defaults for most settings.
#       Before you set out to tweak and tune the configuration, make sure you
#       understand what are you trying to accomplish and the consequences.
#
# The primary way of configuring a node is via this file. This template lists
# the most important settings you may want to configure for a production cluster.
#
# Please see the documentation for further information on configuration options:
# <http://www.elastic.co/guide/en/elasticsearch/reference/current/setup-configuration.html>
#
# ---------------------------------- Cluster -----------------------------------
#
# Use a descriptive name for your cluster:
#
 cluster.name: my-application
#
# ------------------------------------ Node ------------------------------------
#
# Use a descriptive name for the node:
#
 node.name: node-1
#
# Add custom attributes to the node:
#
# node.rack: r1
#
# ----------------------------------- Paths ------------------------------------
#
# Path to directory where to store the data (separate multiple locations by comma):
#
# path.data: /path/to/data
#
# Path to log files:
#
# path.logs: /path/to/logs
#
# ----------------------------------- Memory -----------------------------------
#
# Lock the memory on startup:
#
 bootstrap.mlockall: true
#
# Make sure that the `ES_HEAP_SIZE` environment variable is set to about half the memory
# available on the system and that the owner of the process is allowed to use this limit.
#
# Elasticsearch performs poorly when the system is swapping the memory.
#
# ---------------------------------- Network -----------------------------------
#
# Set the bind address to a specific IP (IPv4 or IPv6):
#
 network.host: 127.0.0.1
#
# Set a custom port for HTTP:
#
 http.port: 9200
#
# For more information, see the documentation at:
# <http://www.elastic.co/guide/en/elasticsearch/reference/current/modules-network.html>
#
# --------------------------------- Discovery ----------------------------------
#
# Pass an initial list of hosts to perform discovery when new node is started:
# The default list of hosts is ["127.0.0.1", "[::1]"]
#
# discovery.zen.ping.unicast.hosts: ["host1", "host2"]
#
# Prevent the "split brain" by configuring the majority of nodes (total number of nodes / 2 + 1):
#
 discovery.zen.minimum_master_nodes: 1
#
# For more information, see the documentation at:
# <http://www.elastic.co/guide/en/elasticsearch/reference/current/modules-discovery.html>
#
# ---------------------------------- Gateway -----------------------------------
#
# Block initial recovery after a full cluster restart until N nodes are started:
#
# gateway.recover_after_nodes: 3
#
# For more information, see the documentation at:
# <http://www.elastic.co/guide/en/elasticsearch/reference/current/modules-gateway.html>
#
# ---------------------------------- Various -----------------------------------
#
# Disable starting multiple nodes on a single system:
#
# node.max_local_storage_nodes: 1
#
# Require explicit names when deleting indices:
#
# action.destructive_requires_name: true
# index.analysis.analyzer.default.type: ik

在Windows命令行中，进入进入ES数据库源码目录，执行bin\elasticsearch.bat即可启动包含一个ES数据库实例的ES数据库服务。

在浏览器中输入网址http://localhost:9200/_plugin/head即可使用之前安装的head插件查看ES集群（包含一个ES节点node1）状态。

创建表结构

1. ES：使用code目录中的python es_create.py
2. mysql的相关操作
3. 

添加结点node-2

数据写入

1. ES：在Windows cmd中进入到code目录中运行python es_write.py
2. MySQL: 在Windows cmd中进入到code目录中运行python mysql_search.py

第一次尝试写入数据时出现错误

pymysql.err.DataError: (1406, "Data too long for column 'content' at row 1"),

之后在mysql环境下运行

set global SQL_MODE="NO_ENGINE_SUBSTITUTION";

最后就可以正常写入数据了。

数据检索