michaelfox + mysql   169

xaprb/xaprb-src
At my previous employer, one of the early decisions that had huge payoffs later was the SQL naming conventions. A good naming convention is more than just a nicety. It lets you write programs that don't need to be told about the relationships among tables and columns.


refrr:https://github.com/xaprb/xaprb-src/blob/master/content/blog/2010/why-high-availability-is-hard-with-databases.md
At my previous employer, one of the early decisions that had huge payoffs later was the SQL naming conventions. A good naming convention is more than just a nicety. It lets you write programs that don't need to be told about the relationships among tables and columns.


refrr:https://github.com/xaprb/xaprb-src/blob/master/content/blog/2010/why-high-availability-is-hard-with-databases.md
naming  bestpractices  mysql  conventions  standard  styleguide 
23 days ago by michaelfox
Essential Books
This page lists the most valuable books on my bookshelf. These books contain knowledge that is worth far more than the price.


refrr:https://www.xaprb.com/search/
This page lists the most valuable books on my bookshelf. These books contain knowledge that is worth far more than the price.


refrr:https://www.xaprb.com/search/
book  database  mysql  performance  optimization  books  reading  list  curated  collection 
23 days ago by michaelfox
My Personal SQL Coding Standards
how to group data correctly in SQL

Coding standards are a Good Thing. Unfortunately, most organizations don’t have much in the way of SQL coding standards, and there aren’t many automated tools to help. As a result, I believe SQL is often less consistently written than many other languages. Here are my suggestions.


refrr:https://www.google.com/
how to group data correctly in SQL

Coding standards are a Good Thing. Unfortunately, most organizations don’t have much in the way of SQL coding standards, and there aren’t many automated tools to help. As a result, I believe SQL is often less consistently written than many other languages. Here are my suggestions.


refrr:https://www.google.com/
sql  mysql  database  bestpractices  styleguide 
23 days ago by michaelfox
SQL Pivot: Converting Rows to Columns
In the upcoming Apache Spark 2.4, the community is extending this powerful functionality of pivoting data to SQL users. In this blog, using temperatures recordings in Seattle, we’ll show how we can use this common SQL Pivot feature to achieve complex data transformations.
In the upcoming Apache Spark 2.4, the community is extending this powerful functionality of pivoting data to SQL users. In this blog, using temperatures recordings in Seattle, we’ll show how we can use this common SQL Pivot feature to achieve complex data transformations.
mysql  sql  data  database  query 
5 weeks ago by michaelfox
Build a Data Mining Automation Bot Using Node.js & Your Browser
The ingredients: Linux server running Node.js + Express (might work on Windows?) Node modules: mysql, body-parser MySQL installed Chrome with Tampermonkey (alternatively Firefox and Greasemonkey) You might wonder, why MySQL? I just happened to be more used to it at the time I coded this bot. If I were to do this again, I would …


refrr:https://franciskim.co/blog/page/9/
The ingredients: Linux server running Node.js + Express (might work on Windows?) Node modules: mysql, body-parser MySQL installed Chrome with Tampermonkey (alternatively Firefox and Greasemonkey) You might wonder, why MySQL? I just happened to be more used to it at the time I coded this bot. If I were to do this again, I would …


refrr:https://franciskim.co/blog/page/9/
chrome  javascript  js  mysql  node  scraper 
6 weeks ago by michaelfox
Adrian0350/SimplePDOWrapper
SimplePDOWrapper's purpose is to help you handle simple database actions with a reduced amount of code as well as writting less-messy code following a simple structure.


refrr:https://github.com/search?l=PHP&q=sql+beautifier&type=Repositories
SimplePDOWrapper's purpose is to help you handle simple database actions with a reduced amount of code as well as writting less-messy code following a simple structure.


refrr:https://github.com/search?l=PHP&q=sql+beautifier&type=Repositories
mysql  php  database  sql  parser  string  format  convert 
9 weeks ago by michaelfox
IncrementaCRM/SimplePDOWrapper
SimplePDOWrapper's purpose is to help you handle simple database actions with a reduced amount of code as well as writting less-messy code following a simple structure.


refrr:https://github.com/search?l=PHP&q=sql+beautify&type=Repositories
SimplePDOWrapper's purpose is to help you handle simple database actions with a reduced amount of code as well as writting less-messy code following a simple structure.


