MRatWork Forum by Mustafa Ramadhan

Language Specific Discussions => Indonesia Users => Topic started by: ar1246 on 2019-08-08, 05:36:40

Title: Upgrade MYSQL
Post by: ar1246 on 2019-08-08, 05:36:40

Mungkinkah melakukan upgrade MySQL  ke 5.7?

Title: Re: Upgrade MYSQL
Post by: MRatWork on 2019-08-08, 05:53:53

Kloxo-MR memilih menggunakan MariaDB daripada MySQL. Jika pakai MariaDB dimungkinkan untuk upgrade dari versi 10.0 ke 10.3 misalnya.

Title: Re: Upgrade MYSQL
Post by: ar1246 on 2019-08-09, 01:26:38

O iya saya lupa  ;D.
kmaren ada eror gini pas import db laravel

Code: [Select]

[PDOException]
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
kalo liat dari sini
https://laravel-news.com/laravel-5-4-key-too-long-error
intinya di karakter utf8mb4

berarti harus upgrade ke MariaDB 10.2 y pak?

Title: Re: Upgrade MYSQL
Post by: MRatWork on 2019-08-09, 02:02:35

Itu karena encoding untuk utf8 memang memerlukan yang lebih banyak ( baca => https://stackoverflow.com/questions/19212306/whats-the-difference-between-ascii-and-unicode )