CentOS　MySQL 5.7编译安装

向右看齐 2022-04-24 05:24 228阅读 0赞

# [CentOS　MySQL 5.7编译安装][CentOS_MySQL 5.7] #

**CentOS　MySQL 5.7编译安装**

MySQL 5.7 GA版本的发布，也就是说从现在开始5.7已经可以在生产环境中使用，有任何问题官方都将立刻修复。

**MySQL 5.7主要特性：**

*  更好的性能：对于多核CPU、固态硬盘、锁有着更好的优化，每秒100W QPS已不再是MySQL的追求，下个版本能否上200W QPS才是吾等用户更关心的
 *  更好的InnoDB存储引擎
 *  更为健壮的复制功能：复制带来了数据完全不丢失的方案，传统金融客户也可以选择使用MySQL数据库。此外，GTID在线平滑升级也变得可能
 *  更好的优化器：优化器代码重构的意义将在这个版本及以后的版本中带来巨大的改进，Oracle官方正在解决MySQL之前最大的难题
 *  原生JSON类型的支持
 *  更好的地理信息服务支持：InnoDB原生支持地理位置类型，支持GeoJSON，GeoHash特性
 *  新增sys库：以后这会是DBA访问最频繁的库

MySQL 5.7已经作为数据库可选项添加到《OneinStack》

**安装依赖包**

[?][Link 1]

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> </td> 
   <td> 
    <div> 
     <div> 
      <code>yum -y </code> 
      <code>install</code> 
      <code>gcc gcc-c++ ncurses ncurses-devel cmake</code> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

**下载相应源码包**

[?][Link 1]

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> 
    <div>
      2 
    </div> 
    <div>
      3 
    </div> </td> 
   <td> 
    <div> 
     <div> 
      <code>cd</code> 
      <code>/root/oneinstack/src</code> 
     </div> 
     <div> 
      <code>wget http:</code> 
      <code>//downloads</code> 
      <code>.sourceforge.net</code> 
      <code>/project/boost/boost/1</code> 
      <code>.59.0</code> 
      <code>/boost_1_59_0</code> 
      <code>.</code> 
      <code>tar</code> 
      <code>.gz</code> 
     </div> 
     <div> 
      <code>wget http:</code> 
      <code>//cdn</code> 
      <code>.mysql.com</code> 
      <code>/Downloads/MySQL-5</code> 
      <code>.7</code> 
      <code>/mysql-5</code> 
      <code>.7.11.</code> 
      <code>tar</code> 
      <code>.gz</code> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

**添加mysql用户**

[?][Link 1]

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> </td> 
   <td> 
    <div> 
     <div> 
      <code>useradd</code> 
      <code>-M -s </code> 
      <code>/sbin/nologin</code> 
      <code>mysql</code> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

**预编译**

[?][Link 1]

**编译安装**

[?][Link 1]

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> 
    <div>
      2 
    </div> </td> 
   <td> 
    <div> 
     <div> 
      <code>make</code> 
      <code>-j `</code> 
      <code>grep</code> 
      <code>processor </code> 
      <code>/proc/cpuinfo</code> 
      <code>| </code> 
      <code>wc</code> 
      <code>-l` </code> 
      <code>#编译很消耗系统资源，小内存可能编译通不过</code> 
     </div> 
     <div> 
      <code>make</code> 
      <code>install</code> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

**启动脚本，设置开机自启动**

[?][Link 1]

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> 
    <div>
      2 
    </div> 
    <div>
      3 
    </div> 
    <div>
      4 
    </div> </td> 
   <td> 
    <div> 
     <div> 
      <code>/bin/cp</code> 
      <code>/usr/local/mysql/support-files/mysql</code> 
      <code>.server </code> 
      <code>/etc/init</code> 
      <code>.d</code> 
      <code>/mysqld</code> 
     </div> 
     <div> 
      <code>chmod</code> 
      <code>+x </code> 
      <code>/etc/init</code> 
      <code>.d</code> 
      <code>/mysqld</code> 
     </div> 
     <div> 
      <code>chkconfig --add mysqld</code> 
     </div> 
     <div> 
      <code>chkconfig mysqld on</code> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

**/etc/my.cnf，仅供参考**

[?][Link 1]

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> 
    <div>
      2 
    </div> 
    <div>
      3 
    </div> 
    <div>
      4 
    </div> 
    <div>
      5 
    </div> 
    <div>
      6 
    </div> 
    <div>
      7 
    </div> 
    <div>
      8 
    </div> 
    <div>
      9 
    </div> 
    <div>
      10 
    </div> 
    <div>
      11 
    </div> 
    <div>
      12 
    </div> 
    <div>
      13 
    </div> 
    <div>
      14 
    </div> 
    <div>
      15 
    </div> 
    <div>
      16 
    </div> 
    <div>
      17 
    </div> 
    <div>
      18 
    </div> 
    <div>
      19 
    </div> 
    <div>
      20 
    </div> 
    <div>
      21 
    </div> 
    <div>
      22 
    </div> 
    <div>
      23 
    </div> 
    <div>
      24 
    </div> 
    <div>
      25 
    </div> 
    <div>
      26 
    </div> 
    <div>
      27 
    </div> 
    <div>
      28 
    </div> 
    <div>
      29 
    </div> 
    <div>
      30 
    </div> 
    <div>
      31 
    </div> 
    <div>
      32 
    </div> 
    <div>
      33 
    </div> 
    <div>
      34 
    </div> 
    <div>
      35 
    </div> 
    <div>
      36 
    </div> 
    <div>
      37 
    </div> 
    <div>
      38 
    </div> 
    <div>
      39 
    </div> 
    <div>
      40 
    </div> 
    <div>
      41 
    </div> 
    <div>
      42 
    </div> 
    <div>
      43 
    </div> 
    <div>
      44 
    </div> 
    <div>
      45 
    </div> 
    <div>
      46 
    </div> 
    <div>
      47 
    </div> 
    <div>
      48 
    </div> 
    <div>
      49 
    </div> 
    <div>
      50 
    </div> 
    <div>
      51 
    </div> 
    <div>
      52 
    </div> 
    <div>
      53 
    </div> 
    <div>
      54 
    </div> 
    <div>
      55 
    </div> 
    <div>
      56 
    </div> 
    <div>
      57 
    </div> 
    <div>
      58 
    </div> 
    <div>
      59 
    </div> 
    <div>
      60 
    </div> 
    <div>
      61 
    </div> 
    <div>
      62 
    </div> 
    <div>
      63 
    </div> 
    <div>
      64 
    </div> 
    <div>
      65 
    </div> 
    <div>
      66 
    </div> 
    <div>
      67 
    </div> 
    <div>
      68 
    </div> 
    <div>
      69 
    </div> 
    <div>
      70 
    </div> 
    <div>
      71 
    </div> 
    <div>
      72 
    </div> 
    <div>
      73 
    </div> 
    <div>
      74 
    </div> 
    <div>
      75 
    </div> 
    <div>
      76 
    </div> 
    <div>
      77 
    </div> 
    <div>
      78 
    </div> </td> 
   <td> 
    <div> 
     <div> 
      <code>cat</code> 
      <code>&gt; </code> 
      <code>/etc/my</code> 
      <code>.cnf &lt;&lt; EOF</code> 
     </div> 
     <div> 
      <code>[client]</code> 
     </div> 
     <div> 
      <code>port = 3306</code> 
     </div> 
     <div> 
      <code>socket = </code> 
      <code>/tmp/mysql</code> 
      <code>.sock</code> 
     </div> 
     <div> 
      <code>default-character-</code> 
      <code>set</code> 
      <code>= utf8mb4</code> 
     </div> 
     <div> 
      <code>[mysqld]</code> 
     </div> 
     <div> 
      <code>port = 3306</code> 
     </div> 
     <div> 
      <code>socket = </code> 
      <code>/tmp/mysql</code> 
      <code>.sock</code> 
     </div> 
     <div> 
      <code>basedir = </code> 
      <code>/usr/local/mysql</code> 
     </div> 
     <div> 
      <code>datadir = </code> 
      <code>/data/mysql</code> 
     </div> 
     <div> 
      <code>pid-</code> 
      <code>file</code> 
      <code>= </code> 
      <code>/data/mysql/mysql</code> 
      <code>.pid</code> 
     </div> 
     <div> 
      <code>user = mysql</code> 
     </div> 
     <div> 
      <code>bind-address = 0.0.0.0</code> 
     </div> 
     <div> 
      <code>server-</code> 
      <code>id</code> 
      <code>= 1</code> 
     </div> 
     <div> 
      <code>init-connect = </code> 
      <code>'SET NAMES utf8mb4'</code> 
     </div> 
     <div> 
      <code>character-</code> 
      <code>set</code> 
      <code>-server = utf8mb4</code> 
     </div> 
     <div> 
      <code>#skip-name-resolve</code> 
     </div> 
     <div> 
      <code>#skip-networking</code> 
     </div> 
     <div> 
      <code>back_log = 300</code> 
     </div> 
     <div> 
      <code>max_connections = 1000</code> 
     </div> 
     <div> 
      <code>max_connect_errors = 6000</code> 
     </div> 
     <div> 
      <code>open_files_limit = 65535</code> 
     </div> 
     <div> 
      <code>table_open_cache = 128</code> 
     </div> 
     <div> 
      <code>max_allowed_packet = 4M</code> 
     </div> 
     <div> 
      <code>binlog_cache_size = 1M</code> 
     </div> 
     <div> 
      <code>max_heap_table_size = 8M</code> 
     </div> 
     <div> 
      <code>tmp_table_size = 16M</code> 
     </div> 
     <div> 
      <code>read_buffer_size = 2M</code> 
     </div> 
     <div> 
      <code>read_rnd_buffer_size = 8M</code> 
     </div> 
     <div> 
      <code>sort_buffer_size = 8M</code> 
     </div> 
     <div> 
      <code>join_buffer_size = 8M</code> 
     </div> 
     <div> 
      <code>key_buffer_size = 4M</code> 
     </div> 
     <div> 
      <code>thread_cache_size = 8</code> 
     </div> 
     <div> 
      <code>query_cache_type = 1</code> 
     </div> 
     <div> 
      <code>query_cache_size = 8M</code> 
     </div> 
     <div> 
      <code>query_cache_limit = 2M</code> 
     </div> 
     <div> 
      <code>ft_min_word_len = 4</code> 
     </div> 
     <div> 
      <code>log_bin = mysql-bin</code> 
     </div> 
     <div> 
      <code>binlog_format = mixed</code> 
     </div> 
     <div> 
      <code>expire_logs_days = 30</code> 
     </div> 
     <div> 
      <code>log_error = </code> 
      <code>/data/mysql/mysql-error</code> 
      <code>.log</code> 
     </div> 
     <div> 
      <code>slow_query_log = 1</code> 
     </div> 
     <div> 
      <code>long_query_time = 1</code> 
     </div> 
     <div> 
      <code>slow_query_log_file = </code> 
      <code>/data/mysql/mysql-slow</code> 
      <code>.log</code> 
     </div> 
     <div> 
      <code>performance_schema = 0</code> 
     </div> 
     <div> 
      <code>explicit_defaults_for_timestamp</code> 
     </div> 
     <div> 
      <code>#lower_case_table_names = 1</code> 
     </div> 
     <div> 
      <code>skip-external-locking</code> 
     </div> 
     <div> 
      <code>default_storage_engine = InnoDB</code> 
     </div> 
     <div> 
      <code>#default-storage-engine = MyISAM</code> 
     </div> 
     <div> 
      <code>innodb_file_per_table = 1</code> 
     </div> 
     <div> 
      <code>innodb_open_files = 500</code> 
     </div> 
     <div> 
      <code>innodb_buffer_pool_size = 64M</code> 
     </div> 
     <div> 
      <code>innodb_write_io_threads = 4</code> 
     </div> 
     <div> 
      <code>innodb_read_io_threads = 4</code> 
     </div> 
     <div> 
      <code>innodb_thread_concurrency = 0</code> 
     </div> 
     <div> 
      <code>innodb_purge_threads = 1</code> 
     </div> 
     <div> 
      <code>innodb_flush_log_at_trx_commit = 2</code> 
     </div> 
     <div> 
      <code>innodb_log_buffer_size = 2M</code> 
     </div> 
     <div> 
      <code>innodb_log_file_size = 32M</code> 
     </div> 
     <div> 
      <code>innodb_log_files_in_group = 3</code> 
     </div> 
     <div> 
      <code>innodb_max_dirty_pages_pct = 90</code> 
     </div> 
     <div> 
      <code>innodb_lock_wait_timeout = 120</code> 
     </div> 
     <div> 
      <code>bulk_insert_buffer_size = 8M</code> 
     </div> 
     <div> 
      <code>myisam_sort_buffer_size = 8M</code> 
     </div> 
     <div> 
      <code>myisam_max_sort_file_size = 10G</code> 
     </div> 
     <div> 
      <code>myisam_repair_threads = 1</code> 
     </div> 
     <div> 
      <code>interactive_timeout = 28800</code> 
     </div> 
     <div> 
      <code>wait_timeout = 28800</code> 
     </div> 
     <div> 
      <code>[mysqldump]</code> 
     </div> 
     <div> 
      <code>quick</code> 
     </div> 
     <div> 
      <code>max_allowed_packet = 16M</code> 
     </div> 
     <div> 
      <code>[myisamchk]</code> 
     </div> 
     <div> 
      <code>key_buffer_size = 8M</code> 
     </div> 
     <div> 
      <code>sort_buffer_size = 8M</code> 
     </div> 
     <div> 
      <code>read_buffer = 4M</code> 
     </div> 
     <div> 
      <code>write_buffer = 4M</code> 
     </div> 
     <div> 
      <code>EOF</code> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

