Showing entries 121 to 130 of 1625
« 10 Newer Entries | 10 Older Entries »
Displaying posts with tag: Oracle (reset)
Log Buffer #447: A Carnival of the Vanities for DBAs

 

This Log Buffer Edition covers the weekly blog posts of Oracle, SQL Server and MySQL.

Oracle:

  • An Index or Disaster, You Choose (It’s The End Of The World As We Know It).
  • SQL Monitoring in Oracle Database 12c.
  • RMAN Full Backup vs. Level 0 Incremental.
  • Auto optimizer stats after CTAS or direct loads in #Oracle 12c.
  • How to move …
[Read more]
Slides of HOL3348 on Getting started with MySQL Cluster

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:

  1. Learning the basics of MySQL Cluster Architecture
  2. Learning the basics of MySQL Cluster Configuration and Administration
  3. Learning how to start a new Cluster for evaluation purposes and how …
[Read more]
Multiple MysqL Routers setup for an application

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 …

[Read more]
MySQL Fabric Automation setup using python script

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 …

[Read more]
Concurrent connections to a MySQL router from connector/python.

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 …

[Read more]
MySQL Fabric integration with Router

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 …

[Read more]
Log Buffer #446: A Carnival of the Vanities for DBAs

This Log Buffer Edition covers some more Oracle, SQL Server and MySQL blog posts from across the world.

Oracle:

  • Should I monitor the MGMTDB database?
  • Connecting MAF Applications to Mobile Cloud Service
  • JRE 6, 7, and 8 now certified with EBS 11i, 12.1, and 12.2
  • The database writer copies data blocks from the buffer cache onto disk. The db_writer_processes initialization parameter determines how many processes will do this task. Its default value is 1 or cpu_count / 8, whichever is greater. I found an Oracle 9 database on a …
[Read more]
Oracle OpenWorld 2015 – Bloggers Meetup

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]
Log Buffer #445: A Carnival of the Vanities for DBAs

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:

  • What if I’m a developer or QA person using a copy of production database to do my work. What if my copy of production is now out of date and I want to refresh my data with the data as it is on production.
  • Direct path and buffered reads again.
  • Copy Data Management for Oracle Database with EMC AppSync and XtremIO.
  • Little things worth knowing: automatic …
[Read more]
Are software benchmarks to blame for Volkswagens woes?

With the recent media attention Volkswagen has gotten, a lot of folks are wondering, how could that happen? Aren’t there checks & balances? Join 32,000 others and follow Sean Hull on twitter @hullsean. Then I ran across this observation on Todd Hoff’s brilliant blog High Scalability Is what Volkswagen did really any different that what … Continue reading Are software benchmarks to blame for Volkswagens woes? →

Showing entries 121 to 130 of 1625
« 10 Newer Entries | 10 Older Entries »