refrr:https://github.com/search?l=PHP&q=sql+beautify&type=Repositories
mysql  php  database  sql  parser  string  format  convert 
9 weeks ago by michaelfox
webdevops/php-docker-boilerplate
🍲 PHP Docker Boilerplate for Symfony, Wordpress, Joomla or any other PHP Project (NGINX, Apache HTTPd, PHP-FPM, MySQL, Solr, Elasticsearch, Redis, FTP) https://webdevops.io/projects/php-doc…


refrr:https://github.com/search?o=desc&q=docker+ftp&s=stars&type=Repositories
🍲 PHP Docker Boilerplate for Symfony, Wordpress, Joomla or any other PHP Project (NGINX, Apache HTTPd, PHP-FPM, MySQL, Solr, Elasticsearch, Redis, FTP) https://webdevops.io/projects/php-doc…


refrr:https://github.com/search?o=desc&q=docker+ftp&s=stars&type=Repositories
apache  boilerplate  mysql  php  docker  devops  sysadmin  environment  setup 
august 2018 by michaelfox
paragonie/easydb
Easy-to-use PDO wrapper for PHP projects. paragonie.com/projects


refrr:https://php.libhunt.com/
Easy-to-use PDO wrapper for PHP projects. paragonie.com/projects


refrr:https://php.libhunt.com/
php  pdo  database  mysql  library 
august 2018 by michaelfox
DB Fiddle - SQL Database Playground
An online SQL database playground for testing, debugging and sharing SQL snippets.
An online SQL database playground for testing, debugging and sharing SQL snippets.
database  query  mysql  db  fiddle  sandbox  prototype  demo  testing  tools 
july 2018 by michaelfox
How to support full Unicode in MySQL databases
Published 30th July 2012 · tagged with MySQL, security, Unicode
Published 30th July 2012 · tagged with MySQL, security, Unicode
mysql  bestpractices  styleguide  database  utf8  emoji  data  convert  unicode  reference   
june 2018 by michaelfox
swisnl/laravel-fulltext
Fulltext indexing and searching for Laravel This package creates a MySQL fulltext index for models and enables you to search through those.
Fulltext indexing and searching for Laravel This package creates a MySQL fulltext index for models and enables you to search through those.
laravel  php  mysql  search  database 
may 2018 by michaelfox
MarkLeith/dbahelper
A collection of scripts to help MySQL DBAs A collection of scripts to help MySQL DBAs


refrr:http://www.markleith.co.uk/ps_helper/
A collection of scripts to help MySQL DBAs A collection of scripts to help MySQL DBAs


refrr:http://www.markleith.co.uk/ps_helper/
mysql  database  performance  monitoring  devops  tools  snippets  utilities  maintenance  db  query  resource  collection    inspiration  framework  opensource  library 
march 2018 by michaelfox
MySQL Partitions timestamp - datetime
Another MySQL DBA's Blog addressing the concerns and solutions with using MySQL.


refrr:https://www.google.com/
Another MySQL DBA's Blog addressing the concerns and solutions with using MySQL.


refrr:https://www.google.com/
mysql  database  partition  rotate  logging  performance  procedure 
march 2018 by michaelfox
History Tables
A history table allows you to use one table to track changes in another table. While the basic idea is simple, a naive implementation...


refrr:https://www.google.com/
A history table allows you to use one table to track changes in another table. While the basic idea is simple, a naive implementation...


refrr:https://www.google.com/
designpatterns  data  database  schema  history  logging  mysql  bestpractices 
march 2018 by michaelfox
MySQL Client by SQLPro on the App Store
Read reviews, compare customer ratings, see screenshots, and learn more about MySQL Client by SQLPro. Download MySQL Client by SQLPro and enjoy it on your iPhone, iPad, and iPod touch.
refrr:https://itunes.apple.com/us/app/httper/id1166884043?mt=8
Read reviews, compare customer ratings, see screenshots, and learn more about MySQL Client by SQLPro. Download MySQL Client by SQLPro and enjoy it on your iPhone, iPad, and iPod touch.
refrr:https://itunes.apple.com/us/app/httper/id1166884043?mt=8
mysql  ios  app 
march 2018 by michaelfox
New JSON-column where() and update() syntax in Laravel 5.3
While Laravel has had the ability to cast your data to and from JSON since version 5.0, it was previously just a convenience—your data


refrr:https://www.google.com/
laravel  php  mysql  json  database  eloquent  data  sql  reference 
february 2018 by michaelfox
Use MySQL JSON field in Laravel
fields

