The kind folks at O'Reilly sent me a fantastic book about
MongoDB. This was a great read since it’s suited for people who
do Operations and Development and Performance tuning (me). I've
been using Cassandra for quite some time now (months lol) and the
thing that has irritated me about Cassandra is the documentation
for it. Cassandra documentation sucks, its hard to speed up on
the internals. This MongoDB book is written by the most active
participants that are developing MongoDB and the knowledge shows.
What I like is it starts out on how to quickly get it up,
add/get/update data to the DB. Then progresses to more advance
topics-that talk about GridFS and MongoDB drivers. Personally I
would like to see more elaboration of this facet in terms of
motivation of why do this, what the win is and how it fits into
the "Fast by Default" mantra. Each step is organized perfectly, …
I recently upgraded the firmware on my Draytek Vigor 2820n ADSL router to version 3.3.4 from 3.3.3. One thing that surprised me was that the change stopped me being able to access my public IP from behind the router. That is I have an internal LAN with RFC1918 addresses such as 192.168/16 and could access [...]
Seeing as it looks like 5.5 is shortly about to go GA I thought I’d give it a run and see how well it works. The only way really to test it is to give it a bit of load and look for things which break. That I did with the 5.5.6-rc community rpms, compared to the 5.1 advanced rpms I usually run.
My colleagues, Ben and Peter, found a horrible problem which means that I can’t use this even for any real usage on my real servers. See: bug#57095 for all the gory details. Thanks to them both for finding the problem and then digging down and figuring out the real cause. Sometimes developers work a long way from the database so their errors don’t translate into something I can really look at in the database. They delved into the problem and then found the cause and a nice easy test case which I could report to MySQL.
After a couple of days of running this was …
[Read more]| We all (at least majority of us) use some sort of maps to reach from one destination, say home, to another destination, say a shopping mall or a convention center. But once you've reached the mall then you switch to a different set of tools to navigate that is typically either a paper flyer or sign boards within the mall. Micello.com fills that gaps by providing maps for any indoor locations like airport, shopping malls, convention centers, retail centers, and college campus. |
Their application is built using "scalable stack" of GlassFish
and MySQL, uses RESTful Web services, and has given them a 99.9%
uptime in the past few months - no wonder its used to create
indoor maps for 50 malls in Singapore. Listen …
The default configuration file for MySQL is intended not to use many resources, because its a general purpose sort of a configuration file. The default configuration does enough to have MySQL running happily with limited resources and catering to simple queries and small data-sets. The configuration file would most definitely need to be customized and tuned if you intend on using complex queries and when you have good amount of data. Most of the tunings mentioned in this post are applicable to the MyISAM storage engine, I will soon be posting tunings applicable to the Innodb storage engine. Getting started...
| We all (at least majority of us) use some sort of maps to reach from one destination, say home, to another destination, say a shopping mall or a convention center. But once you've reached the mall then you switch to a different set of tools to navigate that is typically either a paper flyer or sign boards within the mall. Micello.com fills that gaps by providing maps for any indoor locations like airport, shopping malls, convention centers, retail centers, and college campus. |
Their application is built using "scalable stack" of GlassFish
and MySQL, uses RESTful Web services, and has given them a 99.9%
uptime in the past few months - no wonder its used to create
indoor maps for 50 malls in Singapore. Listen …
| We all (at least majority of us) use some sort of maps to reach from one destination, say home, to another destination, say a shopping mall or a convention center. But once you've reached the mall then you switch to a different set of tools to navigate that is typically either a paper flyer or sign boards within the mall. Micello.com fills that gaps by providing maps for any indoor locations like airport, shopping malls, convention centers, retail centers, and college campus. |
Their application is built using "scalable stack" of GlassFish
and MySQL, uses RESTful Web services, and has given them a 99.9%
uptime in the past few months - no wonder its used to create
indoor maps for 50 malls in Singapore. Listen …
Just in case you missed it, I’m rather thrilled that our latest tarball of Drizzle is named Beta. Specifically, we’re calling it Drizzle7. Seven is a very nice number, and it seems rather appropriate.
This release is for a stand alone database server. A lot of the infrastructure for replication is there (with testing), but the big thing we want to hammer on and get perfect here is Drizzle7 as a stand alone database server.
Can I trust it? If you trust InnoDB to store your data, then yes, you can trust Drizzle (it uses InnoDB too)
We now have hardware in our test lab that represents the next generation of commodity servers for databases. It’s a Cisco UCS C250 server, powered by two Intel Westmere CPUs (X5670 @ 2.93GHz). Each CPU has 6 cores and 12 threads. The most amazing part is the amount of memory. It has 384GB of RAM, which is actually more space than the disks contain. The disks are 270GB in total, with the underlying configuration RAID10 over eight 2.5″ 15K RPM disks. To make the system even more powerful, I put a FusionIO 320GB SLC card in the PCI-E slot. Here is a link to the box specs.
The server was generously provided by Cisco Systems, Inc.
So, obviously I’m anxious to …
[Read more]
I have several favorite authors -- Tim
Dorsey, Clive Cussler, and few others that I buy their latest
book just because I trust the quality of their work. Now on
that list are Roland Bouman, Jos van Dongen, and Matt
Casters. In a follow up to Bouman's and van Dongen's
Pentaho Solutions: Business Intelligence and Data Warehousing
with Pentaho and MySQL, the have now produced Pentaho
Kettle Solutions which explores the often murky world of ETL
and data integration.
Kettle can be confusing as there are many components with
names such as spoon and pan but these tools are
valuable to any DBA who has to feed data into an instance.
If you have a data ware house the tools are invaluable.
This book …