Posted on in System Administration
While researching a problem with our Oracle Fast Recovery Area (FRA), I took note of the more useful commands I used. This is from Oracle 11g R2 with the Real Application Clusters (RAC) and Automatic Storage Management (ASM) options.
Show how much of the FRA is in use …
Posted on in System Administration
If you are unfamiliar with Oracle and setting up your vCloud Director Oracle database, don't make the same mistake I made:
SQL> CREATE TABLESPACE "CLOUD_DATA" DATAFILE "/home/oracle/app/oracle/oradata/orcl/cloud_data01.dbf" SIZE 1000M AUTOEXTEND ON ;
CREATE TABLESPACE "CLOUD_DATA" DATAFILE "/home/oracle/app/oracle/oradata/orcl/cloud_data01.dbf …Posted on in Software
In a small environment, there's very little reason to rely on DNS resolution inside MySQL. You can disable it by adding skip-name-resolve to your my.cnf or by using the --skip-name-resolve command line argument.
Remember that if you disable DNS lookups, you will need to set permissions using IP addresses …
Posted on in Programming
This will just be a short reminder. If you're planning to create multiple-column indexes in MySQL, remember that the order of the columns matters. As the MySQL documentation points out, any "leftmost prefix of the index can be used." This means that the index can be used for any number …
Posted on in Software
Oracle announced the release of VirtualBox 4.0.4 today. This maintenance release addresses many bugs experienced by hosts of all operating systems. You can find a full list of fixes and additions in the Changelog.
I use VirtualBox on both my Macs for my various testing needs. If you've …
Posted on in System Administration
If you're using a non-standard MySQL data directory on your Red Hat Enterprise Linux (RHEL) server, you may have seen an error like /usr/libexec/mysqld: Can't change dir to '/mysql_data/' (Errcode: 13). The key to fixing this problem is to ensure the new MySQL data directory has the proper …
Posted on in Software
Oracle's VirtualBox 3.2.10 was released today. This another maintenance release for 3.2 that includes a wide variety of bug fixes. Check out the Changelog for more details.
I use VirtualBox on both my Macs for my various testing needs. If you've got a favorite desktop virtualization program …
Posted on in Software
In a test lab, we ran into a situation where the connection between our Cisco Access Registrar (AAA) server and MySQL server was timing out. This forced the server to reconnect and resulted in the following errors:
name/radius/1 Error Server 0 ODBC client (DataSource 'my_odbc', Connection 8): SQLExecute …Posted on in Software
Oracle's VirtualBox 3.2.8 has been released. This is a maintenance release that mainly focuses on bug fixes rather than new features. Although I don't think the changes in this release are as prolific as the fixes in 3.2.6, it's definitely worth downloading.
One key feature buried …
Posted on in System Administration
We ran across the following error on a MySQL slave server recent:
mysql> SHOW SLAVE STATUS \G
<snip>
Last_Error: Query caused different errors on master and slave. Error on master: 'Deadlock found when trying to get lock; try restarting transaction' (1213), Error on slave: 'no error' (0). Default database: '<database_name …
