카카오 i 오픈빌더 (Kakao i Open Builder)를 이용한 플러스 친구 챗봇 (PHP + MySQL) 백엔드 프로젝트 이 프로젝트는 샘플 테스트용으로 카카오톡 플러스 친구 챗봇을 구현하기 위해 만들어졌습니다. 이 프로젝트는 아주 기본 기능만을 구현하였습니다. Production 환경에서는 사용하기에 부족함이 많으니 참고용으로만 사용하시기 바랍니다. 테스트 커뮤니티 챗봇: http://pf.kakao.com/_vAKtj Backend API: https://kakao.chrislee.kr Backend 소스코드: https://github.com/chrisleekr/kakao-plusfriend-bot-backend 개발 환경 PHP 7.2…
Category: MySQL
Vagrant MySQL Master-Slave Replication
Vagrant MySQL Master-Slave Replication Source Repo: https://github.com/chrisleekr/vagrant-mysql-master-slave-replication Vagrantfile to spin up MySQL Master-Slave replication with persistent data storage Note: This project is created for just practice. Not suitable for production use. Prerequisites Vagrant 1.8.1+: http://www.vagrantup.com/ VirtualBox: https://www.virtualbox.org/ Usage $ git clone https://github.com/chrisleekr/vagrant-mysql-master-slave-replication.git $ cd vagrant-mysql-master-slave-replication $ vagrant up After vagrant machines are running, you can connect…
Sample XAMPP MySql my.ini Fast Performance
Only use in local test MySQL. # Example MySQL config file for large systems. # # This is for a large system with memory = 512M where the system runs mainly # MySQL. # # MySQL programs look for option files in a set of # locations which depend on the deployment platform. # You…
EnvironmentError: mysql_config not found
I am using Mac OS X 10.9, MAMP 1.9 (MySQL 5.1.44), Python 2.7.5. Got this error when I change database configuration in settings.py. I felt this issue can make me painful, so I start logging what happened and how I fixed. Do not follow below steps. Just go straightly bottom of article and read last…
VPS – Apache & MySQL Performance Tuning
Apache 1. Open/Create /var/www/vhosts/{hostname}/conf/vhosts.conf 2. Add oradjust below code KeepAlive On MaxKeepAliveRequests 29 KeepAliveTimeout 15 3. Copy to make backup of apache configuration # cp -p /etc/httpd/conf/httpd.conf /etc/httpd/conf/httpd.conf.YYYY-MM-DD.bak 4. Execute below shell script one by one # ramCount=`awk ‘match($0,/vmguar/) {print $4}’ /proc/user_beancounters` # ramBase=-16 && for ((;ramCount>1;ramBase++)); do ramCount=$((ramCount/2)); done # perl -0 -p -i…
A script to change all tables and fields to the utf-8-bin collation in MYSQL
A script to change all tables and fields to the utf-8-bin collation in MYSQL (This article is from http://stackoverflow.com/questions/105572/a-script-to-change-all-tables-and-fields-to-the-utf-8-bin-collation-in-mysql) <?php set_time_limit(0); function MysqlError() { if (mysql_errno()) { echo “<b>Mysql Error: ” . mysql_error() . “</b>\n”; } } $username = “root”; $password = “”; $db = “database”; $host = “localhost”; $target_charset = “utf8”; $target_collate =…