**初始化数据库**

注：

*  之前版本mysql\_install\_db是在mysql\_basedir/script下，5.7放在了mysql\_install\_db/bin目录下,且已被废弃
 *  "--initialize"会生成一个随机密码(~/.mysql\_secret)，而"--initialize-insecure"不会生成密码
 *  \--datadir目标目录下不能有数据文件

**启动数据库**

[?][Link 1]

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> </td> 
   <td> 
    <div> 
     <div> 
      <code>/usr/local/mysql/bin/mysqld</code> 
      <code>--initialize-insecure --user=mysql --basedir=</code> 
      <code>/usr/local/mysql</code> 
      <code>--datadir=</code> 
      <code>/data/mysql</code> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

**设置数据库密码**

[?][Link 1]

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> 
    <div>
      2 
    </div> 
    <div>
      3 
    </div> 
    <div>
      4 
    </div> 
    <div>
      5 
    </div> </td> 
   <td> 
    <div> 
     <div> 
      <code>dbrootpwd=oneinstack </code> 
      <code>#数据库root密码</code> 
     </div> 
     <div> 
      <code>/usr/local/mysql/bin/mysql</code> 
      <code>-e </code> 
      <code>"grant all privileges on *.* to root@'127.0.0.1' identified by \"$dbrootpwd\" with grant option;"</code> 
     </div> 
     <div> 
      <code>/usr/local/mysql/bin/mysql</code> 
      <code>-e </code> 
      <code>"grant all privileges on *.* to root@'localhost' identified by \"$dbrootpwd\" with grant option;"</code> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

posted @ 2018-05-23 18:50 [疯狂的米粒儿][Link 2] 阅读( ...) 评论( ...) [编辑][Link 3] 收藏

[CentOS_MySQL 5.7]: https://www.cnblogs.com/Su-per-man/p/9078705.html
[Link 1]: http://www.jb51.net/article/101419.htm#
[Link 2]: https://www.cnblogs.com/Su-per-man/
[Link 3]: https://i.cnblogs.com/EditPosts.aspx?postid=9078705