The new licensing that was announced by Oracle earlier this month caused some FUD in the community that was addressed last week in an updated graphic comparing support and binary options and blog post from Oracle. However, one of our customers sent me this earlier this week – We are now re-evaluating whether we want to renew our MySQL … [Read more...]
Defining MySQL Backup Strategies
Backups may seem like a complicated subject, but they can be simplified into one multi variable question. What $DATA is so important that you don’t feel you could be missing it for $TTR and you can’t lose more than $RPO of it? I am using the acronyms TTR to represent the time to recovery objective and RPO to represent the recovery point … [Read more...]
Semi-Synchronous Replication in MySQL 5.5
As I was digging into the change logs for MySQL 5.5 and the replication substructure, I ran into the new features of semi-synchronous replication. This is implemented in MySQL 5.5 with the master database blocking and not returning the session after writing to the binary log unless a slave (which has also identified itself as running … [Read more...]
Database Administration Jobs and Remote DBA
I’ve been considering the fact that so many of the companies that contact us are looking for a DBA when they begin our conversations. There are a few things that go into this, I believe. MySQL DBA is a new job title. There is no long history of what skills define this role Oracle DBAs can specialize in so many things, and their depth of … [Read more...]
DBD::mysql 4.018 released
Dear Perl and MySQL developers, admins and enthusiasts, I'm please to announce the release of DBD::mysql 4.018! This release includes some code cleanups, added documentation as well as new features (database handle attributes) that allow you to be able to ascertain the server and client versions (Thank you to Robert M. Jansen). An example below, … [Read more...]
InnoDB tablespace fragmentation (find it and fix it!)
If you frequently delete rows (or update rows with variable-length data types), you can end up with a lot of wasted space in your data file(s), similar to filesystem fragmentation. If you're not using the innodb_file_per_table option, the only thing you can do about it is export and import the database, a time-and-disk-intensive procedure. … [Read more...]
DBD::drizzle .301 released
Dear Perl and Drizzle developers, I’m pleased to announce the release of DBD::drizzle .301! This release implements several fixes: * Eric Day’s fix to a bug where a result can be NULL after error. * A lot of reworking of column_info() to utilize Drizzle’s DATA_DICTIONARY and INFORMATION_SCHEMA as opposed to describe and show … [Read more...]
How I got access to My Oracle Support (MOS) for US$2.67
Oracle professionals know that the two main sites for information and support on running Oracle products are the Oracle Technology Network (OTN), and My Oracle Support (MOS). OTN is free for anyone, and provides discussion forums, white papers and free base-release software downloads under the Developer License. MOS requires a paid software … [Read more...]
Debugging Stored procedures
Over the past several weeks, we've been working on debugging a stored procedure bug for a client. Coming from a software development background, I looked at the procedure like any piece of code -- how can I debug the program and be able to use some means of knowing the values within the program while it's running? In C, I've always used GDB, as … [Read more...]
Open DB Conference Roundup
There are a few things to note RIGHT NOW for those of us in the world of open databases. The MySQL User Conference has opened their call for proposals and the IOUG Collaborate11 call for proposals closes tomorrow 10/1! Get your proposals in. OpenSQLCamp is 10/15 -> 17 and BG is sending Patrick as I mentioned earlier this week. If you're in … [Read more...]
OSCON, OpenWorld and MySQL community
Today’s excitement for me is the announcement that I’ll be co-chair of OSCON for 2011. This has been in the works for a chunk of the summer, and I’m super excited that I can start talking about it more publicly. Edd Dumbill and I are discussing lots of awesome sessions, tracks and foci for OSCON 2011. The call for proposals … [Read more...]
Report from Oracle Openworld
Openworld 2010, despite the supposedly lagging economy, had record attendance again this year. No doubt this was the result of Oracle acquiring something like fourteen companies since last year, including Sun in 2009. The crowds were thick, divided about evenly between geeks in badly-fitting vendor t-shirts and slick sales-side hustlers with … [Read more...]
A Cloud over San Francisco for OpenWorld 2010
Oracle OpenWorld 2010 is just bursting with big cloud-related announcements this week. As I prepare to present on the Amazon cloud at OOW2010 on Thursday (http://bit.ly/aSKdIQ), I thought I would highlight two of the biggest cloud-related announcements of the week. Exalogic We all know about Exadata, Oracle’s hardware-based storage-optimized … [Read more...]
Blue Gecko recommends the University of Washington Oracle Certificate program
At Blue Gecko, we believe that cultivating strong technical contributors is key to our own and our customers’ success. That’s why we are proud to be a part of one of our region’s premier Oracle educational programs: The University of Washington Certificate in Oracle Database … [Read more...]
Blue Gecko named to 2010 Inc. Magazine’s 5000 fastest growing companies in America!
Blue Gecko is one of the fastest-growing private companies in America for the second year in a row. An Inc. 500|5000 recipient in 2009, Blue Gecko is once again listed in Inc. Magazines’s annual ranking of the fastest-growing private companies in America. The list debuted in 1981 as a ranking of the 100 fastest-growing private companies in … [Read more...]
- « Previous Page
- 1
- …
- 4
- 5
- 6
- 7
- 8
- …
- 13
- Next Page »