For the xth time, I’ve hit the MySQL bug #51325 - It state that with relatively big (>5 gigs) innodb buffer_pool (my.cnf::innodb_buffer_pool_size), the LRU invalidation on ‘DROP TABLE’ (or ‘TRUNCATE TABLE’) will lock the full table (even if DROP or TRUNCATE is on a partition). Bug is only present when using the ‘innodb_file_per_table‘, which is kind of sad because I love that configuration setting.
Solutions include disabling the innodb_file_per_table setting & reducing the buffer_pool size…
Along with development for Theatre.IO (server management system) (dev. version available for Les Laboratoires Phoenix enterprise clients), I’ve had to look into geo-diversity for the datacenter where the company got ‘silo’/'reference stack’ (a group of servers & devices which are the same, standardized, everywhere).
After a couple of very funny – they must have been a joke) – quotes from well known providers, look like we’ll be doing a dual deployment (Seattle & Chicago). That should cover north-America quite well. The phase 3, our Europe site, being on hold for another 5 months. This is a major investment for Les LabsPhoenix as our reference stack cost are in the 5 digits realm, but with geo-diversity and our own IPv4 and IPv6 ranges, there is much that can be accomplished.
Stay tuned as I’ll soon be presenting that reference stack (the free software which compose it, and the not-so-free-ones). There is still some things that need to be figured out (constant evolution, redesign), such as if the Mikrotik RB1200 will be powerful enough to hold the main traffic.
VMWARE recently quietly released a product called “vCenter Operations“. The product helps system administrator get a better view of the general (and specific) health of their infrastructure.
I’d suggest anyone with a vCenter/vSphere setup to try it out. The results are pretty amazing: the graphs and the analytic engine helped me quite a few time to diagnose issues clients have been reporting. Here is a quick screenshot where you can see the default view of one of my Labs environment, configured for testing purpose – a cluster of 3 ESX hosts and 12 VMs:
Still alive –
I’m now VSP (vmware sale specialist) certified, with the VTSP (vmware technical sale specialist) almost completed. Looking into completing the VCP (vmware certified professional) sometime in the next 3 months.
In the mean time, I’ve went overboard with shiny new stuff for myself (crazy spending spree) (been so long since I had a good read/game!):
Started with book:
Then with games:
Then with cloths:
And… There’s more coming! With Christmas I’ve got a cart of interesting items LabsPhoenix is going to buy for the ‘home’ lab. At the very least, a new mac-mini, a Razer mouse, a eSATA external enclosure (with the HD), 2 SSD drives, 2 Infiniband network card (with associated cables), OEM board (ie: Soekris, Wrap, …) with gigabytes connections and an ubiquity setup (3 antennas + router board). If I’m lucky, I might even buy this 24U enclosure I’ve been watching for a few months. There should also be a couple spending session for the LabsPhoenix own project (3x New Servers, vSphere licences, …) but thats another thing altogether.
photo: Business open as usual, by Pascal Charest
Re-launch of blog.pacharest.com under a new name (cloudweaver.org) & new url. Lots of reasons. Main one? I wanted it to be so – but also :
– because I have contractual engagement that the change of domain name will help to clear up.
– because I want to focus on network infrastructure (mainly dynamic and virtualized ones) from now on.
– because I wanted to integrate twitter somewhere on my blog (now directly in my feed/post page).