Tagged Questions
0
votes
1answer
36 views
New Database vs New Table for User Registrations
Here's an example, there is this application that completes a task (mostly data-enrty stuff). Users can sign-up on a website to begin using the application straight away.
At the moment, I was looking ...
0
votes
1answer
119 views
Is there an easy way to replicate MySQL data?
My software is deployed in various cities, each have a database, but they have different authorizations such as:
central DB
/\
/ \
DB1 ...
0
votes
0answers
118 views
Hadoop, Hive, Sqoop and MySQL [closed]
I want to start a testing session for performance and maintenance on an architecture that includes these three components:
Hadoop
Hive
Sqoop
to share data from a MySQL database (at the moment ...
2
votes
2answers
116 views
Database structure for a system with multisite
The system I'm working is structured as below. Given that I'm planning to use Joomla as the base.
a(www.a.com),b(www.b.com),c(www.c.com) are search portals which allows user to to search for ...
0
votes
2answers
128 views
Need advises for a new MySQL architecture
I need to deploy a MySQL-based application with the following requirements and would love to receive some guidance (any) as to how I could set things up:
Scale of deployment
5 servers with a ...
3
votes
1answer
95 views
Economic Database Architecture Possibilities w/ Data of Varying Length
I'm in the process of designing a MySQL database (InnoDB) that holds a large amount of economic data which our application scores. The size of the economic data varies a great deal: some measures, ...
1
vote
2answers
85 views
Distributing MySQL database on n systems
I have a webserver in my application which talks to a single MySQL node. Instead of having just one MySQL node, I want to have a cluster of n nodes which form my database.
Is it possible to do ...
2
votes
1answer
324 views
Foreign key with multiple table options
I'm not sure if the title is very good, feel free to suggest a better one.
People can "comment" on different objects of my site,similarly to StackExchange (for example they can comment on a Question, ...
2
votes
1answer
210 views
Redesigning a multi-instance MySQL server for performance and resiliency
I've got a single MySQL server which currently runs N separate MySQL instances on, which are rapidly growing beyond the capabilities of that box.
Is it possible to have an active-active MySQL ...
1
vote
1answer
411 views
MySQL Cluster over WAN: Best Architecture Options?
My company is looking at a multi-data-centre solution for high-availability, fun, and profit.
We have businesses across the planet, with the need for MySQL database clustering solutions that can keep ...
5
votes
2answers
223 views
Recommended structure? %70 write %30 read. 10M row. 200 query/sec. Select, update, insert, search
Followings are what I need to do on my project:
1- If a search term is new and unique, then add the search term
2- Show lastest searched 1000 search terms (I don't need to store dates of all search ...
4
votes
1answer
3k views
MySQL high availability, failover and replication with Latency
We are in the process of implementing a new CMS (Drupal 6.x) that runs on MySQL. We have two data centers -- primary and secondary -- with known latency between them. We're unsure which version of ...
