Yessir, I’m back home. Bought a new bed (god, I forgot how good sleeping can feel) and spent the first two days at work already (yes, it’s Friday afternoon already).
I *really* thought catching up after having a 2 week vacation would take more time, but it just took yesterday morning (till ~9am). I’m surprised by the taste of black tea with milk and sugar
(yes, I was like *yikes* initially, but I like it pretty much now 😀 ) and by the ability to rise at 7am in the morning 😛
On Monday I finally got to do an expanded test drive with my shiny, new car (that is driving it up from Stralsund down to Stuttgart). I really can’t complain, the fuel consumption is like I expected (~6.6l/100km while driving between 160 and 180km/h), the noise while driving that fast is quite low (as in you hear the engine but you don’t really consider it noise) and the acceleration is nearly like the one of a F1-car 😛 (at least I’d wish 😉 ). Spent the evening relaxing from the near 950km nonstop trip (yes, only had one stop to put some fuel back into the car), had nice curry (my cousin’s husband made yummy potato curry!!!).
On Tuesday I nearly spent the whole time on a boat driving down and up the Neckar (that’s the river flowing through Baden-Wuerttemberg), being lazy, lying in the sun for 5 or 6 hours, spent time talking to my aunt and to my cousin while trying to listen to the music fluttering out of my iPod nano (“Autobahn – Linke Spur”).
On Wednesday I got up rather late, helped my aunt picking up her car from the car dealer (they had to fix the air conditioner and did the yearly inspection). Afterwards my brother and I went of to see if we could find a nice and gooood bed pour moi at Ikea in Sindelfingen (yes, I admit it .. I like IKEA too 😮 – which turned out rather, err, shite. I didn’t find a bed pour moi, but I picked up a couple of bookshelf’s and a 2,20m’ish CD/DVD shelf.
On Thursday, I had my complete lazy day. Woke up around 9am, went downstairs to see my brother and my cousin’s husband and his parents were already awake. Ate breakfast till 11am and sat around on the sofa for a few hours and waited till my aunt and my cousin would wake up. In the afternoon I went to see my other uncle and aunt, did some catch-up with them, played a bit with their cutie cats (they are like 9 months old). Afterwards we went shopping for some Maultaschen for my brother’s host family in Belgium/Eupen. Went onwards to see my other cousin’, his wife and his cute lil’ daughters. That was my lil’ four day vacation in Baden-Wuerrtemberg …
Here’s just a note for you people out there, how’re crazy enough and want something from me in the next week (that’s 18th till 26th June):
I’m on vacation …
Means I won’t be around to fix anything (as I’m gonna try and relax a bit), so if you encounter something that you want to fix; consult with the herd (that’s apache/hardened/kernel …) and/or fix it YOURSELF. Just make sure you don’t break it more 🙄
OK, it turns out that I was rather stupid when configuring the my.cnf. As it turned out, the effect I was seeing was due to the presence of two log-bin lines, which looked like the following:
|
1 2 3 4 5 6 7 8 9 10 11 12 |
[mysqld] port = 3306 datadir = /mysql/dbase log = /mysql/logs/dbc-mysql1.log log-error = /mysql/logs/dbc-mysql1.err socket = /var/lib/mysql/mysql.sock bind = 172.16.234.31 # custom paths for binary logs log-bin = /mysql/binlogs/dbc-mysql1 log-bin-index = /mysql/binlogs/dbc-mysql1.idx relay-log = /mysql/binlogs/dbc-mysql1.relay |
And some lines down there was this:
|
1 2 |
# custom paths for binary logs log-bin |
Now the next thing I encountered was while importing our old databases (they are like 1.1GiB each, 25 databases total). The second MySQL Master (and his Slave) will choke as soon as you dump the data too fast into the first Master, as the binlog seems to be too big for MySQL to transfer it via TCP (smth like “Packet too large – try increasing max_packet_size” in the error-log; only problem was that max_packet_size was already at 1GiB which is the absolut maximum for MySQL 5.0 according to the handbook).
A way around this (thanks to a co-worker who pushed me towards this road) is disabling all the MySQL Master/Slave stuff in your my.cnf, start the mysql daemon as a simple, dumb database, import all your databases, stop the mysql daemon; tar up the whole BASEDIR and scp/rssh it to your second master.
Clean out the BASEDIR on the second master, untar your tarball, edit your my.cnf again to include the whole Master/Slave portions on both boxes and you should be up and running 😀
I haven’t run any tests on the MasterMaster replication yet, but I’ll do that as soon as I’m at work again (which is the 27th June, as I’m off for vacation since yesterday, yay!)
Here I am, sitting at my desk on a Thuesday evening thinking about what happened the last few days.
When started with the –log-bin[=base_name] option, mysqld writes a log file containing all SQL commands that update data. If no base_name value is given, the default name is the name of the host machine followed by -bin. If the basename is given, but not as an absolute pathname, the server writes the file in the data directory. It is recommended that you specify a basename; see Section B.1.8.1, “Open Issues in MySQL”, for the reason.
That behavior works for –log-bin-index (like log-bin-index=/mysql/binlogs/$HOSTNAME.idx), but doesn’t for –log-bin. *shrug* I’ll see if that is fixed with something >5.0.18 (that’s what SLES10 currently ships).
I’m also looking for a network topology drawing program (possibly free), as Microsoft Visio (either 2003 or 2007, Standard or Professional) is nice, but still can’t draw shit correctly. So I stumbled upon yEd, which seems to look nice (I haven’t yet looked at it, but will tomorrow) that hopefully gives me the opportunity to draw/visualize my setup at work 😯