Magento2: MySQL server has gone away during installation

I have problem durring installation magento2 in my macbook. I think same way if you using Linux.

Problem in MySQL

MySQL server has gone away

Solution

After search in google i found the solution:

create or edit file /etc/my.cnf

After edit or create my.cnf than restart your mysql server

$ mysql.server restart

I hope these helps ­čÖé

Other resource:

  • http://devdocs.magento.com/guides/v2.1/install-gde/trouble/tshoot_mysql_table-open-cache.html
  • http://stackoverflow.com/questions/17813630/mysql-5-6-headaches-on-mac-osx/22773887#22773887
  • https://github.com/magento/magento2/issues/2805
  • http://bugs.mysql.com/bug.php?id=79125

Error importing SQL dump into MySQL – Mac User

Saya mau import dump database via terminal dengan size 1,6GB, tapi beberapa kali gagal

script import

$ mysql -h 127.0.0.1 -u root my_database < backup_db.sql

Tapi menemukan error seperti ini:

“ERROR 1118 (42000) at line 5543: Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.”

setelah googling solusinya adalah harus menambah size innodb_buffer_pool_size dan innodb_log_file_size

Caranya edit file my.cnf dan ubah seperti dibawah ini.

innodb_buffer_pool_size = 32M

innodb_log_file_size = 256M

save perubahannya dan restart mysql lalu jalankan kembali script import diatas.

done.

Implementasi CouchDB dan Memcached di PHP

Asumsi saya pembaca tau bedanya RDBMS dan NoSQL, dan familiar dengan system caching, khususnya memcached. Jika memang belum tau perbedaannya bisa pelajari dasar-dasar NoSQL disini http://nosql-database.org dan untuk memcached bisa baca-baca disini https://en.wikipedia.org/wiki/Memcached

Untuk bisa implementasikan 3 tech CouchDB, Memcached & PHP, tentu harus mempersiapkan instalasinya kan? Benar sekali :). Harus download CouchDB, install memcached extension dan web server. Pengguna mac dan nginx dapat install via homebrew bisa ikuti caranya disini http://blog.frd.mn/install-nginx-php-fpm-mysql-and-phpmyadmin-on-os-x-mavericks-using-homebrew lengkap dan mudah dipahami. Continue reading