Galera cluster replication are now supported in MySQL InnoDB and Percona XtraDB. Even it is new, this technology is having bright future to be developed and is coming into trend to achieve high availability and scalability on database server.
No need to learn new storage engine technology like NDBCluster. Learning new technology will require [...]
MySQL is preferred to be run on XFS file system due to its performance on direct IO. Even though many benchmarks have already come out with the latest Linux default file system Ext4 versus XFS, it still convenience to use this file system for our MySQL data directory.
XFS is not come by default in [...]
To achieve high availability, what we really need is to eliminate single point of failure as many point as possible but, it comes with expensive way to do this. What if we just have 2 servers, and we want to have highest web service availability possible with lowest cost?
Most important part in this high [...]
After upgrading to FreeBSD 9, whenever I try to use ports to install something, I will get following error:
$ cd /usr/ports $ make search name=nano The search target requires INDEX-9. Please run make index or make fetchindex.
Then, I whenever I run make index command, it will prompt following error:
$ cd /usr/ports [...]
If you have setup your MySQL cluster or standalone database server correctly, you might need to do a stress test to the server. You can use many ways to achieve this and in my case, I will use the simplest way which is create generate a fake data and insert them into table using stored [...]
If you familiar with MySQL, following are the user privileges which available:
SELECT - Allows reading data
INSERT - Allows inserting and replacing data
UPDATE - Allows changing data
DELETE - Allows deleting data
FILE – Allows importing data from and exporting data into files
CREATE - Allows creating new databases and tables
- Microsoft backtracks on Xbox One sharing policies - CNN 19 June 2013
- Privacy Officials From 7 Nations Question Google On Glass' 'Ubiquitous ... - Huffington Post 19 June 2013
- Microsoft talked with Nokia about buying devices unit - Straits Times 19 June 2013
- Stop bickering over climate and act: World Bank - Brisbane Times 19 June 2013
- Cancer-Resistant Naked Mole Rats Make Tumor Blocking Chemicals - Bloomberg 19 June 2013