Currently viewing the category:
"SQL"
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 [...]
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:
Data
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
Structure
CREATE - Allows creating new databases and tables
[...]
Version
SELECT @@version;
Comments
SELECT 1; #comment SELECT /*comment*/1;
Current User
SELECT user(); SELECT system_user();
List Users
SELECT user FROM mysql.user;
List Password Hashes
SELECT host, user, password FROM mysql.user;
List Privileges
SELECT grantee, privilege_type, is_grantable FROM information_schema.user_privileges; SELECT host, user, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, [...]
My boss wants to duplicate our main database so it can be used by our developer team for our new design project. The database is already run on live system and the developer need to have same contents of database in order to complete the project.
The easiest way to duplicate MySQL database is just [...]
In this post, I am going to show you my implementation on how to achieve high availability MySQL setup with load balancing using HAProxy, Galera cluster, garbd and virtual IP using keepalived.
Actually, the process is similar with my previous post as here, with some added steps to configure HAProxy and garbd. The architecture [...]
In this tutorial, I am going to show you on how to achieve higher MySQL uptime with some help from MySQL Proxy, Galera cluster and virtual IP using keepalived.
Actually, the process is similar with my previous post as here, with some added steps to configure MySQL proxy and virtual IP. The architecture [...]
PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. People will usually comparing PostgreSQL with MySQL, and there are several key factors which let us choose PostgreSQL over MySQL:
[...]
How can we achieve 100% MySQL uptime? For me, I would answer as follow:
Cluster all MySQL servers together Load balance and failover between each of the cluster members Make them run in redundant network line
I have tried to use Galera for active-active multi master replication in previous post. This setup will [...]
Our company has launched an online contest for our dedicated clients and we are collecting some really important information from them in order join the contest. My boss wants me to create a database backup every half an hour to make sure we reduce the data loss chance to the minimum possible.
I have create [...]
I have encounter following error from the MySQL replication monitoring alert:
Error ‘Duplicate entry ’72264-4-10-2011′ for key 1′ on query. Default database: ‘grad_data’. Query: ‘INSERT INTO tblusr_log ( ID,UserType,Stats,Month,Year ) VALUES ( ’72264′,’4′,1,MONTH(NOW()),YEAR(NOW()))’
This situation stopped the data replication process, which cause database in slave server fall behind and not syncing with the database at master [...]
In my environment, MySQL replication is really important because we are splitting different web servers with different database server to balance the load between MySQL servers. It quite traditional ways because this is kind of old database servers which sustain until today.
There is simple way to setup a monitoring script to alert us via [...]
Subscribe via Email
Sci/Tech – Google News- LIVE BLOG: Yahoo New York Press Event - Forbes 20 May 2013
- New Xbox may keep Microsoft in the game - MarketWatch 20 May 2013
- Chinese Hackers Resume Attacks on US Targets - NewsFactor Network 20 May 2013
- Major Tim Peake's pride at becoming the UK's first true astronaut - Mirror.co.uk 20 May 2013
- Sony PlayStation 4 teaser gives gamers first glimpse at Sony's newest console - New York Daily News 20 May 2013
