So after my MySQL server-id idea. I was asked to come up with a function to Convert IP Address. So here it is. use test; DROP FUNCTION IF EXISTS IpToInteger; DELIMITER // CREATE FUNCTION IpToInteger ( ipAddress CHAR(15) ) RETURNS INT UNSIGNED DETERMINISTIC BEGIN DECLARE o1,o2,o3,o4 char(3); DECLARE IpInteger INT UNSIGNED; SET o1 = REPLACE(SUBSTRING(SUBSTRING_INDEX(…
Amazon Cloud Sends in the MySQL Clones
Amazon is making it easier, and cheaper, to roll out copies of MySQL for very large websites across its cloud. On Tuesday, the company announced an update to its Amazon Relational Database Service that will let users create and delete multiple Read Replicas of MySQL instances in minutes, via a point-and-click interface. Full Story Here
Coming up with a unique MySQL server-id
The server-id, is used in replication to give each master and slave a unique identity. For each server participating in replication, you should pick a positive integer in the range from 1 to 2^32 – 1 to act as that server’s ID. To come up with this id convert the IP address of the server…
Slacking off
Well I haven’t really wrote anything in the last couple of months even though, I have had plenty to write about. I went to OSCON 2010 in July and had a great time. I learned more about MongoDB and picked up a few more bits of information on MySQL, Memcached, and Linux. In July I…
Building Thrift on RedHat/CentOS 5.x
What’s Thrift you ask? Well to quote their website. Thrift is a software framework for scalable cross-language services development. It combines a software stack with a code generation engine to build services that work efficiently and seamlessly between C++, Java, Python, PHP, Ruby, Erlang, Perl, Haskell, C#, Cocoa, Smalltalk, and OCaml. And why do I…
Couchdb vs. Cassandra.
And Cassandra wins by a knock out and the crowd goes wild. http://couchdb.apache xenical buy online.org/ vs.http://incubator.apache.org/cassandra/. Couchdb is more user friendly, but Cassandra is way more advanced.
MySQL Workbench..
The MySQL Workbench has been out for a little while now, and I kind of put it to the back of my mind, because when it come out it was on Windows only. I, myself use Linux about 90% of the time, so I figured I would wait until they had a Linux version. The…
SchemaSpy
“Do you hate starting on a new project and having to try to figure out someone else’s idea of a database? Or are you in QA and the developers expect you to understand all the relationships in their schema? If so then this tool’s for you.” This is actually really nice and fast. Also makes…
Finding the HBA WWN on RHEL 5.x
Nice and easy one line command. shell> cat /sys/class/scsi_host/host*/device/fc*/port_name
So many to choose from.
For the last month or so. There has been a debate amongst, my peers and I, on which is the better file system on Linux and how to benchmark and test it. So digging through my back log of emails I notice that Linux Magazine was running a series on the this some topic. So…