Posts

Showing posts from August, 2011

Configuring MySQL on Redhat Linux while utilising network (iSCSI) storage.

Challenges: MySQL only allows a single location to be specified as the default data store for all databases. Consider the following typical scenario: A database server running one instance of MySQL has its datastore located at /mysql/databases. This server will contain multiple databases for multiple applications. The database tables are a mixture of InnoDB and MYISAM storage engines. The storage is provided by a SAN and separate storage volumes (iSCSI targets) are provisioned for each database. In this scenario, you would want all your MYISAM files (*.MYI, *.MYD, *.frm) and all your InnoDB table spaces to be contained on the same iSCSI volume on a per-database basis. Solution: This is easily achieved by mounting the iSCSI target on a sub-folder of /mysql/databases. For example: Mount iqn.openfiler.com:2006-06:blog-db-storage on /mysql/databases/blog Here is a sequence of steps that need to be carried out to make this work. in /etc/my.cnf set datastore=/mysql/da

MUST FOLLOW PROCESS...

MUST FOLLOW PROCESS.... MUST FOLLOW PROCESS... Starting with the premise that we need our customers to be happy with us, what do we need to do as an organisation to keep them that way? We are working through steps to improve our customer satisfaction at work by carefully considering how our daily work routines, processes and actions impact our customers. Consider this fairly typical example of how an organisation might respond to a customer request: [NOTE: This is a little bit (A LOT) satirical and not meant to in anyway be a real representation of an actual process. It's designed to highlight how strict adherence to process can lead to unhappy customers.] A customer needs a new type of widget. Your organisation sells gadgets that are very similar to widgets so they approach you to design and build one for them. They are willing to pay for the service but they need this new widget to work for them. Luckily your organisation has a process to handle this type o