AaronBBrown

39 ms·

121.
by AaronBBrown 14y ago
1. Yes, applications can set sql_mode themselves at the session level. An admin cannot prevent this. http://dev.mysql.com/doc/refman/5.5/en/server-sql-mode.html
122.
by AaronBBrown 14y ago
Thank you for the clarification about the PostgreSQL terminology. That will help me keep track of the progress. I am very pleased that the PostgreSQL community has finally started implementing native logical replication, which is really o
123.
by AaronBBrown 14y ago
What version of MySQL? Sounds like the old AUTOINC lock mode behavior. http://insatiabledemand.ideeli.com/post/18850015294/diagnosi...
124.
by AaronBBrown 14y ago
Are you suggesting that there isn't "serious commercial support" available for MySQL? Oracle, Percona, SkySQL, and a number of other businesses provide high quality support for MySQL installations.
125.
by AaronBBrown 14y ago
As I mentioned, I do like PostgreSQL for its consistency and I want to like it even more. Cascading replication looks interesting - does it support the topology that I mention where the master has a subset of the from the slaves and the sl
126.
by AaronBBrown 14y ago
Objective citation, please?
127.
by AaronBBrown 14y ago
I just watched a 10 minute video whereby nearly all the issues pointed out can be solved with one line in my.cnf or dynamically by setting SET GLOBAL server_sql_mode=TRADITIONAL. Yeah the default is no good. Learn your RDBMS and the proble
128.
by AaronBBrown 14y ago
Flume is only related to MapReduce in that it is able to write to HDFS. All Flume is is a transport mechanism to send log-like data from one place to another. It can be made fancy by adding decorators to manipulate the data along the way
129.
by AaronBBrown 14y ago
Can HN just ban gigaom articles? Have they ever written a single technically interesting or accurate article in their entire existence? It's all just spin.
130.
by AaronBBrown 14y ago
Apparently, $11,000
131.
by AaronBBrown 14y ago
Another key point is that temporary tables are horrible for concurrency. Obviously only one session can access them, but more importantly, they end up causing a great deal of disk activity. At the end of every session, the table is physic
132.
by AaronBBrown 14y ago
You are clearly not talking about MySQL. CREATE TEMPORARY TABLE simply creates a physical table on disk that is destroyed at the end of the session, which can be created with any storage engine. Explicit temporary tables are handled just
133.
by AaronBBrown 14y ago
Riak is a great product with an incredible support team, if you choose to use their support.
134.
by AaronBBrown 14y ago
MEMORY tables have table-level locks and from a concurrency perspective, is just as bad as MyISAM, so really offer no advantage unless there is only a small number of consumers. A well tuned InnoDB table will outperform the MEMORY engine )
135.
by AaronBBrown 14y ago
Can you explain this further? How is using a temporary table faster? Explicit temporary tables are simply regular tables that only last your current session. Do you mean the MEMORY storage engine? What do you mean by "don't use keys, us
136.
by AaronBBrown 14y ago
Agreed, but the point was that there are very very few legitimate reason in 2012 to use ed unless you just happen to like it.
137.
by AaronBBrown 14y ago
Can you give a specific example? I have a not insignificant amount of experience with thousands of servers under my belt and I have yet to ever need to type "ed" into a server. I did find edlin useful in DOS 4, but that was ancient times.
138.
by AaronBBrown 14y ago
Having been a user of *NIX for over 20 years and a professional Systems Administrator for over 10, I have never once had a reason to use ed. Even the smallest embedded environments usually have some variant of vi available. The only time
139.
by AaronBBrown 14y ago
I'm curious about the performance overhead of this vs using traditional syntax with named variables. Looking over the gem, the code is quite terse, but it depends on method_missing, which is notoriously slow. The danger with an abstractio
140.
by AaronBBrown 14y ago
As a paying customer of Basho who has had several direct experiences with sales and technical support, I second this. They are incredibly helpful in the event of a problem and are passionate about educating their customers to provide the h
141.
by AaronBBrown 14y ago
Thanks, papsosouid. Facts are much more useful to discussions like this. It still doesn't change the fact that PHP is capable of running the most trafficked sites in the world (side note: I don't like PHP, either. I just hate haters who
142.
by AaronBBrown 14y ago
So, you have no facts, just bias. Thanks.
143.
by AaronBBrown 14y ago
What do you base that on?
144.
by AaronBBrown 14y ago
I said capable, not awesome, or cutting edge, or the only thing you'll ever need, or the best thing since sliced bread. Capable is very different from your obviously flawed analogy. Windows 3.1 and the original Macintosh were successful a
145.
by AaronBBrown 14y ago
Bitcask is specifically designed around not doing random I/O, particularly for writes. A bitcask back end is essentially a gigantic sequential transaction log.
146.
by AaronBBrown 14y ago
It proves that the technologies are capable products at the most massive scales. Do you have evidence to support that Facebook, Tumblr, or Etsy would have been better off had they chosen different technologies (of course not)? Or that the
147.
by AaronBBrown 14y ago
MySQL Cluster, Percona XtraDB Cluster, Clustrix, Continuent Tungsten Replicator, vitess, and a number of other products are available in the MySQL ecosystem designed around these types of problems.
148.
by AaronBBrown 14y ago
By that, you mean used effectively on some of the largest, most profitable websites in the entire world? ;)
149.
by AaronBBrown 14y ago
Have they actually done usability studies on this or are they just making stuff up?