MRatWork Forum by Mustafa Ramadhan - Problem MariaDB dan Innodb

Sponsor:
Server and Web Integrator
Link:
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:

MRatWork Forum | Please login or register. | 2017-11-07, 23:13:38

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- Problem MariaDB dan Innodb

« previous next »

- Print

Pages: [1] 2 Go Down

### Author Topic: Problem MariaDB dan Innodb (Read 3795 times)

0 Members and 1 Guest are viewing this topic.

#### redpages

- Senior Member
- Posts: 316
- Karma: +0/-0

##### Problem MariaDB dan Innodb

« on: 2015-07-04, 04:18:58 »
Dear masta,
Ceritanya saya baru reinstall VPS beserta kloxo MR nya. Versi 7.0. Setelah jalan ternyata DB nya pakai Maria DB, (vps untuk wp multisite dan sebelumnya pakai Mysql). Karena sebelumnya bertype MyISAM, maka saya tambahkan "skip-innodb" pada konfigurasi DB. Ternyata error.
Dari referensi yang saya dapatkan di sini, di MariaDB sudah mengadung innoDB di core. Jika benar demikian bagaimana cara mematikan fungsi innoDB pada MariaDB?.
Untuk DB yang sudah telanjur convert to MyISAM apakah akan bermasalah saat menggunakan MariaDB, karena sepertinya MariaDB lebih cocok untuk InnoDB.
Saya masih tertarik dengan MyISAM karena untuk backup dan restore cukup copy file di /var/lib/mysql/... . Jika pakai innodb harus menggunakan metode dumping/import dan itu selalu gagal ditengah jalan, entah karena prosesnya yang terlalu lama atau ada sintax yang tidak cocok dengan mysql terbaru.
Maaf tak bisa menampilkan hasil sysinfo, karena sangat lama sekali munculnya.
VPS : Centos 6.6, Nginx, PHP54, PHP-FPM.
Makasih atas pencerahannya.
Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: Problem MariaDB dan Innodb

« Reply #1 on: 2015-07-04, 05:11:46 »
Pastikan semua data dalam format myisam dengan 'sh /script/mysql-convert --engine=myisam'. Kadangkala perlu reboot setelah menjalankan mysql-convert pertama kali dan setelah reboot jalankan kembali mysql-convert.
Di MariaDB ada Aria (sebagai perbaikan dari MyISAM) dan juga sebagaimana MyISAM bisa backup/restore /var/lib/mysql juga.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### redpages

- Senior Member
- Posts: 316
- Karma: +0/-0

##### Re: Problem MariaDB dan Innodb

« Reply #2 on: 2015-07-05, 03:28:45 »
kalau memang saya pakai MariaDB berarti untuk konversi bisa langsung ke "MySQL Convert to aria" ?
Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: Problem MariaDB dan Innodb

« Reply #3 on: 2015-07-05, 04:54:28 »
Quote from: redpages on 2015-07-05, 03:28:45

> kalau memang saya pakai MariaDB berarti untuk konversi bisa langsung ke "MySQL Convert to aria" ?

YA, bisa dengan 'sh /script/mysql-convert --engine=aria'.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### redpages

- Senior Member
- Posts: 316
- Karma: +0/-0

##### Re: Problem MariaDB dan Innodb

« Reply #4 on: 2015-07-09, 03:09:39 »
saya sudah eksekusi perintah diatas. Di hasil akhir ada perintah dibawah:
Quote

> - Added 'default-storage-engine=aria' and 'skip-innodb' in '/etc/my.cnf.d/my.cnf'
> - Added 'default-storage-engine=aria' and 'skip-innodb' in '/etc/my.cnf.d/server.cnf'
> - Added 'default-storage-engine=aria' and 'skip-innodb' in '/etc/my.cnf'
> - Convert of MySQL to 'aria' engine finished
> - MySQL Service restarted

Untuk point pertama, saya tidak menemukan file my.cnf di dir /etc/my.cnf.d. Apakah bisa diabaikan?
Untuk point ke 2 dan 3 ternyata sudah terdapat code tersebut.
Dan untuk point ke 4 apakah harus mengkonversi lagi dengan perintah 'sh /script/mysql-convert --engine=aria' ?
Terima kasih bantuannya
Logged

#### zenkul

- Global Moderator
- Master
- Posts: 383
- Karma: +3/-0

##### Re: Problem MariaDB dan Innodb

« Reply #5 on: 2015-07-09, 05:41:34 »
- kalo kurang yakin, itu kan bisa dicek lewat phpmyadmin, pasti sudah terkonversi ke ARIA
- normal, punya saya struktur file-nya juga begitu. mungkin ada perubahan struktur & nama file
* itu detil nilai tidak dimunculkan, berarti dalam posisi default. kalo biasanya dulu kita oprek file my.cnf, berhubung sudah di-include-kan ke folder my.cnf.d maka sekarang yg bisa kita oprek adalah file server.cnf
?
Logged
easy, secure and speed up web panel ===> Kloxo-MR