I have been working on an application which needs to store a lot of metadata about user profile, we discussed with the team about using NoSQL database (MongoDB) since its a JSON data set which can be extended and customized for the specific user profile due to its schemaless structure. As we know from MySQL 5.7.8 JSON …


refrr:https://www.google.com/
laravel  php  mysql  json  database  eloquent  data  sql  reference 
february 2018 by michaelfox
MySQL Network Security
See how to setup MySQL to allow secure remote connections from your application servers.


refrr:https://t.co/284SQshZm5
mysql  security  bestpractices  aws  rds  database  setup  reference  network 
january 2018 by michaelfox
Amazon RDS
I've gotten a few questions about how MySQL replication works within RDS. Amazon has a few concepts going on which makes the picture of how everything fits together a little hazy. Here's my attempt at clearing up how the RDS service works!


refrr:https://serversforhackers.com/c/amazon-rds
aws  rds  database  setup  reference  mysql 
january 2018 by michaelfox
MySQL, UTF8 and Indexing
See some pitfalls of using MySQL with UTF-8 when indexing your database.


refrr:https://serversforhackers.com/t/databases
mysql  bestpractices  charactersets  utf8  setup  database  reference 
january 2018 by michaelfox
Getting started with Laravel on Docker
In this tutorial, I will show you how you can set up a new Laravel project using Docker. With Docker, you can set up a virtual environment without dependencies from your system, this way your project…

#docker #laravel-5 #mysql #web-development #php
In this tutorial, I will show you how you can set up a new Laravel project using Docker. With Docker, you can set up a virtual environment without dependencies from your system, this way your project…

#docker #laravel-5 #mysql #web-development #php
laravel  php  mysql  docker  devops 
january 2018 by michaelfox
How to store hours in a database
<?php

function intToHour($int)
{
$minutes = $int % 60;
$hours = $int / 60;
return sprintf(“%02d”, floor($hours)) . “:” . sprintf(“%02d”, $minutes);
}
function hourToInt($hour)
{
$array = explode(‘:’, $hour);
return ($array[0] * 60) + $array[1];
}
So now you can do:
echo hourToInt("13:37"); // 817
And the opposite:
echo intToHour("817"); // 13:37

The easiest way I found to store hours (24-time format) in a database is to convert them in integers. “How to store hours in a database” is published by tompec

#php #database #development #laravel


refrr:https://medium.com/tag/php/latest
<?php

function intToHour($int)
{
$minutes = $int % 60;
$hours = $int / 60;
return sprintf(“%02d”, floor($hours)) . “:” . sprintf(“%02d”, $minutes);
}
function hourToInt($hour)
{
$array = explode(‘:’, $hour);
return ($array[0] * 60) + $array[1];
}
So now you can do:
echo hourToInt("13:37"); // 817
And the opposite:
echo intToHour("817"); // 13:37

The easiest way I found to store hours (24-time format) in a database is to convert them in integers. “How to store hours in a database” is published by tompec

#php #database #development #laravel


refrr:https://medium.com/tag/php/latest
laravel  php  time  date  data  mysql  db  database  convert 
december 2017 by michaelfox
shlomi-noach/common_schema
A thorough guide to routines, views, the QueryScript language

DBA's framework for MySQL


refrr:https://shlomi-noach.github.io/awesome-mysql/
A thorough guide to routines, views, the QueryScript language

DBA's framework for MySQL


refrr:https://shlomi-noach.github.io/awesome-mysql/
mysql  snippets  utilities  maintenance  devops  db  database  query  tools  resource  collection   
november 2017 by michaelfox
Awesome MySQL
A curated list of awesome MySQL software, libraries and resources.


refrr:https://www.google.com/
mysql  awesome  database  collection   
november 2017 by michaelfox
Designing one to many relations – MongoDB vs MySQL
Stephane Combaudon reveals several topics that you will have to keep in mind when designing one to many relations in MongoDB. He also compares it to MySQL.


refrr:https://www.percona.com/blog/2013/08/01/schema-design-in-mongodb-vs-schema-design-in-mysql/
Stephane Combaudon reveals several topics that you will have to keep in mind when designing one to many relations in MongoDB. He also compares it to MySQL.


