MariaDB 5.6

tripple · 2013-11-01 14:45:25

I need a feature that is only included in MySQL/MariaDB 5.6

Do I need to install from source? I've searched the AUR to no avail...

karol · 2013-11-01 15:00:41

I don't see any downloads for MariaDB 5.6. Are you sure it has been released?
You can use ABS or https://projects.archlinux.org/svntogit … es/mariadb and modify it so it downloads the new source.
There's mysql 5.6 https://aur.archlinux.org/packages/mysql/

Edit: https://mariadb.com/kb/en/plans-for-56/
If I'm reading it right, mariadb 5.6 is not out yet.

Last edited by karol (2013-11-01 15:03:29)

tripple · 2013-11-01 16:39:20

It looks like I don't need version 5.6 specifically, just 10.0.1

https://mariadb.com/blog/what-does-mari … ilable-now
See:
MariaDB 10.0 Reimplemented Features

spcode · 2013-11-01 17:49:48

https://downloads.mariadb.org/mariadb/10.0.1/ (download)
https://mariadb.com/kb/en/compiling-mar … om-source/ (instructions)

Last edited by spcode (2013-11-01 17:50:10)

tripple · 2013-11-02 09:07:44

spcode wrote:

https://downloads.mariadb.org/mariadb/10.0.1/ (download)
https://mariadb.com/kb/en/compiling-mar … om-source/ (instructions)

Please don't patronize me. I know /how/ to compile from source, I'm just wondering if I can get it in package form.

spcode · 2013-11-02 09:11:18

-- Deleted

Last edited by spcode (2013-11-02 09:30:59)

fukawi2 · 2013-11-02 09:57:19

tripple wrote:

Please don't patronize me. I know /how/ to compile from source, I'm just wondering if I can get it in package form.

Please assume good intent when interacting with others on our forums; English may not be spcode's native language, so his/her suggestion may have been a genuine misunderstanding of your request. I'm not saying this is the case, but it's a reasonable possibility without assuming someone is patronizing you.

On to your actual query, if the version of a package you need is not available in the repos you need to either search for Unofficial User Repositories that may provide what you need, otherwise packaging it yourself using ABS will be required.

tripple · 2013-11-02 10:21:10

I'm just compiling it from source. 50% done "make", may as well go through with it
Thanks though.

spcode I appreciate the links, but I was looking for an answer more like fukawi2's.
If you had verified MariaDB 10.0.1 is not available in package form, you could have stated that and explained that my only option is to install from source.
Apologies if you didn't understand the original post.

fukawi2 · 2013-11-02 10:36:26

It's a shame you're already 50% through compiling; it would have been much better to use ABS for maintainability (unless you are using ABS and just omitted that from your post )

tripple · 2013-11-02 11:15:44

Managed to compile it with ABS... it's actually such a convenient system!

Here's my PKGBUILD if anyone's interested:

# $Id: PKGBUILD 198315 2013-10-30 14:07:13Z allan $
# Maintainer: Bartłomiej Piotrowski <nospam@bpiotrowski.pl>

pkgbase=mariadb
pkgname=('libmariadbclient' 'mariadb-clients' 'mytop' 'mariadb')
pkgver=10.0.1
_pkgver=${pkgver/.a/a}
pkgrel=1
arch=('i686' 'x86_64')
license=('GPL')
url='http://mariadb.org/'
makedepends=('cmake' 'openssl' 'zlib')
source=(http://mirrors.supportex.net/$pkgbase/$pkgbase-$_pkgver/kvm-tarbake-jaunty-x86/$pkgbase-$_pkgver.tar.gz
        mariadb.service
        mariadb-post.sh
        mariadb-tmpfile.conf)
sha256sums=('352fdc396742af642f81c8fd07edb96671e751402029ebc0f1d6aa9903707ee8'
            'a6cf5446159fff16598d0d787dd3a3c30a53a656a5f876ddb608bc60e234d334'
            '368f9fd2454d80eb32abb8f29f703d1cf9553353fb9e1ae4529c4b851cb8c5dd'
            '2af318c52ae0fe5428e8a9245d1b0fc3bc5ce153842d1563329ceb1edfa83ddd')

prepare() {
  cd $pkgbase-$_pkgver
}

build() {
  mkdir build
  cd build

  cmake ../$pkgbase-$_pkgver \
    -DCMAKE_BUILD_TYPE=Release \
    -DCMAKE_INSTALL_PREFIX=/usr \
    -DMYSQL_DATADIR=/var/lib/mysql \
    -DMYSQL_UNIX_ADDR=/run/mysqld/mysqld.sock \
    -DDEFAULT_CHARSET=utf8 \
    -DDEFAULT_COLLATION=utf8_general_ci \
    -DENABLED_LOCAL_INFILE=ON \
    -DINSTALL_INFODIR=share/mysql/docs \
    -DINSTALL_MANDIR=share/man \
    -DINSTALL_PLUGINDIR=lib/mysql/plugin \
    -DINSTALL_SCRIPTDIR=bin \
    -DINSTALL_INCLUDEDIR=include/mysql \
    -DINSTALL_DOCREADMEDIR=share/mysql \
    -DINSTALL_SUPPORTFILESDIR=share/mysql \
    -DINSTALL_MYSQLSHAREDIR=share/mysql \
    -DINSTALL_DOCDIR=share/mysql/docs \
    -DINSTALL_SHAREDIR=share/mysql \
    -DWITH_READLINE=ON \
    -DWITH_ZLIB=system \
    -DWITH_SSL=system \
    -DWITH_LIBWRAP=OFF \
    -DWITH_EXTRA_CHARSETS=complex \
    -DWITH_EMBEDDED_SERVER=ON \
    -DWITH_ARCHIVE_STORAGE_ENGINE=1 \
    -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
    -DWITH_INNOBASE_STORAGE_ENGINE=1 \
    -DWITH_PARTITION_STORAGE_ENGINE=1 \
    -DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \
    -DWITHOUT_FEDERATED_STORAGE_ENGINE=1 \
    -DWITHOUT_PBXT_STORAGE_ENGINE=1 \
    -DCMAKE_C_FLAGS="-fPIC ${CFLAGS} -fno-strict-aliasing -DBIG_JOINS=1 -fomit-frame-pointer" \
    -DCMAKE_CXX_FLAGS="-fPIC ${CXXFLAGS} -fno-strict-aliasing -DBIG_JOINS=1 -felide-constructors -fno-rtti" \
    -DWITH_MYSQLD_LDFLAGS="${LDFLAGS}"


  make
}

