2017 m. vasario 10 d., penktadienis

javascript find visual center of polygon

https://github.com/mapbox/polylabel

http://stackoverflow.com/questions/22796520/finding-the-center-of-leaflet-polygon

http://stackoverflow.com/questions/16282330/find-centerpoint-of-polygon-in-javascript

Bootstrap free themes

https://bootswatch.com/


http://blacktie.co/2014/07/dashgum-free-dashboard/#more-362

ckeditor bootstrap plugin

https://github.com/kaido24/btgrid

mysql config tuning

https://github.com/major/MySQLTuner-perl

http://www.mysqlcalculator.com/

http://www.tecmint.com/mysql-mariadb-performance-tuning-and-optimization/3/

http://stackoverflow.com/questions/13259275/mysql-tmp-table-size-max-heap-table-size

mysql replication

MHA tool - managing master/slave
https://code.google.com/p/mysql-master-ha/
https://mysqlstepbystep.com/2015/06/01/mysql-high-available-with-mha-2/

master/slave tipologija
https://severalnines.com/resources/tutorials/mysql-replication-high-availability-tutorial

tutorials
http://www.servermom.org/master-slave-mysql-replication-tutorial/
https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in-mysql
http://dba.stackexchange.com/questions/8680/what-is-the-best-way-to-create-mysql-master-slave-replication-setup-and-troubles
http://www.tecmint.com/how-to-setup-mysql-master-slave-replication-in-rhel-centos-fedora/
http://www.techrepublic.com/blog/tr-dojo/set-up-mysql-database-replication-to-ensure-up-to-date-backups/

On master, lock the database read-only, flush everything.
On slave, stop the mysqld daemon (very important!!!)
rsync the data store directory from the master to the slave
start the slave
unlock the master.

load balancing and high availability

tool http://www.linuxvirtualserver.org/

rsync over ssh with public key (no pass)

https://www.digitalocean.com/community/tutorials/how-to-copy-files-with-rsync-over-ssh