refrr:https://www.percona.com/blog/2013/08/01/schema-design-in-mongodb-vs-schema-design-in-mysql/
mysql  database  schema  bestpractices  nosql  mongodb 
november 2017 by michaelfox
Schema Design in MongoDB vs Schema Design in MySQL
Percona Consultant Stephane Combaudon elaborates on the key differences between a MySQL database schema design and a MongoDB schema design.


refrr:https://www.percona.com/search?s=mongo+schema
Percona Consultant Stephane Combaudon elaborates on the key differences between a MySQL database schema design and a MongoDB schema design.


refrr:https://www.percona.com/search?s=mongo+schema
mysql  database  schema  bestpractices  nosql  mongodb 
november 2017 by michaelfox
SQL Indexing and Tuning e-Book
SQL indexing and tuning tutorial for developers. No unnecessary database details—just what developers need to know. Covers all major SQL databases.


refrr:https://use-the-index-luke.com/3-minute-test/mysql
SQL indexing and tuning tutorial for developers. No unnecessary database details—just what developers need to know. Covers all major SQL databases.


refrr:https://use-the-index-luke.com/3-minute-test/mysql
book  performance  database  learning  sql  reference  site  resource  optimization  devops  mysql  monitoring 
november 2017 by michaelfox
Eloquent Relationships Cheat Sheet
The Man (buyer) can buy many Cars. The Woman (buyer) can buy many Cars. The Car can be bought by one buyer (Man or Woman). The Car table should store the Buyer ID and the Buyer Type. “buyer” is a…

#laravel #eloquent #laravel-eloquent #database #orm


refrr:https://medium.com/tag/laravel
The Man (buyer) can buy many Cars. The Woman (buyer) can buy many Cars. The Car can be bought by one buyer (Man or Woman). The Car table should store the Buyer ID and the Buyer Type. “buyer” is a…

#laravel #eloquent #laravel-eloquent #database #orm


refrr:https://hackernoon.com/eloquent-relationships-cheat-sheet-5155498c209
Unread  laravel  db  eloquent  mysql  cheatsheet  reference    php  database  from pocket
october 2017 by michaelfox
5.5.9 mysqlslap — Load Emulation Client
mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each stage. It works as if multiple clients are accessing the server.
mysql  audit  load  loadtesting  performance  optimization  devops  tools  cli  mysqlslap  from pocket
september 2017 by michaelfox
jarulraj/sqlcheck
SQLCheck automates the detection of common anti-patterns in SQL queries. Such anti-patterns often increase the time taken to run the queries on a database management system. Addressing these anti-patterns will, therefore, help improve the runtime performance of the queries. This tool targets all SQL dialects.
mysql  designpatterns  bestpractices  styleguide  validation  lint  debug  sql  db  checker   
august 2017 by michaelfox
Building Searchable Encrypted Databases with PHP and SQL
How to implement field-level data encryption while still allowing fast queries.
How to implement field-level data encryption while still allowing fast queries.
php  database  mysql  encryption  data  security  bestpractices  devops 
august 2017 by michaelfox
ProxySQL
: high-performance, GPL licensed MySQL proxy. It supports hundreds of thousands of concurrent connections and can be multiplexed to hundreds of servers.


refrr:http://mysqlserverteam.com/mysql-8-0-retiring-support-for-the-query-cache/
mysql  database  monitoring  performance  optimization  debug  proxy  tools  devops 
august 2017 by michaelfox
Database Administrators
Currently our application is running using Oracle 11g database. We are developing newer version of the application which runs on MySQL cluster. We need to migrate the data from Oracle database to M...