#### redpages

- Senior Member
- Posts: 316
- Karma: +0/-0

##### Re: Problem MariaDB dan Innodb

« Reply #6 on: 2015-08-02, 06:52:24 »
Saya lakukan import .sql yang mana ada table innodb nya.
Quote

> CREATE TABLE IF NOT EXISTS `aktivitaskalender` (
> `replid` int(10) unsigned NOT NULL AUTO_INCREMENT,
> `idkalender` int(10) unsigned NOT NULL DEFAULT '0',
> `tanggalawal` date NOT NULL DEFAULT '0000-00-00',
> `tanggalakhir` date NOT NULL DEFAULT '0000-00-00',
> `kegiatan` varchar(50) NOT NULL,
> `keterangan` text,
> `info1` varchar(255) DEFAULT NULL,
> `info2` varchar(255) DEFAULT NULL,
> `info3` varchar(255) DEFAULT NULL,
> `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
> `token` smallint(5) unsigned NOT NULL DEFAULT '0',
> `issync` tinyint(1) unsigned NOT NULL DEFAULT '0',
> PRIMARY KEY (`replid`),
> KEY `FK_aktivitaskalender_kalenderakademik` (`idkalender`),
> KEY `IX_aktivitaskalender_ts` (`ts`,`issync`)
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

tapi kenapa pas cek di PMA hasilnya menjadi Myisam , terlampir
Sysinfo
Quote

> A. Kloxo-MR: 7.0.0.b-2015073001
> - Web: hiawatha-9.14.0-f.6.mr.el6.i386
> - PHP: php54s-5.4.43-1.ius.el6 (cgi mode)
> B. Plateform:
> - OS: CentOS release 6.6 (Final) i686
> - Hostname: server100.xbackbone.com
> C. Services:
> 1. MySQL: MariaDB-server-10.0.20-1.el6.i686
> 2. PHP:
> - Branch: php54-cli-5.4.43-1.ius.el6.i686
> - Used: --Use PHP Branch--
> 3. Httpd: httpd-2.2.31-1.mr.el6.i386
> - PHP Type: suphp
> 4. Lighttpd: --uninstalled--
> 5. Hiawatha: --unused--
> 6. Nginx: --uninstalled--
> 7. Cache: --uninstalled--
> 8. Dns: bind-9.9.7-1.mr.el6.i386
> 9. Qmail: qmail-toaster-1.03-1.3.55.mr.el6.i386
> - with: courier-imap-toaster-4.1.2-1.3.18.mr.el6.i386

Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: Problem MariaDB dan Innodb

« Reply #7 on: 2015-08-02, 07:57:15 »
Anda ingin pakai innodb atau myisam atau aria?.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### redpages

- Senior Member
- Posts: 316
- Karma: +0/-0

##### Re: Problem MariaDB dan Innodb

« Reply #8 on: 2015-08-02, 09:37:14 »
sesuai code sql tersebut: Innodb
Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: Problem MariaDB dan Innodb

« Reply #9 on: 2015-08-02, 10:47:22 »
Coba periksa di PhpMyAdmin, kemungkinan ada setting agar memaksa ke MyISAM.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### redpages

- Senior Member
- Posts: 316
- Karma: +0/-0

##### Re: Problem MariaDB dan Innodb

« Reply #10 on: 2015-08-02, 12:33:32 »
saya belum menemukan settingan yang memaksa tsb di settingan PMA.
apakah bisa pake cara convert to innodb pada menu kloxo mr?. Note: saya pakai MariaDB
Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: Problem MariaDB dan Innodb

« Reply #11 on: 2015-08-02, 12:48:47 »
Ya bisa pakai 'sh /script/mysql-convert'.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### redpages

- Senior Member
- Posts: 316
- Karma: +0/-0

##### Re: Problem MariaDB dan Innodb

« Reply #12 on: 2015-08-04, 06:18:20 »
Di salah satu VPS yang baru saya install kloxo mr 7, saya ganti ke Mysql menggunakan perintah:
"sh /script/mariadb-to-mysql".
Perintah berhasil dieksekusi, tapi mysql gagal start. Kondisinya kloxo mr baru terinstall. Mohon bantuannya.
Quote

> .....
> .....
> Complete!
> - Restart MySQL
> Stopping mysqld: [ OK ]
> MySQL Daemon failed to start.
> Starting mysqld: [FAILED]
> - Note: remove 'skip-innodb' from '/etc/my.cnf' and '/etc/my.cnf.d/my.cnf'.
> Need reboot!.
> *** Change MariaDB to MySQL - end ***
> [root@server100 ~]# service mysqld start
> MySQL Daemon failed to start.
> Starting mysqld: [FAILED]
> [root@server100 ~]# sh /script/sysinfo
> A. Kloxo-MR: 7.0.0.b-2015073001
> - Web: hiawatha-9.14.0-f.6.mr.el6.i386
> - PHP: php54s-5.4.43-1.ius.el6 (cgi mode)
> B. Plateform:
> - OS: CentOS release 6.6 (Final) i686
> - Hostname: server100.xbackbone.com
> C. Services:
> 1. MySQL: mysql55-5.5.44-2.ius.el6.i686
> 2. PHP:
> - Branch: php54-cli-5.4.43-1.ius.el6.i686
> - Used: --Use PHP Branch--
> 3. Httpd: httpd-2.2.31-1.mr.el6.i386
> - PHP Type: [unknown]
> 4. Lighttpd: --uninstalled--
> 5. Hiawatha: --unused--
> 6. Nginx: --uninstalled--
> 7. Cache: --uninstalled--
> 8. Dns: bind-9.9.7-1.mr.el6.i386
> 9. Qmail: qmail-toaster-1.03-1.3.55.mr.el6.i386
> - with: courier-imap-toaster-4.1.2-1.3.18.mr.el6.i386
> D. Memory:
> total used free shared buffers cached
> Mem: 1024 278 745 6 0 213
> -/+ buffers/cache: 64 959
> Swap: 0 0 0

Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: Problem MariaDB dan Innodb

« Reply #13 on: 2015-08-04, 06:37:13 »
Coba periksa di /etc/log/mysql.log
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### redpages

- Senior Member
- Posts: 316
- Karma: +0/-0

##### Re: Problem MariaDB dan Innodb

« Reply #14 on: 2015-08-04, 08:49:59 »
mungkin yang dimaksud "/var/log/mysqld.log"
isinya :
Quote

> 150804 00:14:11 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
> 150804 0:14:11 [Warning] option 'relay_log_space_limit': unsigned value 17179869184 adjusted to 4294967295
> 150804 0:14:11 [Note] /usr/libexec/mysqld (mysqld 5.5.44) starting as process 2025 ...
> 150804 0:14:11 [Note] Plugin 'FEDERATED' is disabled.
> 150804 0:14:11 InnoDB: The InnoDB memory heap is disabled
> 150804 0:14:11 InnoDB: Mutexes and rw_locks use GCC atomic builtins
> 150804 0:14:11 InnoDB: Compressed tables use zlib 1.2.3
> 150804 0:14:11 InnoDB: Using Linux native AIO
> 150804 0:14:11 InnoDB: Initializing buffer pool, size = 128.0M
> 150804 0:14:11 InnoDB: Completed initialization of buffer pool
> InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
> InnoDB: than specified in the .cnf file 0 5242880 bytes!
> 150804 0:14:11 [ERROR] Plugin 'InnoDB' init function returned error.
> 150804 0:14:11 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
> 150804 0:14:11 [ERROR] Failed to initialize plugins.
> 150804 0:14:11 [ERROR] Aborting
> 150804 0:14:11 [Note] /usr/libexec/mysqld: Shutdown complete
> 150804 00:14:11 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
> 150804 00:16:13 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
> 150804 0:16:13 [Warning] option 'relay_log_space_limit': unsigned value 17179869184 adjusted to 4294967295
> 150804 0:16:13 [Note] /usr/libexec/mysqld (mysqld 5.5.44) starting as process 2584 ...
> 150804 0:16:13 [Note] Plugin 'FEDERATED' is disabled.
> 150804 0:16:13 InnoDB: The InnoDB memory heap is disabled
> 150804 0:16:13 InnoDB: Mutexes and rw_locks use GCC atomic builtins
> 150804 0:16:13 InnoDB: Compressed tables use zlib 1.2.3
> 150804 0:16:13 InnoDB: Using Linux native AIO
> 150804 0:16:13 InnoDB: Initializing buffer pool, size = 128.0M
> 150804 0:16:13 InnoDB: Completed initialization of buffer pool
> InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
> InnoDB: than specified in the .cnf file 0 5242880 bytes!
> 150804 0:16:13 [ERROR] Plugin 'InnoDB' init function returned error.
> 150804 0:16:13 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
> 150804 0:16:13 [ERROR] Failed to initialize plugins.
> 150804 0:16:13 [ERROR] Aborting
> 150804 0:16:13 [Note] /usr/libexec/mysqld: Shutdown complete
> 150804 00:16:13 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

Logged

- Print

Pages: [1] 2 Go Up
« previous next »

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- Problem MariaDB dan Innodb

Top 10 Social Networking: Facebook Twitter LinkedIn Pinterest Google Plus Tumblr Instagram VK Flickr Vine

- Design By SMFSimple.com
- SMF 2.0.14 | SMF © 2017, Simple Machines

Page created in 0.048 seconds with 17 queries.

Mirror created by MasterkinG32.CoM