Profile cover photo
Profile photo
Dathan Pattishall
1,425 followers -
Hacker, Husband, Father, Good Looking Nerd
Hacker, Husband, Father, Good Looking Nerd

1,425 followers
About
Dathan's posts

Post has attachment

Post has attachment
INNODB Tablespace Copy in Go Lang
I just uploaded a quick tool that I think you will find useful if you need to consolidate, expand innodb databases if tablespaces are in use. This golang application will copy an entire innodb database from one server to another server via scp. innodb-table...

Post has attachment
Tech Stack at Shots Quick Post
The Shots APP we use the following technology to serve many millions of Photos, Videos and Cached Links. LAMP RedHat Enterprise 6 on the Front ends and DBs. Amazon Linux (Centos) on Elastic Search and Go servers Apache 2+ Percona 5.6 XTRADB with some minor ...

Post has attachment
Wish there is another String DataType called LIST but there is not
I believe the future of SQL is to take a lot of primitives that are Computer Science fundamentals and add them as datatypes to expand on the allowed columns today. The idea is of the ilk of a merging of noSQL and SQL  for solving problems to make it easier ...

Post has attachment
Golang websockets (wss) and "OOP"
Golang is awesome. My 1st Language back in 1994 was C. Then the following year my Computer Science Dept. switched from C/Pascal to C++. I even like C++ but I like C more mainly because of nostalgia. Enter Go. The Syntax for me is a mix between JSON, and C. ...

Post has attachment
San Francisco mySQL Meetup August 26 2015
Shots Architecture and how we handle extreme load spikes I invite you to come out and join me in a talk about the above heading. I will describe many things and walk through the cases of what technology is used, where, why and how. The event information is ...

Post has attachment
Reporting Across Shards
If you have chosen to split your data across boxes, and architected your app to not query across boxes there is still a case where you will need to. Data mining, reports and data health checks require hitting all servers at some point. The case I am going o...

Post has attachment

Post has attachment
Federating THE friends table in a Sharded mySQL environment without downtime or users noticing
A friends table is the cornerstone of social applications. Its purpose is to define relationships and help answer the question what are my friends doing. Here is an example friend’s table:  CREATE TABLE `friends` (   `user_id` bigint(20) unsigned NOT NULL, ...

Post has attachment
Long time since an update but great stuff coming along
So, its been a long time since I contributed anything to my blog. That will end very soon. Things coming up is writing about the architecture of Shots, Shard optimizations, Data Organization and Grouping, Java, Golang and some cool other stuff. Also how to ...
Wait while more posts are being loaded