refrr:https://www.google.com/
oracle  mysql  convert  database  migration 
august 2017 by michaelfox
Software Quality is Quality of Life
There was an interesting index related performance problem on Stack Overflow recently. The problem was to check an input string against a table that holds about 2000 prefix patterns (e.g., LIKE 'xy...
There was an interesting index related performance problem on Stack Overflow recently. The problem was to check an input string against a table that holds about 2000 prefix patterns (e.g., LIKE 'xy...
mysql  database  optimization  sql  performance 
july 2017 by michaelfox
Data warehousing in MySQL
Some databases are used to store large amount of historical data (such as call detail records, log messages, etc). This data has the following common characteristics:


refrr:http://www.remsys.com/blog
Some databases are used to store large amount of historical data (such as call detail records, log messages, etc). This data has the following common characteristics:


refrr:http://www.remsys.com/blog
mysql  devops 
july 2017 by michaelfox
No-downtime MySQL backup (InnoDB/InnoBackupEx)
The high prevalence of MySQL databases leads to their usage in increasingly diverse projects, including those that require nonstop operation and minimal recovery time. Standard tools, such as mysqldump are inconvenient for the use in large databases that can reach tens of gigabytes. If you can still export the data in the reasonable time of a few hours, the restore operation can take tens of hours. Also, using mysqldump to backup causes table locks (making downtime during backup) and can be followed by data inconsistency in backup copy.


refrr:http://www.remsys.com/blog
The high prevalence of MySQL databases leads to their usage in increasingly diverse projects, including those that require nonstop operation and minimal recovery time. Standard tools, such as mysqldump are inconvenient for the use in large databases that can reach tens of gigabytes. If you can still export the data in the reasonable time of a few hours, the restore operation can take tens of hours. Also, using mysqldump to backup causes table locks (making downtime during backup) and can be followed by data inconsistency in backup copy.


refrr:http://www.remsys.com/blog
backup  mysql 
july 2017 by michaelfox
git/tt-rss
tt-rss - Tiny Tiny RSS
tt-rss - Tiny Tiny RSS
mysql  rss  bookmarks  schema  inspiration  feed 
july 2017 by michaelfox
mycli: Awesome MySQL/MariaDB mysql client with auto-completion and syntax highlighting – nixCraft
MyCLI is an awesome CLI tool for MySQL, MariaDB, and Percona with auto-completion, history, syntax highlighting and much more.
shell  mysql  tools 
may 2017 by michaelfox
How To Optimize WordPress Performance With MySQL Replication On Ubuntu 14.04
In this tutorial, we will teach you how to scale up your WordPress MySQL database server setup using master-slave database replication and the HyperDB plugin for WordPress. Adding more database servers to your environment in this manner allows your Wo

#wordpress #mysql #scaling #ubuntu


refrr:https://www.digitalocean.com/community/tags/scaling?type=tutorials
In this tutorial, we will teach you how to scale up your WordPress MySQL database server setup using master-slave database replication and the HyperDB plugin for WordPress. Adding more database servers to your environment in this manner allows your Wo

#wordpress #mysql #scaling #ubuntu


refrr:https://www.digitalocean.com/community/tags/scaling?type=tutorials
mysql  wordpress  php  optimization  performance  bestpractices  devops 
april 2017 by michaelfox
How To Install and Configure Zabbix to Securely Monitor Remote Servers on CentOS 7
Zabbix is open source monitoring software you can use to ensure the servers in your infrastructure are working properly so you can fix problems before they affect your users.

#monitoring #networking #high-availability #system-tools #php #apache #centos


refrr:https://www.digitalocean.com/community/tags/php?type=tutorials
Zabbix is open source monitoring software you can use to ensure the servers in your infrastructure are working properly so you can fix problems before they affect your users.

#monitoring #networking #high-availability #system-tools #php #apache #centos


refrr:https://www.digitalocean.com/community/tags/php?type=tutorials
apache  php  devops  monitoring  zabbix  mysql 
april 2017 by michaelfox
How To Prepare For Your MySQL 5.7 Upgrade
This tutorial will help you prepare to upgrade to MySQL 5.7 from earlier versions. It covers `sql_mode` with practical examples of query responses that get stricter. The tutorial also contains instructions for checking for warnings and errors, and con

#mysql #scaling #arch #centos #coreos #debian #freebsd #rhel #ubuntu


refrr:https://www.digitalocean.com/community/tags/scaling?type=tutorials
This tutorial will help you prepare to upgrade to MySQL 5.7 from earlier versions. It covers `sql_mode` with practical examples of query responses that get stricter. The tutorial also contains instructions for checking for warnings and errors, and con

#mysql #scaling #arch #centos #coreos #debian #freebsd #rhel #ubuntu


refrr:https://www.digitalocean.com/community/tags/scaling?type=tutorials
mysql  devops  server 
april 2017 by michaelfox
How To Configure MySQL Group Replication on Ubuntu 16.04
MySQL replication reliably mirrors the data and operations from one database to another. Conventional replication involves a primary server configured to accept database write operations. Secondary servers copy and apply actions from the primary's log

#scaling #clustering #mysql #ubuntu #ubuntu-16-04


refrr:https://www.digitalocean.com/community/tags/scaling?type=tutorials
MySQL replication reliably mirrors the data and operations from one database to another. Conventional replication involves a primary server configured to accept database write operations. Secondary servers copy and apply actions from the primary's log

#scaling #clustering #mysql #ubuntu #ubuntu-16-04


refrr:https://www.digitalocean.com/community/tags/scaling?type=tutorials
mysql  scaling  devops  database  server 
april 2017 by michaelfox
How To Measure MySQL Query Performance with mysqlslap
mysqlslap is a diagnostic tool that can help you measure the performance of MySQL queries. This tutorial shows you how to perform tests of varying complexity, including a test that's practical for production environments with unknown queries.

#mysql #server-optimization #centos
mysql  performance  optimization  testing  load  server  devops  database  query  troubleshooting  automation  tools   
april 2017 by michaelfox
MySQL, UTF8 and Indexing
What programmers need to know about servers.

#database #mysql


refrr:https://t.co/sA7kIAiNqc
mysql  utf8  characters  reference 
march 2017 by michaelfox
The Unofficial MySQL 8.0 Optimizer Guide
Morgan Tocker is the Product Manager for the MySQL Server at Oracle. He has previously worked in a variety of roles including Support, Training and Community. Morgan is based out of Toronto, Canada. refrr:http://www.unofficialmysqlguide.com/?utm_source=dbweekly&utm_medium=email Morgan Tocker is the Product Manager for the MySQL Server at Oracle. He has previously worked in a variety of roles including Support, Training and Community. Morgan is based out of Toronto, Canada. refrr:http://www.unofficialmysqlguide.com/?utm_source=dbweekly&utm_medium=email
reference  devops  performance  documentation  database  mysql  book    optimization 
february 2017 by michaelfox
Wordpress JOIN wp_post and wp_postmeta
I am trying to search through wp_post &amp; wp_postmeta simultaneously using this query: $querystr = " SELECT $wpdb-&gt;posts.* FROM $wpdb-&gt;posts, $wpdb-&gt;postmeta WHERE $wpdb-&gt;
I am trying to search through wp_post &amp; wp_postmeta simultaneously using this query: $querystr = " SELECT $wpdb-&gt;posts.* FROM $wpdb-&gt;posts, $wpdb-&gt;postmeta WHERE $wpdb-&gt;
wordpress  php  mysql  sql  meta  metadata 
february 2017 by michaelfox
Most efficient way to get posts with postmeta
I need to get a bunch of posts with their metadata. Of course you can't get metadata with a standard posts query, so you generally have to do a get_post_custom() for each post. I'm trying with one
I need to get a bunch of posts with their metadata. Of course you can't get metadata with a standard posts query, so you generally have to do a get_post_custom() for each post. I'm trying with one
wordpress  php  mysql  sql  meta  metadata 
february 2017 by michaelfox
5 Things You Overlooked with MySQL Dumps
MySQL Subquery Optimization
MySQL Subquery Optimization
mysql  database  backup  bestpractices  styleguide  devops 
february 2017 by michaelfox
Beaver-mysql-logger
This is a log viewer for MySQL queries. It turns on query logging in MySQL and display it in nice Web interface with formatting and syntax highlighting.
This is a log viewer for MySQL queries. It turns on query logging in MySQL and display it in nice Web interface with formatting and syntax highlighting.
mysql  logging  debug  performance  optimization  tools  devtools  query  sql 
february 2017 by michaelfox
Working with JSON in MySQL
SQL databases tend to be rigid. If you have worked with them, you would agree that database design though it seems easier, is a...

#laravel #php


refrr:https://scotch.io/tutorials/drink-number/2
laravel  mysql  php  json  database  nosql    from pocket
january 2017 by michaelfox
Automated MySQL backups for Homestead
I guess we all ran into this problem once in a while: our Vagrant / Homestead machine freezes, gets destroyed and all data is lost. Of cours


refrr:http://us11.campaign-archive2.com/?u=a459401212599a54203d036ee&id=3c2377ef67
I guess we all ran into this problem once in a while: our Vagrant / Homestead machine freezes, gets destroyed and all data is lost. Of cours


refrr:http://us11.campaign-archive2.com/?u=a459401212599a54203d036ee&id=3c2377ef67
mysql  vagrant  environment  server  backup  automation  scripting  cli  shell   
january 2017 by michaelfox
GitHub - interconnectit/Search-Replace-DB: A PHP search replace tool for quickly modifying a string throughout a database. Useful for changing the base URL when migrating a WordPress site from development to production.
michaelfox starred interconnectit/Search-Replace-DB
A PHP search replace tool for quickly modifying a string throughout a database. Useful for changing the base URL when migrating a WordPress site from development to production. https://interconnectit.com/products/s… This script was made to aid the process of migrating PHP and MySQL based websites. It has additional features for WordPress and Drupal but works for most other similar CMSes.


refrr:https://github.com/search?l=PHP&o=desc&q=search+database&s=stars&type=Repositories
created-by:ifttt  via:github  github-starred  mysql  php  database  tools  refactoring  search  find  replace  code  repository  source  db  string 
january 2017 by michaelfox
Adding MySQL Slow Query Logs to Logstash | Phase2 Technology
Logstash is a great tool for consolidating logs and making them easy to analyze. Adding multiline log files such as MySQL
logging  mysql  aws  rds  elk 
december 2016 by michaelfox
How to build a MySQL-powered search engine (Example)
This post originates from my personal blog, at http://www.mullie.eu/mysql-as-a-search-engine/ In content-heavy websites, it becomes increasingly important to provide capable search possibilities to
search  mysql 
december 2016 by michaelfox
MySQL Log Analysis with the ELK Stack
Analyzing query performance can help to determine causes of database bottlenecks. In the case of MySQL, one useful method is to analyze the logs.


refrr:https://dzone.com/
Analyzing query performance can help to determine causes of database bottlenecks. In the case of MySQL, one useful method is to analyze the logs.


refrr:https://dzone.com/
mysql  logging  logstash  elk  devops 
november 2016 by michaelfox
Encrypting InnoDB
Learn how you can encrypt InnoDB using some handy plugins and how you can expect the added security to hit performance.


refrr:https://dzone.com/
Learn how you can encrypt InnoDB using some handy plugins and how you can expect the added security to hit performance.


refrr:https://dzone.com/
data  database  encryption  security  devops  aws  mysql  pci  bestpractices 
november 2016 by michaelfox
Hamming Distance
BITWISE XOR - HAMMING DISTANCE between two long HEX values e.g. find similar images or anything else that has a hashvalue comparehash - returns similarity in percent


refrr:https://www.google.com/
BITWISE XOR - HAMMING DISTANCE between two long HEX values e.g. find similar images or anything else that has a hashvalue comparehash - returns similarity in percent


refrr:https://www.google.com/
mysql  diff  compare  image  hash  search  query 
november 2016 by michaelfox
« earlier      
per page:    204080120160

related tags

admin  ajax  alert  algorithm  alias  analytics  apache  api  app  article  audit  automation  awesome  aws  backup  bacula  benchmark  bestpractices  boilerplate  book  bookmarks  books  characters  charactersets  chart  charts  cheatsheet  cheatsheets  checker  checklist  chrome  cli  code  codegenerator  codeigniter  collection  compare  conventions  convert  countries  created-by:ifttt  css  curated  customization  dashboard  data  database  dataset  date  db  debug  demo  design  designpatterns  development  devops  devtools  diff  docker  documentation  dotfiles  download  eav  editor  elasticsearch  elk  eloquent  emoji  encryption  entity  environment  feed  fiddle  find  format  framework  generator  git  github-starred  graph  guide  hash  hierarchical  hierarchy  hieratical  history  howto  html  image  index  inspiration  install  ios  javascript  jquery  js  json  kibana  laravel  learning  library  lint  list  load  loadbalancing  loadtesting  logging  logs  logstash  mac  maintenance  management  markdown  meta  metadata  metrics  migration  migrations  model  mongo  mongodb  monitor  monitoring  monolog  mysql  mysqlslap  naming  nested  nestedset  network  newrelic  node  nosql  notification  opensource  optimization  oracle  organization  orm  osx  parser  partition  patterns  pci  pdo  performance  php  plugin  postgres  postgresql  presentation  procedure  profiling  programming  prototype  proxy  python  query  rds  reading  refactoring  reference  regex  relationships  replace  repository  resource  rotate  rss  s3  sandbox  scaling  scanner  schema  scraper  scripting  search  security  server  service  setup  shell  site  snippets  source  sql  standard  string  styleguide  sublime  sysadmin  tags  testing  theme  time  tools  tree  troubleshooting  unicode  Unread  utf8  utilities  utility  vagrant  validation  versioncontrol  versioning  via:github  via:mledu  visualization  webapp  webdev  wordpress  xml  yaml  zabbix   

Copy this bookmark:



description:


tags: