Master / Slaver 架構就是要讓 MySQL 資料庫系統有著備援的保障

基本運作方式就是，MySQL  Master 這台上只要有新增刪除修改，就會記錄在 binlog 檔裡，這時 Slaver 就可以透過 Master 授權的帳號去同步資料 ( Replication )，這是單向的。雙向的話可以靠 MySQL-MMM (但架構上主機要求的台數比較多)。

其它應用則可以使用 MySQL-proxy ，讓 Master 作寫入工作，而 Slaver 就只作讀取，提高效能

實作的環境 : 這次我拿 discuz 這個 opensource 的 論壇套件 作測試

Master                                  Slaver
--------------------------------------------------------
CentOS 6.5                              CentOS 6.4
PHP 5.4.27                              PHP 5.4.33
MySQL 5.5.37                            MySQL 5.5.40
Discuz X3.2                             Discuz X3.2
ip:10.10.10.137                         ip: 10.10.10.135

Master 端

在Ubuntu系统下安装sar出错，信息为：Please check if data collecting is enabled in /etc/default/sysstat

1、安装sysstat

apt-get install sysstat

If keyCode is not caught, catch which:

$('#formid').on('keyup keypress', function(e) {
  var keyCode = e.keyCode || e.which;
  if (keyCode === 13) { 
    e.preventDefault();
    return false;
  }
});

EDIT: missed it, it's better to use keyup instead of keypress

EDIT 2: As in some newer versions of Firefox the form submission is not prevented, it's safer to add the keypress event to the form as well. Also it doesn't work (anymore?) by just binding the event to the form "name" but only to the form id. Therefore I made this more obvious by changing the code example appropriately.

EDIT 3: Changed bind() to on()

全文取自 https://stackoverflow.com/questions/11235622/jquery-disable-form-submit-on-enter 

在Linux桌面需要輸入中文卻沒有中文輸入法的時候是很頭痛的事情

這邊分享如何安裝中文輸入法？

首先, 進入終端機模式輸入指令 就安裝完成！

sudo apt-get install ibus ibus-clutter ibus-gtk ibus-gtk3 ibus-qt4

im-config -s ibus

如何在 C# 像 C語言一樣使用 __LINE__ 取得所在行數?

It is uglier, but you can do something like this in C#using the StackTrace and StackFrame classes:

StackTrace st = new StackTrace(new StackFrame(true));
Console.WriteLine(" Stack trace for current level: {0}", st.ToString());
StackFrame sf = st.GetFrame(0);
Console.WriteLine(" File: {0}", sf.GetFileName());
Console.WriteLine(" Method: {0}", sf.GetMethod().Name);
Console.WriteLine(" Line Number: {0}", sf.GetFileLineNumber());
Console.WriteLine(" Column Number: {0}", sf.GetFileColumnNumber());

Of course, this comes with some overhead.

資料來源: https://stackoverflow.com/questions/696218/do-line-file-equivalents-exist-in-c

在 Laravel 使用 barryvdh/laravel-dompdf package 產生 PDF 時, 會有中文顯示的問題
之前花了不少時間, 總算是有一個比較好的解決方式! 
不過中文的問題解決了!還有因為轉出內容過大導致記憶體不足的問題, 而產生 crash 導致無法產出PDF檔案的問題, 則是另一個需要解決的難題了！
願善心人士可以分享解決方式, 謝謝! 

以下整理 barryvdh/laravel-dompdf package 之 PDF 中文的問題

1. 首先參考在你的 laravel proejct 安裝 laravel-dompdf package

2. 安裝之後, 進入 /vendor/barryvdh/laravel-dompdf/config 

修改 dompdf.php 檔案內容

將 "DOMPDF_DEFAULT_FONT" => "serif",

改成 "DOMPDF_DEFAULT_FONT" => "msyh",

不確定怎麼發生 Table 'performance_schema.session_variables' doesn't exist 的問題!

但因為造成無法匯入資料影響工作進度，所以爬文試圖解決!

找到 http://stackoverflow.com/questions/31967527/table-performance-schema-session-variables-doesnt-exist 這篇文章

經由強迫升級的方式, 將 mysql 本身的資料庫進行升級，就能解決問題!

為了確保不必要的困擾與萬一，建議在執行升級之前，就先把資料庫備份一份，以備不時之需．

由於需要寫自動將網址轉成 google 短網址, 所以需要用到 Google Short URL api, 正巧使用的是 Laravel, 所以就順勢搜尋有沒有現成的 package 可以使用, 沒想到居然真的有, 那就不要浪費！直接給他用下去！

Laravel Package for Google Short URL API -> https://github.com/mbarwick83/shorty

使用步驟:

1.  於專案目錄執行 composer require mbarwick83/shorty

2.  修改 config/app.php 在 providers 末端增加 Mbarwick83\Shorty\ShortyServiceProvider::class 後存檔

轉眼間已經破百開始到數了...人生第一次的破百倒數是當兵屆退伍的日子，在部隊退伍前三個月就升上兵，終於是走路有風、閒著無事到處晃的日子。

人生第二次的倒數就從今天開始，小皮球在99天就要出生，有著為人父的喜悅，說不緊張是騙人的。

期待一切平安健康、快樂長大。

To create a migration, you may use the migrate:make command on the Artisan CLI. Use a specific name to avoid clashing with existing models

for Laravel 3:

php artisan migrate:make add_paid_to_users

for Laravel 5+:

php artisan make:migration add_paid_to_users

You then need to use the Schema::table() method (as you're accessing an existing table, not creating a new one). And you can add a column like this:

public function up()
{
    Schema::table('users', function($table) {
        $table->integer('paid');
    });
}

and don't forget to add the rollback option:

Today I got again problem with PHP 7 running despite I have disabled php7.0 apache module: phpinfo was showing php 7 using fastCGI ...
... So if after you follow the below instructions you face this situation, you may need to disable the proxy_fcgi apache module:

sudo a2dismod proxy_fcgi proxy; sudo service apache2 restart

1. Re-Install PHP 5.6

What worked for me was this guide: http://www.lornajane.net/posts/2016/php-7-0-and-5-6-on-ubuntu

Actually is not required to remove php7.0, you can install php5.6 together ( also because you will have dependency problem with phpmyadmin package that required php7.0)

One of the changes introduced in Ubuntu Wily Werewolf is persistent stateless names. It means your network interfaces in ifconfig output will no longer follow the ethX pattern. This solves major problems with predictability of an interface name on Ubuntu if you have multiple cards. This applies to ethernet, WLAN and WWAN interfaces.

This originally started off due to Dell devices and SLES has defaulted to the nomenclature earlier. It’s nice to see Ubuntu adopting the same too. Both udev and systemd are involved in this change.

The udev naming convention follows different schemes:

1. Names incorporating Firmware/BIOS provided index numbers for on-board devices (example: eno1)
2. Names incorporating Firmware/BIOS provided PCI Express hotplug slot index numbers (example: ens1)
3. Names incorporating physical/geographical location of the connector of the hardware (example: enp2s0)
4. Names incorporating the interfaces’s MAC address (example: enx78e7d1ea46da)
5. Classic, unpredictable kernel-native ethX naming (example: eth0) – depreciated

systemd naming convention will use the same convention from above in the below order:

1. if that information from the firmware is applicable and available
2. if that information from the firmware is applicable and available
3. if applicable
4. in all other cases
5. is not used by default, but is available if the user chooses so

It’s unlikely this will bother you. However, if you want to fallback to the older nomenclature, you need to make some changes in udev: