java - Splitting MySQL Database into separate databases -


i have requirement mysql database being used in application scaling aggressively. in no state migrate nosql database.

i have figured out following areas can try splitting current database multiple databases:

  1. there tables have static content, i.e. changes barely.
  2. there user tables store user data upon interaction changes drastically.

now, if split database 2 different databases, how handle transaction? how write data access layer, have connections both databases? application uses spring & hibernate end. there calls join user tables , content tables in current schema.

the architecture follows current structure: controller -> service -> dao layer.

so, if willing refactor dao layer communicates database, approach should follow? know hibernate orm willing letting go if there better hibernate.

multiple databases on same server? approach not improve performance on own. ram, fast disks, optimization, partitioning, , correct indexing have far greater payback.

if have multiple databases on 1 server can connect them single connection, , use database names table names in sql. transactions work fine within single connection.

transactions across multiple connections , multiple servers harder. there's feature in mysql called xa transactions handle this. has plenty of overhead, , therefore useful high-value transactions in banking.

in jargon of trade, adding servers called "scale-out." alternative "scale-up," in add more ram, faster direct-access storage, optimization, , other stuff single server more.

there several approaches can take scale-out problem. classic 1 use mysql single-master multiple-load-balanced slave replication. that's path that's taken, can without reinventing lot of wheels. in solution writing single instance. queries data can use multiple read-only load-balanced instances.

http://dev.mysql.com/doc/refman/5.5/en/replication-solutions-scaleout.html

this popular approach have mix of long-running reporting queries , short-running interactive queries. reporting can run on dedicated slave servers.

another approach multiple-master replication using mysql cluster. https://dev.mysql.com/doc/refman/5.5/en/mysql-cluster-replication-multi-master.html

another approach, if have money spend, go supported mysql cluster. oracle, mariadb, , percona have such products on offer.

scale-out big job no matter how approach it. there's documented experience other people have done it. example, https://www.facebook.com/note.php?note_id=23844338919


Comments

Post a Comment

Popular posts from this blog

Android layout hidden on keyboard show -

i have strange problem layout. when tap on edittext , keyboard shown edittext stay on bottom , when tap on to hide keyboard , keyboard hides , edittext go should when want input text. when tap again, keyboard shown , edittext goes down behind keyboard... <relativelayout android:layout_width="match_parent" android:layout_height="match_parent" > <scrollview android:layout_width="match_parent" android:layout_height="fill_parent" android:above="@+id/rl_commands"> <textview android:layout_width="match_parent" android:layout_height="wrap_content"/> </scrollview> <relativelayout android:layout_width="match_parent android:layout_height="24dp" android:id="@+id/rl_commands" android:alignparentbottom="true">
Read more

google app engine - 403 Forbidden POST - Flask WTForms -

i have flask application running on google app engine. trying submit form built using wtform , keep getting following error. 403 forbidden: don't have permission access requested resource. either read-protected or not readable server. location.html (part of code) <form method=post action="/home/location"> .... <button type="submit" class="btn btn-primary" value="submit"> directions </button> </form> main.py @app.route('/home/location', methods=['post', 'get']) def location(): form = cfcdirections.direction(request.form) print(request.method) if request.method == 'post' , form.validate(): print("after if") directions = cfcdirections() street_no = directions.no street = directions.street suburb = directions.suburb postcode = directions.postcode
Read more

c - Why would PK11_GenerateRandom() return an error -8023? -

i looking through internet trying find source of pk11_generaterandom() function see why function fail. have program uses function when moved new flavor of linux, fails after forking ( fork() ) since not believe there problem nss, suspect doing incorrectly disregarded in older versions of linux new 1 there issue. the openssl package same on 'good' , 'bad' server: openssl 0.9.8e-fips-rhel5 01 jul nss rpm differs though. 'good' has nss-3.12.2.0-2.el5 and bas has version nss-3.15.3-4.el5_10 the 'good' server uses quite obsolete linux: linux 2.6.18-128.el5 #1 smp wed jan 21 08:45:05 est 2009 x86_64 x86_64 x86_64 gnu/linux enterprise linux enterprise linux server release 5.3 (carthage) red hat enterprise linux server release 5.3 (tikanga) the 'bad' server newer: linux bad 2.6.18-371.4.1.el5 #1 smp wed jan 29 11:05:49 pst 2014 x86_64 x86_64 x86_64 gnu/linux oracle linux server release 5.10 red hat enterprise linux server release
Read more