package_libmariadbclient() {
  pkgdesc='MariaDB client libraries'
  depends=('openssl')
  conflicts=('libmysqlclient')
  provides=("libmysqlclient=$pkgver")

  cd build
  for dir in include libmysql libmysqld libservices; do
    make -C $dir DESTDIR="$pkgdir" install
  done

  install -Dm755 scripts/mysql_config "$pkgdir"/usr/bin/mysql_config
  install -d "$pkgdir"/usr/share/man/man1
  for man in mysql_config mysql_client_test_embedded mysqltest_embedded; do
    install -m644 "$srcdir"/$pkgbase-$_pkgver/man/$man.1 "$pkgdir"/usr/share/man/man1/$man.1
  done
}

package_mariadb-clients() {
  pkgdesc='MariaDB client tools'
  depends=('libmariadbclient')
  conflicts=('mysql-clients')
  provides=("mysql-clients=$pkgver")

  cd build
  make -C client DESTDIR="$pkgdir" install

  # install man pages
  install -d "$pkgdir"/usr/share/man/man1
  for man in mysql mysqladmin mysqlcheck mysqldump mysqlimport mysqlshow mysqlslap; do
    install -m644 "$srcdir"/$pkgbase-$_pkgver/man/$man.1 "$pkgdir"/usr/share/man/man1/$man.1
  done

  # provided by mariadb
  rm "$pkgdir"/usr/bin/{mysql_{plugin,upgrade},mysqlbinlog,mysqltest}

}

package_mytop() {
  pkgdesc='Top clone for MariaDB'
  depends=('perl-dbd-mysql' 'perl-term-readkey')

  cd build
  install -Dm755 scripts/mytop "$pkgdir"/usr/bin/mytop
}

package_mariadb() {
  pkgdesc='Fast SQL database server, drop-in replacement for MySQL'
  backup=('etc/mysql/my.cnf')
  install=mariadb.install
  depends=('mariadb-clients' 'inetutils')
  conflicts=('mysql')
  provides=("mysql=$pkgver")
  options=('emptydirs')

  cd build
  make DESTDIR="$pkgdir" install

  install -Dm644 "$pkgdir"/usr/share/mysql/my-medium.cnf "$pkgdir"/etc/mysql/my.cnf
  install -Dm755 ../mariadb-post.sh "$pkgdir"/usr/bin/mysqld-post
  install -Dm644 ../mariadb.service "$pkgdir"/usr/lib/systemd/system/mysqld.service
  install -Dm644 ../mariadb-tmpfile.conf "$pkgdir"/usr/lib/tmpfiles.d/mysql.conf

  # provided by libmariadbclient
  cd "$pkgdir"
  rm usr/bin/{mysql_config,mysql_client_test_embedded,mysqltest_embedded}
  rm usr/lib/libmysql*
  rm -r usr/include/
  rm usr/share/man/man1/{mysql_config,mysql_client_test_embedded,mysqltest_embedded}.1

  # provided by mariadb-clients
  rm usr/bin/{mysql,mysqladmin,mysqlcheck,mysqldump,mysqlimport,mysqlshow,mysqlslap}
  rm usr/share/man/man1/{mysql,mysqladmin,mysqlcheck,mysqldump,mysqlimport,mysqlshow,mysqlslap}.1

  # provided by mytop
  rm usr/bin/mytop

  # not needed
  rm -r usr/{data,mysql-test,sql-bench}
  rm usr/share/man/man1/mysql-test-run.pl.1
}

Last edited by tripple (2013-11-04 01:50:06)

Arch Linux

#1 2013-11-01 14:45:25

MariaDB 5.6

#2 2013-11-01 15:00:41

Re: MariaDB 5.6

#3 2013-11-01 16:39:20

Re: MariaDB 5.6

#4 2013-11-01 17:49:48

Re: MariaDB 5.6

#5 2013-11-02 09:07:44

Re: MariaDB 5.6

#6 2013-11-02 09:11:18

Re: MariaDB 5.6

#7 2013-11-02 09:57:19

Re: MariaDB 5.6

#8 2013-11-02 10:21:10

Re: MariaDB 5.6

#9 2013-11-02 10:36:26

Re: MariaDB 5.6

#10 2013-11-02 11:15:44

Re: MariaDB 5.6

Board footer