This Log Buffer is dedicated to the top quality news from the arena of Oracle, SQL Server and MySQL.
Oracle:
This Log Buffer Edition covers the weekly blog posts of Oracle, SQL Server and MySQL.
Oracle:
Hi!
Thanks everyone who attended the hands-on lab session on MySQL
Cluster at Oracle OpenWorld today.
The following are the links for the slides, the HOL instructions, and the HOL extra instructions.
Will try to summarize the HOL session below.
Aim of the HOL was to help attendees to familiarize with MySQL
Cluster. In particular, by:
The MySQL Router is a new building block for high availability
solutions. MySQL Router simplifies development of high
availability applications by intelligently routing queries to
MySQL Servers for increased performance, robustness, and uptime.
MySQL Router also helps in load balancing of read or write
transactions to a database with support of multiple router
connections to multiple clients.
There are various use cases where you can use multiple router
connections.
- Write to a DB can be routed using one router and read can be
happened by multiple router connections to have a better
performance and stability
- If client and servers are in specific region , we can use
multiple routers in the specific region
- Different warehouse can be handled by multiple routers
considering the load.
These are few examples usecases. You can define your own usecase
and check if it suites your environment. Also you …
MySQL Fabric is an extensible framework for managing farms of
MySQL Servers. Two primary features have been implemented - High
Availability (HA) and scaling out using data sharding. These
features can be used in isolation or in combination.
MySQL Fabric setup is a process in which you need to run
different commands in a sequence and use the corresponding logs
for future reference. This blog tells about an easy process to do
the initial setup of a Fabric system using config file. You need
to define the properties file as per your requirement and run a
similar python script while will do the setup.
Note: This fabric setup script is basically for release
1.5.6 or less and it is tested in our test environment.
Precondition:
- Fabric manage Setup and manage start is already
triggered.
- Database is created OR shard servers have database already
present.
Properties …
An application always needs support of concurrent connections to
mysql servers and always requires high available system for a
loss less data environment.
The MySQL Router is a new building block for high availability
solutions. MySQL Router simplifies development of high
availability applications by intelligently routing queries to
MySQL Servers for increased performance, robustness, and uptime.
MySQL Router definitely helps in supporting HA and concurrent
connections to servers without any change in the application
level coding irrespective of the servers in a simple topology or
in a fabric distributed server.
In a practical application environment, the data is fetched from
the read-only servers where data is written to read-write
servers. So Router is pre-defined to support similar server
setup. Also it is required connect to the available/next
available server when there is failover and Provide proper logs
to the …
The MySQL Router is a new building block for high availability
solutions. MySQL Router simplifies development of high
availability applications by intelligently routing queries to
MySQL Servers for increased performance, robustness, and
uptime.
MySQL Router also connects seamlessly with MySQL Fabric
permitting Fabric to store and manage the high availability
groups for routing, making it simpler to manage groups of MySQL
Servers for redundancy and
continued operation.Also You do not need specific fabric aware
connectors to do so. You can use generic MySQL Connectors for
this purpose.
Please refer to
http://dev.mysql.com/doc/mysql-router/en/mysql-router-installation.html
to install MySQL Router.
Create a fabric setup using
https://dev.mysql.com/doc/mysql-utilities/1.4/en/fabric-setup.html
How to integrate Router with MySQL Fabric:
you can have one MySQL Fabric state-store …
This Log Buffer Edition covers some more Oracle, SQL Server and MySQL blog posts from across the world.
Oracle:
Many of you are coming to San Francisco next week for Oracle OpenWorld 2015 and many of you have already booked time on your calendars on Wednesday evening before the appreciation event. You are right — the Annual Oracle Bloggers Meetup, one of your favorite events of the OpenWorld, is happening at usual place and time!
What: Oracle Bloggers Meetup 2015.
When: Wed, 28-Oct-2015, 5:30pm.
Where: Main Dining Room, Jillian’s Billiards @ Metreon, 101 Fourth Street, San Francisco, CA 94103 ( …
[Read more]This Log Buffer edition works it way through some of the coolest blog posts from Oracle, SQL Server and MySQL of the past week.
Oracle: