User Tools

Site Tools


building_mariadb_on_freebsd

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Next revision Both sides next revision
building_mariadb_on_freebsd [2017/07/02 02:02]
k2patel created
building_mariadb_on_freebsd [2017/07/02 02:07]
k2patel
Line 1: Line 1:
-Build / Compile MariaDB on FreeBSD +====== ​Build / Compile MariaDB on FreeBSD ​======
-Getting Source+
  
-get source from MariaDB+==== Getting Source ==== 
 + 
 + 
 +get source from [[http://​www.mariadb.org/​|MariaDB]]\\
 extract to /​usr/​local/​src/​mariadb extract to /​usr/​local/​src/​mariadb
  
-Configure+==== Configure ​====
  
-Modular configure (usually you need to load plugins with my.cnf) i am using this one. 
  
 +**Modular configure** (usually you need to load plugins with my.cnf) i am using this one.
 +
 +<code bash>
 ./configure --with-extra-charsets=all --localstatedir=/​var/​db/​mysql ./configure --with-extra-charsets=all --localstatedir=/​var/​db/​mysql
 +</​code>​
 OR OR
  
-Build With Plugin +**Build With Plugin** 
 +<code bash>
 ./configure --with-extra-charsets=all ​ --with-plugin-maria --with-plugin-xtradb --localstatedir=/​var/​db/​mysql ./configure --with-extra-charsets=all ​ --with-plugin-maria --with-plugin-xtradb --localstatedir=/​var/​db/​mysql
-OR+</​code>​
  
-Static Build as suggested by MariaDB wiki.+OR
  
 +**Static Build** as suggested by MariaDB wiki.
 +<code bash>
 ./configure --prefix=/​usr/​local/​mysql --enable-assembler \ ./configure --prefix=/​usr/​local/​mysql --enable-assembler \
 --with-extra-charsets=all ​ --enable-thread-safe-client ​ --with-big-tables \ --with-extra-charsets=all ​ --enable-thread-safe-client ​ --with-big-tables \
Line 26: Line 33:
 --with-mysqld-ldflags=-all-static ​ --with-client-ldflags=-all-static \ --with-mysqld-ldflags=-all-static ​ --with-client-ldflags=-all-static \
 --with-zlib-dir=bundled --enable-local-infile --with-zlib-dir=bundled --enable-local-infile
 +</​code>​
 Now run “make -j4” and “make install” – will install it on system. Now run “make -j4” and “make install” – will install it on system.
  
-rc script+==== rc script ​==== 
  
 You can simply use script provided with port version of mysql. You can simply use script provided with port version of mysql.
 Just in case if you dont have it, use below. Just in case if you dont have it, use below.
  
-| /​usr/​local/​etc/​rc.d/​mysql+<code bash|/​usr/​local/​etc/​rc.d/​mysql>
 #!/bin/sh #!/bin/sh
 # #
Line 108: Line 117:
    
 run_rc_command "​$1"​ run_rc_command "​$1"​
 +</​code>​
 +
 Enable and Start Enable and Start
  
building_mariadb_on_freebsd.txt · Last modified: 2020/08/10 02:35 (external edit)