[MySQL]: Event Scheduler
The MySQL Event Scheduler manages the scheduling and execution of events: Tasks that run according to schedule. Event support was added in MySQL 5.1.6. MySQL Events are tasks that run according to a schedule. Therefore, we sometimes refer…
[MySQL]: Buffering and Caching
MySQL uses several strategies that cache information in memory buffers to increase performance. Depending on your database architecture, you balance the size and layout of these areas, to provide the most performance benefit without wasting memory or exceeding…
[MySQL]: InnoDB Buffer Pool
The InnoDB Buffer Pool InnoDB maintains a buffer pool for caching data and indexes in memory. InnoDB manages the pool as a list, using a least recently used (LRU) algorithm incorporating a midpoint insertion strategy. When room is needed…
[MySQL] : Locking issues
Locking Issues MySQL manages contention for table contents using locking: Internal locking is performed within the MySQL server itself to manage contention for table contents by multiple threads. This type of locking is internal because it is performed entirely…
[MySQL]: How do we set-up Replication
How to Set Up Replication: This section describes how to set up complete replication of a MySQL server. There are a number of different methods for setting up replication, and the exact method to use depends on how you…
[MySQL]: HA and Scalability
Replication: Replication enables data from one MySQL database server (the master) to be replicated to one or more MySQL database servers (the slaves). Replication is asynchronous – slaves need not be connected permanently to receive updates from the master. Depending…
Intro to Spring Data
The spring-data project offer abstraction and unified data access for variety of data sources. Category Sub-project Relational Databases JPA Spring Data JPA – Simplifies the development of creating a JPA-based data access layer JDBC Extensions Support for Oracle RAC, Advanced Queuing,…
PostgreSQL Replication
Refer to http://dbversity.com/postgresql-installation/ for PostgreSQL Installation procedure on your both Master & Slave servers. Replication Now we are testing something that called hot standby replication. Configure the Master Server We will begin by configuring our master server. All of these…
Setting password for MySQL root ID
Once you’re done with MySQL Installation from http://dbversity.com/mysql-rpm-installation/ You can set password for MySQL root ID as below. MySQL installs with no password protection on root access (blanks) We use this method to set it to Winter06 and GPA will…
MySQL stored procedures
What’s a Stored Function If procedural programming is new to you, you may be wondering what the difference is between a Stored Procedure and a Stored Function. Not too much really. A function always returns a result, and can be…