What is Ansible?

Ansible is a configuration management and deployment system, like Puppet, Capistrano, Fabric, and Chef. Its aim is to be radically simple and let you use your existing scripts to help with cluster configuration and software deployment whenever possible. Here are the ways that Ansible differentiates itself.

Simplicity

Ansible does not include a client/server architecture with pull-based clients (although in more recent versions, it does include pull-based configuration and deployment). Rather, it uses pre-existing network infrastructure: SSH. Every company has SSH installed on their cluster servers, and Ansible simply rides on top of this infrastructure to get the code and configuration out to the nodes.

Language Agnostic

You can write modules for Ansible in …

Innodb uses row level locks right ? So if you see locked tables reported in SHOW ENGINE INNODB STATUS you might be confused and rightfully so as Innodb table locking is a bit more complicated than traditional MyISAM table locks.

Let me start with some examples. First lets run SELECT Query:

---TRANSACTION 12303, ACTIVE 26 sec
mysql tables in use 2, locked 0
MySQL thread id 53038, OS thread handle 0x7ff759b22700, query id 3918786 localhost root Sending data
select count(*) from sbtest,sbtest x
Trx read view will not see trx with id >= 12304, sees < 12301

As you can see in this case the query self joins the table so we observe 2 table instances (note - same table gets counted twice) in use but zero tables are locked. Innodb does not need any row locks for conventional selects it will just use MVCC to handle updates if they were to happen concurrently.

Lets now try same select but add LOCK IN SHARE …

With its distributed, shared-nothing, real-time design, MySQL Cluster has attracted a lot of attention from developers who need to scale both read and write traffic with ultra-low latency and fault-tolerance, using commodity hardware. With many proven deployments in web, gaming, telecoms and mobile use-cases, MySQL Cluster is certainly able to meet these sorts of requirements.

But, as a distributed database, developers do need to think a little differently about data access patterns along with schema and query optimisations in order to get the best possible performance.

Sharing best practices developed by working with MySQL Cluster's largest users, we recently ran a Performance …

Please note that users upgrading from a version before 5.2 will need a new registration code. Registered customers will get the new code from our Customer Portal. Please have the new code available before installing. Until MONyog is registered with the new key, it will not be collecting data from your servers.

Changes (as compared to 5.21) include.

Features:
* Introduced support for ‘native’ MySQL SSL-encryption with direct MySQL connections.
* MONyog now fully supports IPv6 (Internet Protocol Version 6).
* History-trends have been optimized to retrieve data faster than it was before. With large data sets this results in a speed improvement in the range of a factor ~25 .
* Passwords for MONyog users are no longer stored in clear text. A hash is stored (for admin user in MONyog.ini – for other users in the embedded database). Also MySQL passwords as …

I think this is what you would expect through single connection. However what if you do multiple connections at the time ? There would be a potential optimization opportunity of “group commit” for semi sync replication. This is also where parallel application by solutions like Percona XtraDB Cluster help.

Today, Percona announces that Live Virtual Training is now an option for busy professionals.

We set out to develop a training solution that balances the time to deliver the content with the amount of time an attendee can participate in a live virtual training (LVT) session. The goal was to ensure there was still time in the day to allow the attendee to complete his or her work. Percona’s LVT offering extends the days of delivery while reducing the time the attendee needs to be in class each day. Our LVT sessions are a combination of live virtual sessions and remote labs,  blended with online learning. How does this work?

We ask that attendees set aside 2-hours each day for 5-days for the live virtual sessions. This is the time when the Percona instructor delivers the lecture, shows examples, and answers questions. After the live session is over, attendees have a remote lab that will take, on average, 30-minutes to complete. …

If you’re looking for best prices for Percona Live NY 2012, taking place Oct 1,2 in New York do not delay and book now. Super Saver discounts ends tomorrow, which can save you hundreds of dollars off conference prices list prices. These are the best prices you can get by booking early – There will be no other discounts available that will get you to this price.

Percona Live NY 2012 builds on success on our 2011 NY event Which attracted over 300 attendees in May 2011. We have expanded the event to 2 days, adding Tutorial Day with many in depth and hands on training sessions for most popular MySQL topics. We also have moved to the new, …

MySQL Enterprise Backup ("MEB") has always provided a simple, reliable online backup solution for InnoDB backed applications that includes DBA-expected functionality around:

• policies that require full, incremental, partial and logged based backup
• point in time recovery
• back up compression
• back up and recovery for MyISAM, Merge, Partition, Archive

In addition, MEB also provides a scriptable "set it and forget it" command line interface that allows DBAs to schedule and control backup operations at the server and database levels.  Integration with the MySQL Enterprise Monitor ensures that any MEB related issues are quickly identified and DBAs alerted so there is no lapse in the ability to recover when needed. …

Tuesday, September 18, 2012, 6:30pm – 8:00pm 

Cambridge Innovation Center,  1 Broadway, Cambridge, MA (map) http://www.meetup.com/boston-java/events/75357012/ Doron Levari Doron will be speaking at the Java Meetup.  Doron is a long-time veteran of the database industry and the publisher of the Database Scalability Blog, has extensive experience in building and scaling-out database systems as well as the organizations and infrastructure necessary to support them.  Please find a [...] Read More

Taxonomy upgrade extras: doagreplicationgaleramysql

On Tuesday, September 4, 2012 the next DOAG SIG MySQL meeting will take place in Hamburg (Germany) with the topic Replication.

Possible presentations are: MySQL Replication, Galera Cluster, Replication with Oracle GoldenGate, Replication with Zimory Scale and Tungsten Replicator.

The event will presumably be located at the Hotel Böttcherhof at Wöhlerstrasse 2.